You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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.

memsql> 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.