Escaping confusion with Python 3 + MySQL
me.on.nzt at gmail.com
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 gmail.com> έγραψε:
> Read my mail again.
> > This error came from MySQL. If there are no logs in error_log, it's
> > your configuration issue.
> > See https://dev.mysql.com/doc/refman/5.7/en/update.html for Update
> > statement syntax.
What is now proved was at first only imagined!
More information about the Python-list