· 5 years ago · Jun 25, 2020, 03:16 PM
1import sqlite3
2
3conn = sqlite3.connect(":memory:")
4cursor = conn.cursor()
5
6name_table = "TEST_TABLE"
7# sqlite3.OperationalError: near "?": syntax error
8sql = """CREATE TABLE IF NOT EXISTS ? (time TIME NOT NULL);"""
9
10cursor.execute(sql, (name_table,))
11conn.commit()
12
13conn.close()