Call MySQL Stored Procedure from Another Stored Procedure

Software Used:

PHPMyAdmin

First Stored Procedure

I create first stored procedure named with proc1 and i insert this content:

select "satu"

Question:

How to call proc1 stored procedure from another stored procedure … ?

Answer:

I make this stored procedure named with proc2:

BEGIN
   call proc1();
   SELECT 2;
END

Explain:

call proc1() is used to call proc1 stored procedure

Result:

Run the proc2 stored procedure and see the result

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *