How to create store proceduree and execute on workbanch 6.1 CE

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)

 

 

 

 

 

 

Advertisements