MySQL Create stored process procedure

1.mySQL Create stored process procedure as follows:

/* The wonderful thing is to define a label [delimiter//] means procedure is not SQL, procedure's key word was eaten by the dog? */

2. Process Control Language If then end if

3.case when end case

.

4.while End While/* End while is light, this is different from Oracle */

5.loop End Loop Cycles:

6.repeat until end repeat;

/*set V=value;oralce v:=value;*/

/*oracle is not repeat, as does while*/

7.iterate/ * This feels a bit like go to Oracle also wood has * /

8. Continue handler for SQLState ' 23000 ' Set @xz = 1;

/* Unlike Oracle, @x defines an amount of time that is like SQL Server */

9.declare cur1 cursor FOR select id,data from Test.t1;

Open Cur1;close Cur1;

MySQL Create stored process procedure