´¯¯¯
>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

Reply via email to