sqlite3.OperationalError in Python 3 when creating table

Question

The following code shows up this error when run.

Error:

 INTEGER PRIMARY KEY LadID)""".format(usr))
 sqlite3.OperationalError: near "LadID": syntax error

Code:

c.execute("""CREATE TABLE {}
        (LadID INTEGER,
        foreName TEXT,
        surname TEXT,
        interests INTEGER,
        gender TEXT,
        mob INTEGER
        INTEGER PRIMARY KEY (LadID))""".format(usr))

What is the solution?

Kasravnd · Accepted Answer · 2015-07-09 09:21:07Z

1

Seems that you have omitted a comma after mob INTEGER also you need to change the last column to LadID INTEGER PRIMARY KEY.

Note that you should put your column name at the start of column definition and don't need to parenthesis.

c.execute("""CREATE TABLE {}
        (LadID INTEGER,
        foreName TEXT,
        surname TEXT,
        interests INTEGER,
        gender TEXT,
        mob INTEGER,
        LadID INTEGER PRIMARY KEY)""".format(usr))

edited Jul 9, 2015 at 9:21

answered Jul 9, 2015 at 9:01

Kasravnd

108k19 gold badges167 silver badges195 bronze badges

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

5 Comments

Tom Haines Over a year ago

But now I get this: sqlite3.OperationalError: near "(": syntax error

Kasravnd Over a year ago

Why you have putted LadID within parenthesis? in INTEGER PRIMARY KEY (LadID)

Tom Haines Over a year ago

Without the parenthesis I get sqlite3.OperationalError: near "LadID": syntax error

user1602492 Over a year ago

It can be LadID INTEGER PRIMARY KEY anyway.

Kasravnd Over a year ago

@TomHaines marcus is right you need to put the column name on first LadID INTEGER PRIMARY KEY

Collectives™ on Stack Overflow

sqlite3.OperationalError in Python 3 when creating table

Error:

Code:

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Error:

Code:

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related