Python如何创建新数据库？

本文概述

• 获取现有数据库列表
• 创建新数据库

在本教程的这一部分中, 我们将创建新的数据库PythonDB。

获取现有数据库列表

我们可以使用以下MySQL查询来获取所有数据库的列表。

>  show databases;

例子

import mysql.connector

#Create the connection object 
myconn = mysql.connector.connect(host = "localhost", user = "root", passwd = "google")

#creating the cursor object
cur = myconn.cursor()

try:
    dbs = cur.execute("show databases")
except:
    myconn.rollback()
for x in cur:
    print(x)
myconn.close()

输出

('EmployeeDB', )
('Test', )
('TestDB', )
('information_schema', )
('srcmini', )
('srcmini1', )
('mydb', )
('mysql', )
('performance_schema', )
('testDB', )

创建新数据库

可以使用以下SQL查询创建新数据库。

>  create database <database-name>

例子

import mysql.connector

#Create the connection object 
myconn = mysql.connector.connect(host = "localhost", user = "root", passwd = "google")

#creating the cursor object
cur = myconn.cursor()

try:
    #creating a new database
    cur.execute("create database PythonDB2")

    #getting the list of all the databases which will now include the new database PythonDB
    dbs = cur.execute("show databases")
    
except:
    myconn.rollback()

for x in cur:
        print(x)
        
myconn.close()

输出

('EmployeeDB', )
('PythonDB', )
('Test', )
('TestDB', )
('anshika', )
('information_schema', )
('srcmini', )
('srcmini1', )
('mydb', )
('mydb1', )
('mysql', )
('performance_schema', )
('testDB', )