MySQL-流程控制语句

# 流程控制语句

-- if(expr1,expr2,expr3),如果1为true，则返回2否则返回3
SELECT IF(FALSE,'北京','西安') FROM DUAL;

-- ifnull(expr1,expr2),如果1不为空null，则返回1否则返回2
SELECT IFNULL(NULL,'ybj') FROM DUAL;

-- 有true就返回，没有就继续
SELECT CASE
	WHEN TRUE THEN 'jack'
	WHEN FALSE THEN 'tom'
	ELSE 'mary' END
	
-- 例子
SELECT username,IF(job IS NULL,0.0,job)
	FROM employee
SELECT username,IFNULL(job,0.0)
	FROM employee

SELECT * FROM employee
SELECT username,(SELECT CASE
			WHEN job = '研究生' THEN '牛马'
			WHEN job = '研究员' THEN '大牛马'
			ELSE '不是牛马' END) AS 'job'
	FROM employee