Cheat Sheet logoCheat Sheet Today
MySQL Procedures, Triggers, and Events Cheatsheet/Call a stored procedure

Execute a procedure with input arguments.

Back to sheetBrowse commands
Sign in to save
Section: stored procedures and functions

Call a stored procedure

sql
sql
CALL get_user_by_email('ava@example.com');
Explanation

`CALL` invokes stored procedures defined on the server.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing stored procedures and functions
Change the statement delimiter
Define routines containing semicolons.
OpenIn sheetsqlsame section
Create a scalar function
Return a computed value from SQL code.
OpenIn sheetsqlsame section
List stored procedures
Display procedures visible in a schema.
OpenIn sheetsqlsame section
Show procedure definition
Display the CREATE PROCEDURE statement for an existing routine.
OpenIn sheetsqlsame section
Create a BEFORE INSERT trigger
Normalize row data before insert.
OpenIn sheetsql
List triggers
Display triggers defined in the current schema.
OpenIn sheetsql