Raise Exception / Error in MySQL 5.0

There is no standard way to raise exception or error in MySQL.
But there is a trick:

• call to a not existing Stored Procedure raises MySQL exception
  
• so call to not existing Stored Procedure using "error message" as "procedure name" forces MySQL to raise exception that looks like "error message"

So to have Raise Exception feature we need next stored procedures / functions:

• procedure to execute dynamic SQL statements
• function to format text
• and main procedure to raise error / exception

See the code below:

DELIMITER $$
  
  
-- PROCEDURE pExecuteImmediate
--   executes dynamic SQL statement
-- Params:
--   tSQLStmt - SQL statement to be executed
DROP PROCEDURE IF EXISTS `pExecuteImmediate` $$
CREATE PROCEDURE `pExecuteImmediate`(IN tSQLStmt TEXT)
BEGIN
  SET @executeImmediateSQL = tSQLStmt;
  PREPARE executeImmediateSTML FROM @executeImmediateSQL;
  EXECUTE executeImmediateSTML;
  DEALLOCATE PREPARE executeImmediateSTML;
END $$
  
  
-- FUNCTION fFormat
--   replaces '%s' in a string with some value
-- Params:
--   sFormat - string to be formatted
--   sPar1 - value used in replacement
-- Returns:
--   formatted string
DROP FUNCTION IF EXISTS `fFormat` $$
CREATE FUNCTION  fFormat(sFormat TEXT, sPar1 TEXT)
  RETURNS TEXT
BEGIN
  RETURN REPLACE(sFormat, '%s', sPar1);
END $$
  
  
-- PROCEDURE pRaiseError
--   raises error
-- Params:
--   sError - error message
DROP PROCEDURE IF EXISTS `pRaiseError` $$
CREATE PROCEDURE `pRaiseError`(sError VARCHAR(255))
BEGIN
  -- trick
  --   calling of not existing procedure with name that equals error message
  --   will force MySQL exception that looks like error message
  CALL pExecuteImmediate(fFormat('CALL `error: %s, solution`', sError));
END  $$
  
  
DELIMITER ;

After execution of SQL:

CALL pRaiseError("this is a sample error message")

MySQL will raise exception:

PROCEDURE error: this is a sample error message, solution does not exist

Additional information could be found here: Stored Procedures in MySQL 5.x