MySQL procedure CALL multiple procedures

Question

My question is pretty straight forward. Is it possible to create a procedure that calls multiple previously stored procedures such as:

CREATE PROCEDURE  `CALL_A_B_C` ( ) 
NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY DEFINER  
CALL `A` ();
CALL `B`();
CALL `C`();

This code doesn't work but you get the idea. Is there a way to do this?

peterm · Accepted Answer · 2013-11-17 04:18:49Z

5

The answer yes it is possible. Your code for an outer stored procedure might look like this

DELIMITER $$
CREATE PROCEDURE sp_abc()
BEGIN
  CALL sp_a();
  CALL sp_b();
  CALL sp_c();
END$$
DELIMITER

Here is SQLFiddle demo

answered Nov 17, 2013 at 4:18

peterm

93k16 gold badges157 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

each call will be asynch or blocking?

@iBabur Sequential. There is no concept of async calls in MySQL or AFAIK any other major RDBMS for that matter