Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

def insert_into_db(url, title, description, keywords):
    con = sqlite3.connect('index.db')
    c = con.cursor()
    create = r'''CREATE TABLE IF NOT EXISTS index (id INTEGER NOT NULL AUTO_INCREMENT,url VARCHAR,description TEXT,keywords TEXT);INSERT INTO index(url, title, description, keywords)VALUES('{}','{}',{}','{}');'''.format(url, title,description, keywords)
    c.execute(create)
    con.commit()
    con.close()
INDEX is a keyword in SQLite3. Thus, it'll be parsed as a keyword. There are several ways around this, though.
According to the documentation, you could use backticks or quote marks to specify it as a table name. For example,
CREATE TABLE IF NOT EXISTS `index` ...
CREATE TABLE IF NOT EXISTS "index" ...
may work.
You can pass arguments to your sql statement from the execute() command. Thus,
create = r'''CREATE TABLE ... VALUES(?,?,?,?);'''  # use ? for placeholders
c.execute(create, (url, title, description, keywords))  # pass args as tuple
This is more secure compared to formatting your arguments directly with Python.
Note also that SQLite's syntax for autoinc is AUTOINCREMENT without the underscore and they require the field to also be an INTEGER PRIMARY KEY.
                when i add backticks and run it ,i get this error-sqlite3.OperationalError: near "AUTO_INCREMENT": syntax error
– user10737288
                Dec 25, 2018 at 6:07
                @SakithKarunasena You'll need PRIMARY KEY right after INTEGER. (You can also drop the NOT NULL since the pkey makes it redundant.
– TrebledJ
                Dec 25, 2018 at 6:34
                All rowid table INTEGER PRIMARY KEY columns auto increment, btw. The AUTOINCREMENT keyword isn't needed unless you specifically want the changes it causes in the normal behavior: sqlite.org/autoinc.html
– Shawn
                Dec 25, 2018 at 8:21
                when i change the table name to search_index and run it i get this error-sqlite3.OperationalError: near "AUTO_INCREMENT": syntax error
– user10737288
                Dec 25, 2018 at 6:03
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.