set @x=5,@y=7;#定义多个变量时可以使用,作为分割
select @x + @y as '加法运算',@x - @y as '减法运算',@x * @y as '乘法运算',@x / @y as '除法运算',@x % @y as '取模运算'#除法保留四位有效小数
关系运算
select @x < @y as '大小判断';#返回结果1代表true,如果是0代表false
select @x >= @y;
逻辑运算
select true or false;# 依然符合&(and)与、|(or)或。
通过变量进行实际操作
set @cityName='Rotterdam';
select * from city where `Name` = @cityName;
set @cityName1='Rotterdam';
set @cityName2='Zaanstad';
set @cityName3='Zwolle';
select * from city where `Name` in (@cityName1,@cityName2,@cityName3);
浮点数0的处理
set @dx=66.6,@dy=99.9;
select @dx + @dy; # 显示结果有很多0
set @result = @dx + @dy;
select @result; # 去掉0