Skip to main content

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

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.