python sqlite creation of a table syntax error

Question

I am working on creating a new table within my database. I have done this before when creating other tables but this time I am facing a syntax error. As far as i can see, the syntax is correct. So, I cannot figure it out.

Below, there is a code snippet of the statement that is throwing the error:

cursor.execute('''
    CREATE TABLE IF NOT EXISTS order(
    orderID INTEGER PRIMARY KEY,
    productname STRING,
    productprice FLOAT,
    productquanitity INTEGER,
    producttotal INTEGER;''')

This is the error:

Exception in Tkinter callback
Traceback (most recent call last):
  File "C:\Python34\lib\tkinter\__init__.py", line 1533, in __call__
    return self.func(*args)
  File "N:/NEW/cashregister.py", line 42, in okitem
    producttotal INTEGER;''')
sqlite3.OperationalError: near "order": syntax error

I would be grateful for some suggestions on why this has occurred.

Martijn Pieters · Accepted Answer · 2018-10-12 14:40:42Z

2

order is a reserved keyword in SQL; see the documentation for the full list of reserved keywords that SQLite uses.

Use "order" to make SQLite understand that it is to be interpreted as a table name. You also forgot a closing ):

CREATE TABLE IF NOT EXISTS "order" (
    orderID INTEGER PRIMARY KEY,
    productname STRING,
    productprice FLOAT,
    productquanitity INTEGER,
    producttotal INTEGER
)

edited Oct 12, 2018 at 14:40

answered Oct 12, 2018 at 14:38

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

2 Comments

chepner Over a year ago

There's also a missing closing paren, which will be the next syntax error to pop up.

benisbestpokemongo Over a year ago

dont worry have found it

Collectives™ on Stack Overflow

python sqlite creation of a table syntax error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related