-- mysql stored procedure example 0
-- creates and calls a hello, world procedure in the test database
USE test
DELIMITER $$
DROP PROCEDURE IF EXISTS hello$$
CREATE PROCEDURE hello()
  BEGIN
    SELECT 'hello, world';
  END $$
DELIMITER ;
call hello();