Escaping confusion with Python 3 + MySQL

Νίκος Βέργος me.on.nzt at
Sun Mar 26 13:10:56 EDT 2017

I do not see why my UPDATE fails.

cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros,
browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s)''') works

i dont have to update table set column1 = this value, column2=that value
and so on

It's just when the LIKE clause jumps in that is causing all this trouble....

How would you write it?!

Στις Κυρ, 26 Μαρ 2017 στις 8:05 μ.μ., ο/η INADA Naoki <
songofacandy at> έγραψε:

> Read my mail again.
> > This error came from MySQL.  If there are no logs in error_log, it's
> > your configuration issue.
> > See for Update
> > statement syntax.
What is now proved was at first only imagined!

More information about the Python-list mailing list