mysql练习

 

 

 

 1.把王五的工资涨100元

UPDATE userinfo set Salry = Salry + 100 where Username="王五"

 

 2.写一个select语句找出人数超过2个人的部门

select * from Userinfo
where Dept in (select Dept from Userinfo GROUP BY Dept HAVING COUNT(Dept)>2)