MySQL Loop Branch Syntax

---restore content starts---

Loop loop

label:loop    statement_list    IFthen        LEAVE label;      END IF  END LOOP label;

View Code

Repeat cycle

REPEAT     END REPEAT;

View Code

While loop

 while search_condition do    statement_listENDwhile;

View Code

IF ... Else Branch judgment

IF  Then     statement_listELSE    statement_listENDIF;

View Code

IF ... ELSEIF ... Else Branch judgment

IF  Then          then statement_list ELSE statement_list END      IF;

View Code

Cast branch judgment

 Case Case_value      when  Then         statement_list    ELSE        statement_listENDcase;

View Code

Create a stored procedure (PROCEDURE)

Create PROCEDURE procedure_name ([in| Out| INOUT]  param_name param_type,...) BEGIN     statement_listEND

View Code

Delete a stored procedure (PROCEDURE)

DROP PROCEDURE procedure_name

View Code

View stored Procedures (PROCEDURE)

SELECT    *  from     MySQL. proc WHERE  = ' PROCEDURE '     

View Code

Creating Functions (function)

CREATE FUNCTION function_name (param_name param_type,...) RETURNS Return_type BEGIN     statement_listEND

View Code

Delete Functions (function)

DROP FUNCTION IF EXISTS function_name

View Code

View functions (function)

SELECT    *  from     MySQL. proc WHERE  = ' FUNCTION '     

View Code

Defining variable Assignment values

-- function or stored procedure (PROCEDURE) defines variables and assigns values    -- definition    DECLARE DEFAULT default_value;     -- Assign Value    SET = New_value;     -- Assigning in a select query    SELECT variable_name:=col_name;

View Code

Detailed description of defining variable assignments: https://www.cnblogs.com/EasonJim/p/7966918.html

About dynamic MySQL statements: http://blog.itpub.net/29773961/viewspace-1852824/

MySQL Loop Branch Syntax