MySQL INSERT INTO using Jupyter Notebook ERROR: Invalid syntax

Question

The following code was run in the Jupyter Notebook.

import pandas
import pymysql

connection = pymysql.connect(host='localhost', user='root', password='123456', database='sakila')

cursor=connection.cursor()

insert_query= INSERT INTO film_text (film_id, title, description) VALUES ('1001','ZZZ ZORRO','Zorro must Fight a Womanizer in Berlin');

cursor.execute(insert_query)

connection.commit()

ERROR: File "", line 7 insert_query=INSERT INTO film_text (film_id,title,description) VALUES ('1001','ZZZ ZORRO','Zorro must Fight a Womanizer in Berlin'); ^ SyntaxError: invalid syntax

Please provide the full error message with your code. It will help others find the bug easily. — Tanmoy Krishna Das
– Tanmoy Krishna Das, Commented Jan 19, 2019 at 5:26
Looks like you have the table name surrounded by single quotes. Table and field names can have backticks but not quotes, single or double. — CharlesEF
– CharlesEF, Commented Jan 19, 2019 at 6:06
I removed the single quotes, and reran, but received another "Invalid Syntax" error. — JavaMon
– JavaMon, Commented Jan 19, 2019 at 6:55

Kamalesh M. Talaviya · Accepted Answer · 2019-01-19 09:33:23Z

1

You can also directly write your code like this

cursor.execute("""INSERT INTO film_text (film_id, title, description) VALUES ('1001','ZZZ ZORRO','Zorro must Fight a Womanizer in Berlin'""");

edited Jan 19, 2019 at 9:33

Kamalesh M. Talaviya

1,4201 gold badge14 silver badges27 bronze badges

answered Jan 19, 2019 at 9:18

user10753483

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

Comments

Tanmoy Krishna Das · Accepted Answer · 2019-01-19 10:15:46Z

1

You forgot to wrap the query in quotes. The following code should work perfectly:

import pandas
import pymysql

connection = pymysql.connect(host='localhost', user='root', password='123456', database='sakila')

cursor=connection.cursor()

insert_query= "INSERT INTO film_text (film_id, title, description) VALUES ('1001','ZZZ ZORRO','Zorro must Fight a Womanizer in Berlin');"

cursor.execute(insert_query)

answered Jan 19, 2019 at 10:15

Tanmoy Krishna Das

6706 silver badges18 bronze badges

Comments

Rajan saha Raju · Accepted Answer · 2019-01-19 11:46:45Z

1

The type of insert_query will be a string.

insert_query = "INSERT INTO film_text (film_id, title, description) VALUES ('1001','ZZZ ZORRO','Zorro must Fight a Womanizer in Berlin')"

answered Jan 19, 2019 at 11:46

Rajan saha Raju

8509 silver badges15 bronze badges

1 Comment

JavaMon Over a year ago

Putting double quotes around the insert_query, to make it a string, solved the problem.

ScaisEdge · Accepted Answer · 2019-01-19 07:45:58Z

0

you should warp the query string in quote

insert_query= "INSERT INTO film_text (film_id, title, description) 
      VALUES ('1001','ZZZ ZORRO','Zorro must Fight a Womanizer in Berlin')";

answered Jan 19, 2019 at 7:45

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Comments

robert · Accepted Answer · 2021-03-08 17:04:21Z

0

If don't plan to do highly advanced stuff with the data from python, maybe it's better to use a jupyter kernel to play with the database in plain SQL.

answered Mar 8, 2021 at 17:04

robert

213 bronze badges

Collectives™ on Stack Overflow

MySQL INSERT INTO using Jupyter Notebook ERROR: Invalid syntax

connection.commit()

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

connection.commit()

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related