Is there a MySQL feature like SQL Server 2005's TRY/CATCH blocks?

Question

I'm thinking about porting a database from Sql Server 2005 to MySQL.

I've become accustomed to using SQL Server's TRY/CATCH block in stored procedures.

Does MySQL have something similar, or am I going to be forced to go back to the old-school "check the error return after every statement, and issue a goto if it failed" style of programming?

Zed · Accepted Answer · 2009-08-29 18:18:09Z

6

You can declare handlers for specific error results.

answered Aug 29, 2009 at 18:18

Zed

57.8k9 gold badges79 silver badges101 bronze badges

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

Comments

LucaCosta · Accepted Answer · 2014-09-24 15:08:19Z

0

There is no try/catch in MySQL as far as i know. Here something that can help with the errors in stored procedures:

DECLARE EXIT HANDLER FOR SQLEXCEPTION SELECT 'SQLException invoked';

Source:http://www.mysqltutorial.org/mysql-error-handling-in-stored-procedures/

answered Sep 24, 2014 at 15:08

LucaCosta

1103 silver badges11 bronze badges

Collectives™ on Stack Overflow

Is there a MySQL feature like SQL Server 2005's TRY/CATCH blocks?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related