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 votes123 views1 answer
Pl sql escape &
SQL
6 votes106 views4 answers
Mysql update set
SQL
0 vote118 views1 answer
Bitmap join index
SQL
2 votes68 views1 answer
Mysql admin u root p password change password
SQL
13 votes120 views1 answer
Select count of distinct values sql
SQL
0 vote127 views1 answer
Get schema of table sql
SQL
2 votes126 views1 answer
How to find table table in stored procedure sql server
SQL
4 votes120 views1 answer
Oracle delete last row
SQL
0 vote122 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote127 views1 answer
Mysql change timestamp on update
SQL