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',)
('javatiku',)
('javatiku1',)
('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',)
('javatiku',)
('javatiku1',)
('mydb',)
('mydb1',)
('mysql',)
('performance_schema',)
('testDB',)