好了,您需要构建以下行:
INSERT INTO ... VALUES (1,7,3000), (1,8,3500), (1,9,3900)
试试那个:
rows = [(1,7,3000), (1,8,3500), (1,9,3900)]
values = ', '.join(map(str, rows))
sql = "INSERT INTO ... VALUES {}".format(values)
使用Tuples的Python列表将多行插入数据库
好了,您需要构建以下行:
INSERT INTO ... VALUES (1,7,3000), (1,8,3500), (1,9,3900)
试试那个:
rows = [(1,7,3000), (1,8,3500), (1,9,3900)]
values = ', '.join(map(str, rows))
sql = "INSERT INTO ... VALUES {}".format(values)