批量执行sql+批量执行

#批量执行sql
sql = 'insert into seq(blue,red) values (%s,%s)'
all_res=[
['16','01,02,03,04,05,06'],
['16','01,02,03,04,05,06'],
['16','01,02,03,04,05,06'],
]
cur.executemany(sql ,all_res)
conn.commit()

需要二维数组
posted @ 2018-08-12 16:53  罗南  阅读(726)  评论(0)    收藏  举报