- 连接数据库
首先命令提示符键入pip3 install pymysql。
import pymysql #导入pymysql包
DBHOST = 'localhost'
DBUSER = 'root'
DBPASS = '10011122'
DBNAME = 'dbtest'
try:
db=pymysql.connect(host=DBHOST, user=DBUSER, password=DBPASS, database=DBNAME)
print('数据库成功连接!') #检查是否连接成功
except pymysql.Error as e:
print("数据库连接失败:"+str(e))
输出数据库成功连接!
- 创建一张新表
cur = db.cursor(