db = pymysql.connect(host='localhost', user='root', password='root111', port=3306, db='temp_my')
cursor = db.cursor()
#
table = 'daili_company'
keys = ','.join(data.keys())
values = ','.join(['%s'] * len(data))
sql = 'INSERT INTO {table}({keys}) VALUES ({values})'.format(table=table,keys=keys,values=values)
try:
if cursor.execute(sql,tuple(a.values())):
print('成功')
db.commit()
except:
print('失败')
db.rollback()
python字典动态插入mysql
最新推荐文章于 2022-07-12 13:58:29 发布