How to generate for UPDATE statement with IN operator substitute values?

Question

I have to update rows which match fields using IN operator using python ?

UPDATE <tablename> WHERE fields in (<multiple values separated by comma>)

How can I generate my query which are separated by comma ?

score 0 · Answer 1 · answered Mar 01 '14 at 14:10

0

You can make:

values = [1,2,3]

query = "UPDATE <tablename> WHERE fields in ("+",".join(values)+")"

answered Mar 01 '14 at 14:10

Don't put values directly in the query; use SQL parameters instead. Always. – Martijn Pieters Mar 01 '14 at 14:18
this will improve something? – Mohamed Abd El Raouf Mar 01 '14 at 14:19

1 Answers1