Escaping confusion with Python 3 + MySQL

[Νίκος Βέργος]

Τη Κυριακή, 26 Μαρτίου 2017 - 10:56:07 μ.μ. UTC+3, ο χρήστης Chris Angelico έγραψε:
> On Mon, Mar 27, 2017 at 6:33 AM, Νίκος Βέργος <me.on.nzt at gmail.com> wrote:
> > Since i'm incopetent as you suggest i'am show us your level of skills and expertise and provide a solution, otherwise you are also what you claim of me.
> 
> It's not his problem. An expert does not have to provide solutions to
> prove his expertise, unless s/he is suffering from severe self-image
> problems. Someone who's getting paid to host other people's web sites,
> on the other hand, needs to solve the problems that come up.
> 
> ChrisA

Okey although i beleive my UPDATE query to be correct i'll now try this:

cur.execute('''UPDATE visitors SET pagesID=%s, host=%s, ref=%s, location=%s, useros=%s, browser=%s, visits=%s WHERE host LIKE %s''', (pID, domain, ref, location, useros, browser, lastvisit, domain_query) )