Syntax error when creating database SQLite python

Question

This is my code:

conn.execute("""
        CREATE TABLE IF NOT EXISTS Blockchain_transactions(
        hash_of_previous_block CHAR PRIMARY KEY DEFAULT NULL,
        id INTEGER DEFAULT NULL,
        transaction CHAR DEFAULT NULL
    );""")

It generates a syntax error

sqlite3.OperationalError: near "transaction": syntax error

REMARK: This comes earlier in my code and does not generate the same error

conn.execute("""
        CREATE TABLE IF NOT EXISTS Blockchain_blocks (
        hash_of_previous_block CHAR PRIMARY KEY DEFAULT NULL,
        proof_of_work INTEGER DEFAULT NULL,
        difficulty INTEGER DEFAULT NULL
    );""")

Mike Scotty · Accepted Answer · 2017-12-10 13:28:47Z

4

transaction is a sqlite keyword.

Change the column name to something different and it will work.

Avoid reserved keywords for column names, or escape them like this:

conn.execute("""
    CREATE TABLE IF NOT EXISTS Blockchain_transactions(
    hash_of_previous_block CHAR PRIMARY KEY DEFAULT NULL,
    id INTEGER DEFAULT NULL,
    `transaction` CHAR DEFAULT NULL
);""")

Other possibilities to escape / quote keywords can be found in the linked keywords page.

edited Dec 10, 2017 at 13:28

answered Dec 10, 2017 at 13:22

Mike Scotty

10.8k5 gold badges41 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

Syntax error when creating database SQLite 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