mysql笔试题
#1.把王五的的工资涨100
SELECT * FROM userinfo
UPDATE userinfo set salary = salary+100 where username = '王五'
#2.写一个select语句,找出人数超过2人的部门
select dept FROM userinfo GROUP BY dept HAVING COUNT(dept)>=2
mysql笔试题
#1.把王五的的工资涨100
SELECT * FROM userinfo
UPDATE userinfo set salary = salary+100 where username = '王五'
#2.写一个select语句,找出人数超过2人的部门
select dept FROM userinfo GROUP BY dept HAVING COUNT(dept)>=2