Create Table using a variable in python

Question

I would like to use a python output to create table in sqlite3. I've tried some possibilities but the script create tables with the given name. Is it possible to create a table with a variable?

for name in test.all():
    return name

or just

name = 'dbName'
#
conn = sqlite3.connect("my_db")
db = conn.cursor()
db.execute('''CREATE TABLE (here var)(id, column1, column2, column2)''')
conn.commit()
db.close()

you need to look into String concatenation: docs.python.org/2/library/string.html — Frank Thomas
– Frank Thomas, Commented Dec 20, 2015 at 21:09

oz123 · Accepted Answer · 2015-12-21 09:04:30Z

5

Try with string formatting:

sql_cmd = '''CREATE TABLE {}(id, column1, column2, column2)'''.format(
            'table_name')
db.execute(sql_cmd)

Replace 'table_name' with your desire.

answered Dec 21, 2015 at 9:04

oz123

29k30 gold badges133 silver badges196 bronze badges

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

Collectives™ on Stack Overflow

Create Table using a variable in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related