Python List of Strings to MySQL

Question

I am trying to take a list in python and execute it in MySQL:

list = ['tom', 'larry', 'moe']

select * from test.db where name in (list).

I have tried to ",".join the list but it doesn't seem to work.

What is the correct way I can pass a list into MySQL.

mgilson · Accepted Answer · 2014-09-08 16:49:18Z

2

It seems like you'd want to do something like:

subs = ','.join('%s' for _ in lst)
sql = "select * from test.db where name in ({})".format(subs)
cursor.execute(sql, tuple(subs))

answered Sep 8, 2014 at 16:49

mgilson

312k70 gold badges656 silver badges722 bronze badges

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

1 Answer 1