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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s