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

3 votes242 views1 answer
Async await mysql nodejs
SQL
0 vote256 views1 answer
Stratified sampling sql
SQL
0 vote239 views1 answer
Like date sql server not working
SQL
0 vote218 views1 answer
Double in sql server example
SQL
-1 vote247 views1 answer
Add 10 to all numbers in a column sql
SQL
18 votes232 views6 answers
Laravel form validation
SQL
4 votes225 views3 answers
Mysql modify foreign key
SQL
1 vote222 views1 answer
Sample clause in sql
SQL
0 vote242 views3 answers
Join
SQL
0 vote224 views1 answer
Uuid sqlalcomany
SQL