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 vote182 views1 answer
Sql insert from excel
SQL
2 votes189 views1 answer
Mariadb json select
SQL
0 vote188 views1 answer
Consulta alias con inner join
SQL
0 vote154 views2 answers
Mysql multiply
SQL
0 vote156 views1 answer
How to select an index in oracle sql
SQL
0 vote167 views1 answer
Add a new column into table
SQL
0 vote168 views1 answer
Sql server on mac m1
SQL
0 vote158 views1 answer
Oracle date winter time
SQL
0 vote155 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote158 views1 answer
Soql user profile
SQL