一、通过变量进行实际的操作
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=0.11,@dy=55.5;
SELECT @dx +@dy;#显示结果有很多0
set @result=@dx+@dy;
SELECT @result;#去掉0