#coding=utf-8
import MySQLdb
import datetime
db = MySQLdb.connect("localhost","root","123456","test",charset = 'utf8')
cursor = db.cursor()
sql="sql语句"
try:
# 执行sql语句
cursor.execute(sql)
# 提交到数据库执行
db.commit()
except:
# Rollback in case there is any error
db.rollback()
# 关闭数据库连接
db.close()
print("添加数据到mysql成功了")
print(datetime.datetime.now())
python2 往mysql插入数据
最新推荐文章于 2022-06-17 00:32:40 发布