import sys
sys.path.append('D:\python_test_live')
import pymysql
from course.customer import dict_data_richer,dict_data_course
# 创建连接对象
db = pymysql.connect(host='xxxx', port=xxx, user='xxx',
password='xxx', database='xxx', charset='utf8')
# 获取游标对象
cursor = db.cursor()
i = 0
while i<30 :
img = dict_data_richer[i]["cover"]
cid = dict_data_course[i]["id"]
# 事务处理
sql = "INSERT INTO `table_name` (`user_id`, `course_id`, `certificate_img_url`, `finished_learn_at`, `created_at`, `updated_at`) VALUES (15896317, '{0}','{1}', '1622709362', '1622709362', '1622709362')".format(cid,img)
cursor.execute(sql)
db.commit()
i = i+1
# 关闭连接
cursor.close()
python3 批量执行参数化insert语句
最新推荐文章于 2023-07-04 14:23:49 发布