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 vote315 views1 answer
Oracle chain step succeeded
SQL
12 votes278 views4 answers
Mysql ifnull
SQL
0 vote286 views1 answer
Get sum sqlite android
SQL
0 vote269 views1 answer
Reading from right to left from string find first special characters in sql
SQL
8 votes300 views1 answer
Racle create auto increment column
SQL
7 votes298 views3 answers
Postgresql dump and restore db
SQL
5 votes291 views1 answer
Sysdate in oracle sql
SQL
8 votes294 views1 answer
Oracle search code in packages
SQL
1 vote297 views1 answer
Postgresql append array
SQL
1 vote296 views1 answer
How to convert number to hours and minutes in oracle sql
SQL