Hi Friends
Many engineer facing issue to create store procedure in mysql.
1) First you have to install the mysql workabnch or sql yog …
2) create the connection with local
3) in left menu you have to click right mouse button annd create store procedure.
DELIMITER $$
CREATE PROCEDURE `new_procedure` ()
BEGIN
select * from city_description;
END
then click apply after that you will see this way
USE `cor_by_bytesbrick`;
DROP procedure IF EXISTS `new_procedure`;
DELIMITER $$
USE `cor_by_bytesbrick`$$
CREATE PROCEDURE `new_procedure` ()
BEGIN
select * from city_description;
END$$
DELIMITER ;
Click apply and finish
Click right button of mouse on send sql editor then procedure call
CALL `cor_by_bytesbrick`.`new_procedure`();
then select then press F5
Thanks
Vinod K maurya
Manager IT ( Carzonrent India Pvt Ltd)