Geez.  I am sorry.  You are correct.  This is MySQL.   Sorry about
that and to the OP.   (banging forehead with open faced palm of my
hand!!!)

Tony

On Sun, Sep 13, 2009 at 6:56 PM, Jean-Christophe Deschamps
<j...@q-e-d.org> wrote:
>
>
> ´¯¯¯
>>INSERT INTO 'mytable' (key, 'visitorcount', 'visitdate')
>>VALUES (123456789, 1, NOW())
>>ON DUPLICATE KEY UPDATE 'visitorcount' = 'visitorcount' + 1
>>
>>the key statement being: ON DUPLICATE KEY UPDATE
>>
>>not tested but it seems like that is what you are looking for.  Its
>>sometimes refered to "upsert" processing...
> `---
>
> Is this _really_ a SQLite syntax?
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to