Create a stored Procedures using MySQL Workbench?

Let us first create a Stored Procedure. Following is the query to create a stored procedure using MySQL Workbench.

use business;
DELIMITER //
DROP PROCEDURE IF EXISTS SP_GETMESSAGE;
CREATE PROCEDURE SP_GETMESSAGE()
BEGIN
DECLARE MESSAGE VARCHAR(100);
SET MESSAGE="HELLO";
SELECT CONCAT(MESSAGE,' ','MYSQL!!!!');
END
//
DELIMITER ;

Here is the screenshot of stored procedure in MySQL workbench −

You need to execute the above stored procedure with the help of below symbol shown in the screenshot −

Now you can call the stored procedure with the help of CALL command.

call SP_GETMESSAGE();

The screenshot is as follows −

Now again you can execute the above statement with the help of symbol shown above. This will produce the following output −

Nishtha Thakur

Updated on: 30-Jul-2019

2K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started