sqlite3.Warning: You can only execute one statement at a time

Question

I get the error when running this code:

import sqlite3  user_name = raw_input("Please enter the name: ") user_email = raw_input("Please enter the email: ")  db = sqlite3.connect("customer") cursor=db.cursor()  sql = """INSERT INTO customer         (name, email) VALUES (?,?);,          (user_name, user_email)"""  cursor.execute(sql) 

Why is this happening?

Answer 1

While the other posters are correct about your statement formatting you are receiving this particular error because you are attempting to perform multiple statements in one query (notice the ; in your query which separates statements).

From Python sqlite3 docs:

"execute() will only execute a single SQL statement. If you try to execute more than one statement with it, it will raise a Warning. Use executescript() if you want to execute multiple SQL statements with one call."

https://docs.python.org/2/library/sqlite3.html

Now your statement will not execute properly even if you use executescript() because there are other issues with the way it is formatted (see other posted answers). But the error you are receiving is specifically because of your multiple statements. I am posting this answer for others that may have wandered here after searching for that error.

Answer 2

Use executescript instead of execute

execute() will only execute a single SQL statement. If you try to execute more than one statement with it, it will raise a Warning. Use executescript() if you want to execute multiple SQL statements with one call.

https://docs.python.org/2/library/sqlite3.html#sqlite3.Cursor.execute