Outdated Version

You are viewing an older version of this section. View current production version.

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.

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.