use student
CREATE TABLE userinfo(
userid int PRIMARY KEY NOT NULL AUTO_INCREMENT,
username varchar(255) DEFAULT NULL,
dept varchar(20),
listLoginTime timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
salay double (6,2)
)
select * from userinfo
insert into userinfo values(0,“张三”,“dev”,now(),2000.00),
(0,“李四”,“dev”,now(),4100.00),
(0,“王五”,“op”,now(),1600.00),
(0,“赵六”,“op”,now(),900.00),
(0,“前七”,“sale”,now(),1000.00)
update userinfo set salay = 1700 where username=‘王五’
SELECT dept,count(*) as count FROM userinfo GROUP BY dept HAVING count(dept) >1
ORDER BY count DESC