好了,您需要构建以下行:
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)
好了,您需要构建以下行:
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)