<div>
No, MySQL does not have that functionality.
</div>


No, MySQL does not have that functionality.

<div>
Thank you for that information , &nbsp; johanntagle!!<br />
It sounds like try catch blocks need to be introduced to MySQL or MariaDB.<br />
From what I have seen in MySQL there are several areas that could be vastly improved<br />
try/catch with stored procedures is one of the improvements I would like to see in future releases as well as improved constraint handling as is found in the more robust databases.<br />
<br />
Thank you for the information about the handler. Most &nbsp;MySQL server programmers rely on Java try catch blocks but it would stream line the use of stored procedures to use this.<br />
<br />
Definitely more work could be done on such important features .
</div>


Thank you for that information ,   johanntagle!!
It sounds like try catch blocks need to be introduced to MySQL or MariaDB.
From what I have seen in MySQL there are several areas that could be vastly improved
try/catch with stored procedures is one of the improvements I would like to see in future releases as well as improved constraint handling as is found in the more robust databases.

Thank you for the information about the handler. Most  MySQL server programmers rely on Java try catch blocks but it would stream line the use of stored procedures to use this.

Definitely more work could be done on such important features .

<div>
<div class="content wysiwyg-content">
Is there try / catch block capability in MySQL stored procedures and functions and If so how? Any samples??<br />
<br />
e.g &nbsp; Begin Try <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .....<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;END TRY<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BEGIN CATCH<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.... &nbsp;Exception handling code e.g division by 0 or no rows found etc...<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;END CATCH<br />
<br />
<br />
This capability is in Microsoft SQL Server 2008 so Is it also in MySQL 5.6 and if not when will it be MySQL??? Anytime soon?
</div>
</div>


Is there try / catch block capability in MySQL stored procedures and functions and If so how? Any samples??

e.g   Begin Try 
          .....
         END TRY
         BEGIN CATCH
           ....  Exception handling code e.g division by 0 or no rows found etc...
         END CATCH


This capability is in Microsoft SQL Server 2008 so Is it also in MySQL 5.6 and if not when will it be MySQL??? Anytime soon?

Is there try / catch block capability in MySQL and If so how?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.