"Νίκος Βέργος" wrote in message
news:8c5f0443-c61b-4059-8d6f-576152d59...@googlegroups.com...
cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros,
browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE
%s''',
(pID, domain, ref, location, useros, browser, lastvisit, domain) )
As if i have a syntactical error in someplace which i'am faling to see or
PyMySQL wants special treatment regarding escaping special characters.
I don't know MySQL, but for most RDBMS's, the construction you show only
works for INSERT statements.
For UPDATE, you usually have to say -
UPDATE {table} SET col_1 = val_1, col_2 = val_2 WHERE col_3 = val_3 ...
Frank Millman
--
https://mail.python.org/mailman/listinfo/python-list