mysql题

 

 

update userinfo set salary=2100.00 where username="王五"

SELECT dept,count(*) as count FROM userinfo GROUP BY dept HAVING count(dept) >1

ORDER BY count DESC