how to use table name as variable in insert query statement in python with sqlite3 as database ( don't use concatenation of strings

Asked Jan 20 '14 at 09:11

Active Jan 20 '14 at 09:30

Viewed 642 times

cur.execute(
    "INSERT INTO  tool1 ( USERID , USER_NAME , GROUP_NAME) VALUES (108535, ? , ? )",
     ( userName, groupName ) );

tool1 needs to be variable

edited Jan 20 '14 at 09:30

Melon

asked Jan 20 '14 at 09:11

user3214392

2

Why do you not want to use string concatenation? – Daniel Jan 20 '14 at 09:12
`cur.execute("INSERT INTO %s (USERID , USER_NAME , GROUP_NAME) VALUES (108535, ? , ?)" % table_name, (userName, groupName))` or `cur.execute("INSERT INTO {} (USERID , USER_NAME , GROUP_NAME) VALUES (108535, ? , ?)".format(table_name), (userName, groupName))` ? – falsetru Jan 20 '14 at 09:32

0 Answers0