Is there something like ON INSERT ERROR in SQL using mySQL?

Question

Imagine I have a table Employee with columns id, name, company and a table EmployeeErrorLog with the same structure. The column names of the table Employee will have a unique constraint on the column name. I want to run inserts in the table Employee using SQL. The question is if there is an error triggered during an insert in table Employee, is it possible to make the insert in the table EmployeeErrorLog?

Which SQL tech are you using? Different engines have different capabilities. — Patrick M
– Patrick M, Commented Jul 22, 2014 at 13:42
Yes, MySQL is what I was referring to. Not exactly what you're looking for, but MySQL has INSERT ON DUPLICATE KEY UPDATE syntax you might be interested in. It lets you silently (without errors, that is) update an existing entry if you try to insert it again. — Patrick M
– Patrick M, Commented Jul 22, 2014 at 13:53

ZeRaTuL_jF · Accepted Answer · 2014-07-22 14:06:31Z

2

I would look into declare handlers for MySql they basically serve the same purpose as try and catch block.

For more information on these you can check them out here.

http://dev.mysql.com/doc/refman/5.1/en/declare-handler.html

Here is an example of how handlers are used

 DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' SET @x2 = 1;
->   SET @x = 1;
->   INSERT INTO test.t VALUES (1);
->   SET @x = 2;
->   INSERT INTO test.t VALUES (1);
->   SET @x = 3;

edited Jul 22, 2014 at 14:06

answered Jul 22, 2014 at 13:44

ZeRaTuL_jF

5922 gold badges4 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ZeRaTuL_jF Over a year ago

mySql doesn't have try/catch at least not as far as I know but if you check out my edit answer it should get you the same result.

Jorge Campos Over a year ago

@ZeRaTuL_jF You should show an appropriated example instead of providing just a link. Links may break here your answer will be saved.

Collectives™ on Stack Overflow

Is there something like ON INSERT ERROR in SQL using mySQL?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related