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

Does RDS for MySQL Support Stored Procedures and Functions?

Updated at: Apr 20, 2020 GMT+08:00

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel