Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "stored procedures in mysql database". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

First, create stored procedures

1. Basic grammar:

Create procedure sp_name ()

Begin

.

End

Second, call stored procedures

1. Basic grammar:

Call sp_name ()

Note: the stored procedure must be followed by parentheses, even if the stored procedure is not passed

Delete stored procedures

1. Basic grammar:

Drop procedure ap_name//

Note: you cannot delete another stored procedure in one stored procedure, only another stored procedure can be called.

IV. Blocks, conditions, cycles

1. Block definition: commonly used

Begin

.

End

You can also give the block an alias

Label:begin

.

End label

You can jump out of the block with leave label; jump out of the block and execute the code after the block

2. Conditional statement

If conditional then

Statment

Else

Statement

Else if

3. Circular statement

(1) .while loop

[label:] while expression DO

Statements

End while [label]

(2) .loop cycle

[label:] loop

Statements

End loop [label]

(3). Repeat until cycle

[label:] repeat

Statements

Until expression

End repeat [label]

Other commonly used commands

1.show procdure status

Displays basic information about all stored procedures in, including database, stored procedure name, creation time, etc.

2.show create procedure sp_name

Display the details of a stored procedure

Operators to be used in stored procedures

Mysql stored procedure Learning Summary-operator

Arithmetic operator

+ add SET var1=2+2; 4

-minus SET var2=3-2; 1

* take SET var3=3*2; 6

/ except for SET var4=10/3; 3.3333

DIV divides SET var5=10 DIV 3; 3

% Modulo SET var6=10%3; 1

Comparison operator

> greater than 1 > 2 False

< less than 2

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.