sqlite inserting values into a table from python

Question

cur.execute("Create table emails(email text, name text, count integer);")
 
cur.execute('''insert into table emails(email, name, count) values(?,?,0)''',(email,name,))

this gives me this traceback

Traceback (most recent call last): File "c:\Users\ibrah\OneDrive\Desktop\python course\my code\database.py", line 20, in cur.execute('''insert into table emails(email, name, count) values(?,?,0)''',(email,name,)) sqlite3.OperationalError: near "table": syntax error

I don't know why it is wrong

the command is INSERT INTO emails (...) VALUES (...) so get rid of the word table — nbk
– nbk, Commented Feb 7, 2024 at 12:40

jayminnie · Accepted Answer · 2024-02-07 12:48:24Z

0

INSERT INTO table (column1,column2 ,..)
VALUES( value1, value2 ,...);

You should replace "table" with the name of the table you want the items to be stored in.

To this:

INSERT INTO emails(email, name, count) VALUES(?,?,0)

answered Feb 7, 2024 at 12:48

jayminnie

366 bronze badges

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

Collectives™ on Stack Overflow

sqlite inserting values into a table from 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