MySQL :: Manual de Referência do MySQL 4.1

Manual de Referência do MySQL 4.1 :: 11 Stored Procedures e Funções :: 11.1 Sintaxe de Stored Procedure :: 11.1.9 Flow Control Constructs :: 11.1.9.1 IF Statement

« 11.1.9 Flow Control Constructs

11.1.9.2 CASE Statement »

Section Navigation [Toggle]

11.1.9 Flow Control Constructs
11.1.9.1 IF Statement
11.1.9.2 CASE Statement
11.1.9.3 LOOP Statement
11.1.9.4 LEAVE Statement
11.1.9.5 ITERATE Statement
11.1.9.6 REPEAT Statement
11.1.9.7 WHILE Statement

11.1.9.1. `IF` Statement

IF search_condition THEN statement(s)
[ELSEIF search_condition THEN statement(s)]
...
[ELSE statement(s)]
END IF

IF implements a basic conditional construct. If the search_condition evaluates to true, the corresponding SQL statement is executed. If no search_condition matches, the statement in the ELSE clause is executed.

Please note that there is also an IF() function. See Secção 6.3.1.4, “Funções de Fluxo de Controle”.

This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.

Top / Previous / Next / Up / Table of Contents

11.1.9.1. IF Statement

11.1.9.1. `IF` Statement