Syntax
------ 
DECLARE condition_name CONDITION FOR condition_value
 
condition_value:
 SQLSTATE [VALUE] sqlstate_value
 | mysql_error_code
 
Description
----------- 
The DECLARE ... CONDITION statement defines a named error
condition.
It specifies a condition that needs specific handling and
associates a
name with that condition. Later, the name can be used in a
DECLARE ... HANDLER, SIGNAL or RESIGNAL statement (as long
as the statement is located in the same BEGIN ... END
block).
 
Conditions must be declared after local variables, but
before CURSORs and HANDLERs.
 
A condition_value for DECLARE ... CONDITION can be an
SQLSTATE value (a
5-character string literal) or a MySQL error code (a
number). You should not
use SQLSTATE value '00000' or MySQL error code 0, because
those indicate sucess
rather than an error condition. If you try, or if you
specify an invalid SQLSTATE value, an error like this is
produced:
 
ERROR 1407 (42000): Bad SQLSTATE: '00000'
 
For a list of SQLSTATE values and MariaDB error
codes, see MariaDB Error Codes.
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/declare-condition/