We have no such know issue. If I create the SP `cta_DEL_RoomType` and next click 'alter stored procedure' from I get a editor tab like
Code:
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`cta_DEL_RoomType`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `cta_DEL_RoomType`()
BEGIN
— do nothing;
END$$
DELIMITER;
Please:
1) tell what are the program versions (SQLyog and MySQL) that you use?
2) if you execute “SHOW CREATE PROCEDURE `cta_DEL_RoomType`;” what is returned?
3) try explain EXACTLY what steps to take to reproduce?