DECLARE condition_name CONDITION FOR condition_value condition_value: SQLSTATE [VALUE] sqlstate_value | mysql_error_code
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 HANDLER
s.
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.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/declare-condition/