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 vote151 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote126 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
6 votes132 views3 answers
How to delete table sqlite
SQL
0 vote176 views1 answer
AddEntityFrameworkSqlite
SQL
5 votes174 views4 answers
Mysql on duplicate key update
SQL
0 vote129 views1 answer
Sql server bool select
SQL
0 vote129 views1 answer
How to find all children of a record with only parent ID in sql
SQL
25 votes129 views5 answers
Date in mysql
SQL
0 vote142 views1 answer
Change magento database url usimg musql
SQL
0 vote141 views1 answer
Rows, INSERT INTO, Returning
SQL