使用python往mysql批量插入數據時,報錯not all arguments converted我用這段命令可以往mysql數據庫插入數據insert into moderation_task(id, media_id, user_id, media_url_or_path, media_title, media_source,
created, updated, status, is_del) values(105, 75, 1, '/audit_source/origin_video/2360deca955311e8bbd966d3bcd97028.mp4', '006.mp4', 'abc', '2018-08-01 06:21:37', '2018-08-01 06:21:37', 0, 0)但是無法使用python進行數據插入這是我的python代碼users_values = [] for i in range(105, 195, 1):
users_values.append((i, 75, 1, '/audit_source/origin_video/2360deca955311e8bbd966d3bcd97028.mp4', '006.mp4', 'abc', '2018-08-01 06:21:37', '2018-08-01 06:21:37', 0, 0)) print(users_values)
cs1.executemany('insert into moderation_task(id, media_id, user_id, media_url_or_path, media_title, media_source, created, updated, status, is_del) value(%s, %s, %s, %s, %s, %s, %s, %s, %s)',
users_values)每次都是這個錯誤
2 回答

月關寶盒
TA貢獻1772條經驗 獲得超5個贊
cs1.executemany('insert into moderation_task(id, media_id, user_id, media_url_or_path, media_title, media_source, created, updated, status, is_del) value(%s, %s, %s, %s, %s, %s, %s, %s, %s)',users_values)
字段有10個,格式化的值只有9個吧
cs1.executemany('insert into moderation_task(id, media_id, user_id, media_url_or_path, media_title, media_source, created, updated, status, is_del) value(%s, %s, %s, %s, %s, %s, %s, %s, %s,%s)',users_values)
另外檢查一下格式化的數據和數據庫的數據類型,大概。
添加回答
舉報
0/150
提交
取消