Help Center> Relational Database Service> FAQs> Database Storage> Does RDS for MySQL Support Stored Procedures and Functions?
View PDF

Does RDS for MySQL Support Stored Procedures and Functions?

Yes.

  1. Stored procedures and functions are a set of SQL statements that have been compiled and stored in databases. Invoking stored procedures and functions reduces data transmission between databases and application servers, and improves data processing efficiency.
  2. Differences between stored procedures or functions
  • A function must have a return value, but a stored procedure does not.
  • The parameters of a stored procedure can be of the IN, OUT, and INOUT type, but the parameters of a function can only be of the IN type.

For details about how to create a stored procedure and a function, see the official document.

Parent topic: Database Storage