python - [Python]拆分csv文件的元素并插入mysql

Question

我有一个如下所示的 csv 文件:

UnifiedSearch_Pass,UnifiedSearch_Fail,Settings_Pass,Settings_Fail,Map_Overview_Pass,Map_Overview_Fail,Map_Guidance_Pass,Map_Guidance_Fail,RouteBar_Pass,RouteBar_Fail,MainMenu_Pass,MainMenu_Fail,SpeedCameras_Pass,SpeedCameras_Fail,MapManagement_Pass,MapManagement_Fail,AccountManagement_Pass,AccountManagement_Fail,VoiceManagement_Pass,VoiceManagement_Fail,Total_Automated_Tests,Total_Pass,Total_Fail
177,8,57,5,90,6,48,3,48,6,109,12,17,2,14,0,12,0,10,0,624,582,4

这是插入 mysql 的代码:

for row in csv_data:
print row
print row[0]
    sql = "INSERT INTO 'EpicDetails' ('EpicName', 'Result') VALUES (?, ?);"
    cursor.execute (sql, (row[0]))

这给我 TypeError: not all arguments converted during string formatting.

打印行，打印csv文件中的所有元素。打印 row[0] 给出了这个:

UnifiedSearch_Pass
177

我需要在两个不同的列中的行 [0] 中插入上面的值。

任何帮助将不胜感激!谢谢!

Answer 1

如果你想把特定的行放在单独的列中

sql = (
 "INSERT INTO 'EpicDetails' ('EpicName', 'Result') VALUES (?, ?);"
 )
 data = (row[0][0],row[0][1])
 cursor.execute(sql, data)