Luigi Rosa <[email protected]> wrote:
> I was expecting an UPDATE...WHERE but I got this:
> INSERT INTO mailbox (lastlogin,username) VALUES ('1413647370','username') ON
> DUPLICATE KEY UPDATE lastlogin='1413647370'
> This is not very useful if I want a `lastlogin` field of the `mailbox` table
> updated on every login.
This SQL query looks correct to me. It INSERTs a new row for a username
if one does not already exist but UPDATEs it if there is already such a
row.
This is the normal and advised way of doing this specific task in an
atomic way by using the "ON DUPLICATE" syntax of SQL.
Grüße,
Sven.
--
Sigmentation fault. Core dumped.
