变量在SQL中的使用

set @userName='小可爱';
set @userName='小哈尼';
select @userName:='海绵宝宝';
select @userNamel:'名称';
set @userName1='玛卡巴卡',@userName2='汤比力多',@userName3='胡西迪西';
select @userName1,@userName2,@userName3;


set @x=5,@y=7,@dx=0.1,@dy=5.65;
select @x + @y;
select @x - @y;
select @x * @y;
select @x / @y;
select @x % @y;

select @dx + @dy;
select @dx - @dy;
select @dx * @dy;
select @dx / @dy;
select @dx % @dy;
select @result1.@result2,@result3,@result4,@result5;


set @x=5,@x=7;
select @x <= @y;
select @x > @y;


select TRUE and TRUE;
select FALSE OR TRUE;

set @userName='龙姑娘';
set @age=16;
select * from student where userName=@userName or age=@age;
set @userName1='龙姑娘';
set @userName2='赵灵儿';
select * from student where userName in (@userName1，@userName2)；