MySQL IF语句

最新推荐文章于 2023-12-06 12:14:27 发布

zhen24

最新推荐文章于 2023-12-06 12:14:27 发布

阅读量473

点赞数

分类专栏： Mysql 文章标签： Mysql

本文链接：https://blog.csdn.net/weixin_43692357/article/details/88102452

版权

Mysql 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

语法：

IF condition1 THEN
   {...statements to execute when condition1 is TRUE...}

[ ELSEIF condition2 THEN
   {...statements to execute when condition2 is TRUE...} ]

[ ELSE
   {...statements to execute when both condition1 and condition2 are FALSE...} ]

END IF;

实例：

CREATE PROCEDURE sp_search_user(IN NAME VARCHAR(20))
BEGIN
	IF NAME THEN
            SELECT * FROM `user` where name like NAME;
	ELSE
            SELECT * FROM `user`;
	END IF;
END;

执行：

call sp_search_user('zhen')