(mysql.info.gz) IF Statement

Info Catalog

(mysql.info.gz) Flow Control Constructs

(mysql.info.gz) Flow Control Constructs

(mysql.info.gz) CASE Statement

 
 19.1.9.1 `IF' Statement
 .......................
 
      IF SEARCH_CONDITION THEN STATEMENT_LIST
          [ELSEIF SEARCH_CONDITION THEN STATEMENT_LIST]
          ...
          [ELSE STATEMENT_LIST]
      END IF
 
 `IF' implements a basic conditional construct. If the SEARCH_CONDITION
 evaluates to true, the corresponding SQL statement list is executed. If
 no SEARCH_CONDITION matches, the statement list in the `ELSE' clause is
 executed. STATEMENT_LIST can consist of one or more statements.
 
 Please note that there is also an `IF()' function.   Control flow
 functions.
 

Info Catalog

(mysql.info.gz) Flow Control Constructs

(mysql.info.gz) Flow Control Constructs

(mysql.info.gz) CASE Statement