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

2 votes193 views1 answer
Sql server find table name
SQL
3 votes186 views3 answers
Print in pl sql
SQL
1 vote185 views1 answer
Index a database column sql
SQL
0 vote194 views1 answer
How to count with except in psql
SQL
0 vote226 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
24 votes211 views4 answers
Postgres remove database
SQL
0 vote232 views1 answer
Calculer pourcentage mysql
SQL
14 votes252 views3 answers
Inner join sql oracle
SQL
0 vote193 views1 answer
Opensuse stop MySQL
SQL
0 vote277 views1 answer
Osm2pgsql mac
SQL