记住五步走操作:
import MySQLdb # mysqlclient
# 1. 创建链接
conn = MySQLdb.connect(host='localhost',
db='xiaoshuo',
user='root',
password='123',
charset='utf8')
# 2. 创建游标
cursor=conn.cursor()
# 3. 执行sql
sql='insert into bqg (xs_name,zj_name,xs_content) values (%s,%s,%s)'
cursor.execute(sql,args=['hehe','haha','xiaobo'])
# 4. 事务提交
conn.commit()
# 5. 关闭资源
cursor.close()
conn.close()