CALL
Executes the specified stored procedure. Does not return results.
Syntax
CALL { procedure_name( [argument_list] ) | database_name.procedure_name( [argument_list] ) };
Arguments
procedure_name
The name of the stored procedure to execute.
argument_list
A list of optional arguments to pass as input parameters to the stored procedure.
Remarks
See the Permission Matrix for the required permission.
Example
The following example executes a stored procedure that accepts a VARCHAR
as an input parameters.
CALL snapshot_db('db1'); **** Query OK, 0 rows affected (0.35 sec)
Related Topics
The ECHO command is similar to CALL
but it outputs a set of rows as a result.