背景:pymysql库创建数据库出错
报错: pymysql.err.ProgrammingError: (1007, "Can't create database 'XXXX'; database exists")
分析:数据库中已经存在该 数据库,删除该库即可创建
实例:
import pymysql db = pymysql.connect(host='localhost',user='root',password='******',port=3306) cursor = db.cursor() cursor.execute('SELECT VERSION()') data = cursor.fetchone() print('Database version:',data) cursor.execute("CREATE DATABASE spiders DEFAULT CHARACTER SET utf8") db.close()