Python sqlite3 OperationalError in a simple table create

Question

here is the code

def __init__(self):
    self._db = sqlite3.connect("Reservation.db")
    self._db.row_factory = sqlite3.Row
    self._db.execute("create table if not exists Ticket(ID integer primary key autoincrement, Name text, Gender text, Order text)")#create a table called Ticket with 4 columns
    self._db.commit()

the proplem

self._db.execute("create table if not exists Ticket(ID integer primary key autoincrement, Name text, Gender text, Order text)") sqlite3.OperationalError: near "Order": syntax error

Mureinik · Accepted Answer · 2020-03-16 22:38:28Z

0

order is a reserved word in SQL. I suggest you find a different name, that isn't a reserved word (e.g., order_text) for the column. If you absolutely must use this name, you can escape it by surrounding it with double quotes ("):

self._db.execute("create table if not exists Ticket(ID integer primary key autoincrement, Name text, Gender text, \"Order\" text)
# Here -----------------------------------------------------------------------------------------------------------^------^

answered Mar 16, 2020 at 22:38

Mureinik

316k54 gold badges400 silver badges405 bronze badges

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

Collectives™ on Stack Overflow

Python sqlite3 OperationalError in a simple table create

here is the code

the proplem

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

here is the code

the proplem

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related