Help Center> Data Admin Service> User Guide> MySQL DB Instance Management (Standard Edition)> Database Management> Stored Procedure Management> Creating a Stored Procedure
View PDF

Creating a Stored Procedure

Overview

A stored procedure is a set of SQL statements used to implement specific functions. After being compiled, stored procedures are stored in databases. You can execute the stored procedures by specifying their names and related parameters.

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

    Figure 1 Creating a stored procedure

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

    Figure 2 Editing a stored procedure

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

    Figure 3 Setting a stored procedure

  4. View the execution status in the Message area.

    Figure 4 Viewing SQL status