Help Center > > User Guide> MySQL DB Instance Management (Standard Edition)> Stored Procedure Management> Creating a Stored Procedure

Creating a Stored Procedure

Updated at: Sep 29, 2020 GMT+08:00

Scenarios

A stored procedure consists of a set of SQL statements that can complete specific tasks or process complex services. This section describes how to create a stored procedure. You can use loop statements in a stored procedure to insert objects repeatedly.

Prerequisites

You have logged in to a MySQL DB instance on the DAS console.

  • You have obtained the CREATE ROUTINE permission.
  • You have the Execute permission.

Procedure

  1. On the top menu bar, choose Database Management. On the displayed Objects page, select Stored Procedures, and click Create Stored Procedure.

  2. In the displayed dialog box, specify a stored procedure name and description and click OK.

  3. On the displayed page, click Option to set required parameters and click OK. Then, save and execute the stored procedure.

  4. View the execution status in the Message area.

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