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 vote259 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote249 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
7 votes244 views3 answers
Postgre describe table
SQL
1 vote239 views1 answer
How to delete record sql delphi
SQL
0 vote200 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote246 views1 answer
Min and max salary and name in sql
SQL
0 vote245 views1 answer
How to query all tables mysql at the same time
SQL
0 vote258 views1 answer
How to add boolean column in postgresql
SQL
0 vote271 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote258 views1 answer
Sql period overlap
SQL