Cannot UPDATE the mySQL table: python

Question

I am executing the command

light='L1'
status='on'
c.execute("UPDATE my_table SET %s=%s WHERE user IN('Ali')", (light,status))

it throws me an error:

(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''L2'='OFF' WHERE user IN('Ali')' at line 1")

Can anyone find out where i am doing the mistake.

I tried to find the similar question on Stack overflow website, but couldn't got any help. So kindly don't mark it as duplicate if anyone find it out.

Che Burashka · Accepted Answer · 2016-02-03 11:10:52Z

3

i think you should get rid of quote signs here:

''L2'

as MySQL said:

near ''L2'='OFF' WHERE user IN('Ali')

Here we go:

light='L1'
status='on'
sql = "UPDATE my_table SET %s=%%s WHERE user IN('Ali')" %light
c.execute(sql, (status))

edited Feb 3, 2016 at 11:10

answered Feb 3, 2016 at 11:00

Che Burashka

465 bronze badges

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

2 Comments

Anum Sheraz Over a year ago

Yes I observed the same thing, but how do i get rid of that ?,

Che Burashka Over a year ago

you should NOT use column_names as parameters in the "execute" function

Collectives™ on Stack Overflow

Cannot UPDATE the mySQL table: python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related