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

7 votes432 views2 answers
Drop index oracle
SQL
2 votes359 views1 answer
Sql finding longest and shortest names in a fleld
SQL
1 vote391 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote359 views1 answer
Mysql where in keep order
SQL
0 vote338 views1 answer
Get created time of database psql 8
SQL
0 vote342 views1 answer
Get week day name sql server
SQL
0 vote360 views1 answer
Postgres populate table from another table
SQL
2 votes360 views1 answer
Add new column not null sql server
SQL
0 vote324 views1 answer
Oracle list dblink
SQL
0 vote425 views1 answer
Mariadb change column type
SQL