mysql solution

Lele Gaifax lele at metapensiero.it
Thu Jan 24 08:37:24 EST 2013


Ferrous Cranus <nikos.gr33k at gmail.com> writes:

> The following statement fails.
>
> [code]
> cursor.execute( '''INSERT INTO counters(page, hits) VALUES(%s, %s) RETURNING (pin) 
>                         ON DUPLICATE KEY UPDATE hits = hits + 1''', (htmlpage, 1) )
> [/code] 

How? What's the error message/traceback?

If, as Chris said, MySQL does not support the “RETURNING” syntax, you
cannot use that. I gave two different solutions in my previous message,
did you try the “simplest” one?

ciao, lele.
-- 
nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri
real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia.
lele at metapensiero.it  |                 -- Fortunato Depero, 1929.




More information about the Python-list mailing list