Mysql exception output

CREATE PROCEDURE p ()
BEGIN
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    SIGNAL SQLSTATE VALUE '99999'
      SET MESSAGE_TEXT = 'An error occurred';
  END;
  DROP TABLE no_such_table;
END;

Source: dev.mysql.com

Similar codes

0 vote191 views4 answers
Mysql select bottom 10 rows
SQL
0 vote190 views1 answer
C# check if mysql query modified rows
SQL
13 votes193 views4 answers
Mysql get last row
SQL
2 votes192 views1 answer
Plsql left() function
SQL
3 votes218 views5 answers
Foreign keys
SQL
2 votes198 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote187 views1 answer
Postgres call view
SQL
2 votes242 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote265 views1 answer
Count database access django
SQL
3 votes223 views1 answer
Oracle user quota on tablespace
SQL