[b]官方英文文档:[/b]
[url]http://dev.mysql.com/doc/refman/5.0/en/flow-control-statements.html[/url]
[color=red]************************** [b]IF[/b] **************************[/color]
[b]语法:[/b]
[b]实例:[/b]
[color=red]************************** [b]CASE[/b] **************************[/color]
[b]语法:[/b]
[color=red][b]Or:[/b][/color]
[b]实例:[/b]
[url]http://dev.mysql.com/doc/refman/5.0/en/flow-control-statements.html[/url]
[color=red]************************** [b]IF[/b] **************************[/color]
[b]语法:[/b]
IF search_condition THEN statement_list
[ELSEIF search_condition THEN statement_list] ...
[ELSE statement_list]
END IF
[b]实例:[/b]
DELIMITER$$
DROP PROCEDURE IF EXISTS pro_if$$
CREATE PROCEDURE pro_if(
i INT
)
BEGIN
IF i < 60 THEN
SELECT '需继续努力,争取过线!' AS result;
ELSEIF i < 85 THEN
SELECT '再努力点,争取达优!' AS result;
ELSE
SELECT '不错哦,恭喜,恭喜!' AS result;
END IF;
END$$
[color=red]************************** [b]CASE[/b] **************************[/color]
[b]语法:[/b]
CASE case_value
WHEN when_value THEN statement_list
[WHEN when_value THEN statement_list] ...
[ELSE statement_list]
END CASE
[color=red][b]Or:[/b][/color]
CASE
WHEN search_condition THEN statement_list
[WHEN search_condition THEN statement_list] ...
[ELSE statement_list]
END CASE
[b]实例:[/b]
DELIMITER$$
DROP PROCEDURE IF EXISTS pro_case$$
CREATE PROCEDURE pro_case(
i INT
)
BEGIN
CASE i
WHEN 1 THEN SELECT 'you male!' AS result;
WHEN 0 THEN SELECT 'you female!' AS result;
ELSE
SELECT 'third sex!' AS result;
END CASE;
END$$