检查数据库是否存在
检查数据库是否存在详细操作教程
以下实例为学习检查数据库是否存在,具体代码如下:
# Filename : example.py
# Author by : www.lidihuo.com
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="myusername",
passwd="mypassword"
)
mycursor = mydb.cursor()
mycursor.execute("SHOW DATABASES")
for x in mycursor:
print(x)
执行以上代码输出结果为:
# Filename : example.py
# Author by : www.lidihuo.com
('information_scheme',)
('mydatabase',)
('performance_schema',)
('sys',)