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 vote286 views1 answer
RowDataPacket
SQL
0 vote290 views1 answer
Equi joins in oracle
SQL
0 vote324 views1 answer
Doesn't have default value mysql
SQL
0 vote285 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote395 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
3 votes295 views1 answer
Fk in insert mysql
SQL
0 vote278 views1 answer
Insert or update cassandra
SQL
2 votes306 views2 answers
Install postgresql
SQL
0 vote326 views2 answers
Port 5432 is already in use mac
SQL
4 votes286 views1 answer
Mysql ip address
SQL