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... Tony On Sat, Sep 12, 2009 at 12:50 PM, yogibabu <madra...@interia.pl> wrote: > > my dream is to be able do it like that: > <?php > $pdo = new PDO('sqlite:database.DB3'); > $pdo->query("INSERT UPDATE table SET value1='somedata', value2=somedata, > id=$getid ") > ?> > > when $getid contains data (a number of course) then an update is performed, > otherwise if it is null then database engine ignores `id` valule without any > notification and INSERT is performed with adding new id... > -- > View this message in context: > http://www.nabble.com/one-liner-for-insert-or-update---tp25416164p25416164.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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users