SQLwith python OperationalError (sqlite)

Question

import sqlite3

conn = sqlite3.connect('MyIndex.db')

c = conn.cursor()

def insert(t, f, d):
    with conn:
        c.execute("INSERT INTO Index VALUES (:t, :frequency, :docID)", {'t': t, 'f': f, 'd': d})


insert('apple', 1, '1/2')

conn.close()

I am using SQLite to build a simple database. I have trouble with the insert function. It keeps showing that:

sqlite3.OperationalError: near "Index": syntax error

But I failed to find any syntax error in my code. Can someone tell me how to fix it? Thanks in advance.

Ignacio Vazquez-Abrams · Accepted Answer · 2018-05-15 18:39:18Z

1

"INDEX" is a reserved word in SQL.

INSERT INTO `Index` VALUES ...

answered May 15, 2018 at 18:39

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

Comments

IAmGroot · Accepted Answer · 2018-05-15 18:44:11Z

0

Try putting Index in single quotes like this:

c.execute("INSERT INTO 'Index' VALUES (:token, :frequency, :docID)", {'token': token, 'frequency': frequency, 'docID': docID})

Index is a reserved keyword.

answered May 15, 2018 at 18:44

IAmGroot

914 bronze badges

Collectives™ on Stack Overflow

SQLwith python OperationalError (sqlite)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related