How To Execute Stored Procedure In MySQL Workbench

Stored Procedures allow you to save SQL queries in order to run them again later. It is very convenient for SQL queries that you need to run repeatedly. Here’s how to execute stored procedure in MySQL Workbench.

How To Execute Stored Procedure In MySQL Workbench

Here are the steps to run stored procedure in MySQL Workbench. Let’s say you have the following SQL query.

mysql> select * from products;

and we create the following stored procedure get_products using the above SQL query.

mysql> DELIMITER //

mysql> CREATE PROCEDURE Get_Products()
       BEGIN
       SELECT *  FROM products;
       END //

mysql> DELIMITER ;
mysql> call get_products;
+------------+--------------------+-------+
| product_id | product_name       | price |
+------------+--------------------+-------+
|          1 | iPhone 11          |   400 |
|          2 | Samsung Galaxy A50 |   250 |
+------------+--------------------+-------+

Bonus Read : MySQL Get Duplicate Records

Let us look at how to execute stored procedure in MySQL Workbench.

1. Open MySQL Workbench.

2. Create New tab to run SQL statements.

Bonus Read : MySQL Add Unique Constraint

3. Enter the SQL statements for stored procedure in your new tab.

4. Execute the store procedure statements by clicking the ‘lightning’ icon shown below. That will call stored procedure in MySQL Workbench.

Bonus Read : MySQL Stored Procedure With Parameters

5. Expand the stored procedure node in right pane. You should see the name of your stored procedure (get_products). If you don’t see it, then hit refresh button next to SCHEMAS