CODE
DELIMITER //;
DROP PROCEDURE IF EXISTS `test`.`myproc`//
CREATE PROCEDURE `test`.`myproc`()
BEGIN
END//
DELIMITER;//
DROP PROCEDURE IF EXISTS `test`.`myproc`//
CREATE PROCEDURE `test`.`myproc`()
BEGIN
END//
DELIMITER;//
According to MySQL documentation correct is
CODE
DELIMITER //;
DROP PROCEDURE IF EXISTS `test`.`myproc`//
CREATE PROCEDURE `test`.`myproc` ()
BEGIN
END//
DELIMITER;//
DROP PROCEDURE IF EXISTS `test`.`myproc`//
CREATE PROCEDURE `test`.`myproc` ()
BEGIN
END//
DELIMITER;//
There shall be a blank character between procedure-name and ()
I haven't come across any situation where it matters. But better do it right!
MySQL's own so-called GUI programs do that.
