Re: Possible to do if .. then atomically without exceptions?

[Aftab Khan]

>* Query for x (where x has a unique index)
>* If x is not found, insert x

You could do it using single query:
INSERT IGNORE INTO `A` (name) VALUES ('Jones');

If you use the IGNORE keyword, errors that occur while executing the INSERT statement are treated as warnings instead. For example, without IGNORE, a row that duplicates an existing UNIQUE index or PRIMARY KEY value in the table causes a duplicate-key error and the statement is aborted. With IGNORE, the row still is not inserted, but no error is issued.



Edited 1 time(s). Last edit at 09/14/2012 07:33AM by Aftab Khan.