How to call a Stored Procedure from another Stored Procedure in mysql?

Can I do that because it call from function if i use a norm开发者_如何学Cal form such as xxx() in mysql? please show me how to do it,thx.

---

In SQL Server it is plain vanilla exec proc statement, here is sql server syntax

create procedure prYourProc
as

-- exec other proc
exec prSomeOtherProc

-- to get return value
declare @var int
exec @var = prSomeOtherProc

---

PROCEDURE 1

DROP PROCEDURE IF EXISTS Proc1;
CREATE PROCEDURE Proc1()
BEGIN
  CALL Proc2();
END

PROCEDURE 2

DROP PROCEDURE IF EXISTS Proc2;
CREATE PROCEDURE Proc2()
BEGIN
  SELECT ColumnName  FROM table2;
END