代碼: 選擇全部
set @a = 1;
IF @a < 5 THEN
set @a = 5;
END IF
select @a;
可以調整如下:
代碼: 選擇全部
set @a = 1;
set @a = (select case when @a<5 then 5 else @a end);
select @a;
Reference: https://gist.github.com/jeremyjarrell/6083251
In MySQL, IF statements cannot exist outside of stored procedures.