set @userName='小可爱';
set @userName:='小哈尼';
select @userName:='海绵宝宝';
select @userName as '名称';
set @userName1='玛卡巴卡',@userName2='汤比',@userName3='胡西迪西';
select @userName1,@userName2,@userName3;
set @x=5,@y=0,@dx=0.1,@dy=5.65;
select @x + @y;
select @x - @y;
select @x * @y;
select @x / @y;
select @x % @y;
set @result1 = @dx + @dy;
set @result2 = @dx - @dy;
set @result3 = @dx * @dy;
set @result4 = @dx / @dy;
select @result1,@result2,@result3,@result4,@result5;
select ROUND(select @dx / @dy,2);
set @x=5,@y=7;
select @x <= @y;
select @x > @y;
select @x=@y;
select TRUE and TRUE;
select FALSE OR TRUE;
set @userName='龙姑娘';
set @age=16;
select * from student where userNmae=@userName or age=@age;
set @userName1='龙姑娘';
set @uesrName2='赵灵儿';
select * from student where userName in (@userName1,@userName2);
MySQL
最新推荐文章于 2024-09-24 08:39:48 发布