Escaping confusion with Python 3 + MySQL
Νίκος Βέργος
me.on.nzt at gmail.com
Sun Mar 26 04:21:36 EDT 2017
print('''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) )
prints out:
UPDATE visitors SET (pagesID, host, ref, location, useros, browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE "%s" (1, 'cyta.gr', 'Άμεση Πρόσβαση', 'Greece', 'Windows', 'Chrome', '17-03-24 22:04:24', 'cyta.gr')
How should i write the cursor.execute in order to be parsed properly?
As i have it now %s does not get substituted.
i use PyMySQL by the way and i have tried every possible combination even with % instead of a comma but still produces errors.
More information about the Python-list
mailing list