MySQL 札记

MySQL

运算符

DECLARE tmp varchar(50);
set tmp = ”;

• tmp IS NULL
• tmp IS NOT NULL
• tmp = ”
• tmp <> ” 或者 tmp != ”

赋值

方法一

• 注意 @tmp :=

set @yesterday = date_sub(curdate(),interval 1 day);
select @tmp := ipDay from sec_net_day where ipDay = @yesterday;

方法二

set @tmp = 'helle sql';
select @tmp;