Getting Error in cursor.execute while using mysql.connector in python

Question

How to solve this problem: I am getting error like EOF etc while executing the below code ----

My code is:

import mysql.connector as sql

db_con=sql.connect(host="localhost",user="root",passwd="XXXX",database="mydb")

db_cur=db_con.cursor()

db_cur.execute('"update Orders set Freight=case when ShipCountry='USA' then      Freight+(0.15*Freight)"' `" when ShipCountry='Canada' then Freight+(0.15*Freight)"``" when ShipCountry='France' then Freight+(0.10*Freight)"``" when ShipCountry='Germany' then Freight+(0.10*Freight)"``" when ShipCountry='Belgium' then Freight+(0.10*Freight)"``" else Freight+(0.05*Freight) end"`


how to solve?????

Please extend the sample of your code — at least to your erroneous line 14. — MarianD
– MarianD, Commented Feb 29, 2020 at 9:21

Aman Raheja · Accepted Answer · 2020-02-29 09:03:43Z

1

Please close the brace for db_cur.execute() and follow the steps below.

Commit to the query
Close the cursor
Close the connection.

answered Feb 29, 2020 at 9:03

Aman Raheja

6157 silver badges17 bronze badges

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

Comments

Vishnu Kiran · Accepted Answer · 2020-02-29 09:14:05Z

1

You need to commit INSERT and UPDATE queries and also close the connection after you are done.

It is best to use context managers

Like so:

import mysql.connector as sql
db_con=sql.connect(host="localhost",user="root",passwd="Redmilenovo#T",database="datagrokr")
with db_con.cursor() as cursor:
    cursor.execute("""YOUR QUERY HERE""")

db_con.commit()
db_con.close()

You can also define the connection variable in a context manager as well.

answered Feb 29, 2020 at 9:14

Vishnu Kiran

6527 silver badges15 bronze badges

1 Comment

Fotis Kolytoumpas Over a year ago

I was not getting any error, but I forgot to commit & close :')

Welcome_back · Accepted Answer · 2020-02-29 09:27:24Z

0

EOF stands for End Of File. This error usually means that there was an open parenthesis somewhere on a line, but not a matching closing parenthesis.

db_cur.execute('"update Orders set Freight=case when ShipCountry='USA' then      Freight+(0.15*Freight)"' `" when ShipCountry='Canada' then Freight+(0.15*Freight)"``" when ShipCountry='France' then Freight+(0.10*Freight)"``" when ShipCountry='Germany' then Freight+(0.10*Freight)"``" when ShipCountry='Belgium' then Freight+(0.10*Freight)"``" else Freight+(0.05*Freight) end"`

if you observe their no close parenthesis

answered Feb 29, 2020 at 9:27

Welcome_back

1,47515 silver badges21 bronze badges

Collectives™ on Stack Overflow

Getting Error in cursor.execute while using mysql.connector in python

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related