大一学生,
今天第一次使用pymysql
import pymysql
conn = pymysql.connect(host='localhost',user='root',passwd='*******',charset='utf8')
cursor = conn.cursor()
dbName='test'
sql = 'show databases'
cursor.execute(sql)
dbs = cursor.fetchall()
for db in dbs:
if dbName in db:
cursor.execute('drop database '+dbName)
break
cursor.execute('create database ' +dbName)
conn.select_db(dbName)
用vscode调试到这里就运行不下去了
报错 ProgrammingError: (1007, 'Unknown error 1007')
有高手能帮帮忙吗?