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

10 votes218 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote181 views3 answers
How to verify sequence result in oracle SQL
SQL
10 votes197 views3 answers
Sql check double value
SQL
14 votes280 views1 answer
How to export db from mysql
SQL
0 vote187 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote185 views1 answer
Flask sqlalchemy update row
SQL
1 vote180 views2 answers
Mysql spring boot application.properties
SQL
8 votes201 views1 answer
Mysql limit rows
SQL
17 votes206 views6 answers
Change column name in sql
SQL
0 vote231 views10 answers
Sql statement checker corrector
SQL