UIT DEVELOPMENT wrote: > > Are you wanting something like this: > > 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... >
sqlite error 1 - near "ON": syntax error -- View this message in context: http://www.nabble.com/one-liner-for-insert-or-update---tp25416164p25431264.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users