SQL
#MYSQL变量的定义与使用
set @userName='小可爱';
SELECT @userName;
#定义数值类型·整数·小数
set @x=5,@y=7;
SELECT @x+@y,@x-@y,@x*@y,@x/@y;
#1.字符串查询
set @cityName='Haag';
select * FROM city WHERE `Name`=@cityName;
#2.数值类型
set @popvalue='105819';
SELECT * FROM city WHERE Population=@popvalue;