I tried to execute an SQL file in MySQL. The file contained a CREATE PROCEDURE statement and the procedure contents: DELIMITER %% DROP PROCEDURE IF EXISTS `regmed`.`Add_Order`%% CREATE DEFINER=`ME`@`localhost` PROCEDURE `regmed`.`Add_Order`( p_medication VARCHAR(50), -- required, if numeric is treated as the primary key p_who VARCHAR(10), -- required p_order DATE, -- optional, default current date p_receive DATE, -- optional p_reorder DATE, --...
Originally asked by Peter Bill on Stack Exchange (superuser) (CC BY-SA 4.0).