Usage example of the BEGINEND compound statement in the mysql Stored Procedure

Examples of begin_label:] BEGIN [statement_list] END [end_label] using the BEGIN... END compound statement in the mysql stored procedure can contain multiple statements. Statement_list indicates the list of one or more statements. Each statement in statement_list must end with a semicolon.

Examples of begin_label:] BEGIN [statement_list] END [end_label] using the BEGIN... END compound statement in the mysql stored procedure can contain multiple statements. Statement_list indicates the list of one or more statements. Each statement in statement_list must end with a semicolon.

Mysql Stored Procedure in END compound statement usage example

Begin_label:] BEGIN

[Statement_list]

END [end_label]

You can use the in... END compound statement to store subprograms to contain multiple statements. Statement_list indicates the list of one or more statements. Each statement in statement_list must end with a semicolon.

Compound statements can be marked. Unless begin_label exists, end_label cannot be given, and if both exist, they must be the same.

Note that the optional [NOT] ATOMIC clause is NOT supported yet. This means that no interaction storage point is set at the beginning of the instruction block, and the BEGIN clause Used in the context does not affect the current interaction action.

To use multiple statements, the client must be able to send query strings containing statement delimiters. This symbol is processed by the delimiter command on the command line client. Change the end Separator of the query (for example, change to //) so that it can be used in the subprogram body.

Note: More exciting articles, please pay attention to SanlianProgramming TutorialTopic.