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 −

raja
Published on 17-May-2019 16:39:17
Advertisements