MySql: Inserting python lists into a table

Question

How do I insert these 2 lists into different SQL columns of the same table

a = [1,2,3]
b = [4,5,6]

This is the way to insert one list into a column

query = "INSERT INTO tableName (col1) VALUES (%s)"
cursor.executemany(query, [(r,) for r in a])

I can't seem to figure out how to insert both the lists into the table, I want list a to be in one column and list b to be in other column

Booboo · Accepted Answer · 2020-09-18 21:27:02Z

2

query = "INSERT INTO tableName (col1, col2) values (%s, %s)"
cursor.executemany(query, [(x, y) for x, y in zip(a, b)])

answered Sep 18, 2020 at 21:27

Booboo

45.6k4 gold badges46 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Promaster · Accepted Answer · 2020-09-18 23:15:13Z

0

I would do something like this:

query = "INSERT INTO sometable (somecol, somecol2) values (something, something)"
cursor.executemany(query, [(v, x) for v, x in zip(t, h)])

answered Sep 18, 2020 at 23:15

Promaster

1402 silver badges17 bronze badges