CALL

Use this MySQL statement to call a stored procedure.

Syntax

Below is the syntax for this command. Text within square brackets (i.e, [ and ] ) are optional. Choices are separated by bars (i.e, | ). Ellipses preceded by a comma indicates a repeating pattern. Ellipses before or after syntax are used to highlight a relevant except from the larger syntax. Text displayed in italic letters represent text that should be replaced with the specific names related to the database (e.g., column with the name of the column).

CALL stored_procedure[([parameter[, ...]])]

Explanation

Use this statement to call a stored procedure. Parameters to be passed to the stored procedure may be given within the parentheses. If the keyword of INOUT is given, values may be given to the stored procedure and returned to the SQL statement that called it. For an example of this statement, see the example for CREATE PROCEDURE.