insert into avg_score(caltime,amount,maxsocre,average) values( NOW(), SELECT COUNT(*) FROM user_namescore, SELECT MAX(score) AS score FROM user_namescore, SELECT MIN(score) AS score FROM user_namescore, SELECT AVG(score) FROM user_namescore );
insert into avg_score(caltime,amount,maxsocre,average) values( NOW(), (SELECT COUNT(*) FROM user_namescore), (SELECT MAX(score) AS score FROM user_namescore), (SELECT MIN(score) AS score FROM user_namescore), (SELECT AVG(score) FROM user_namescore) );
--改一下 insert into avg_score(caltime,amount,maxsocre,average) select NOW(), (SELECT COUNT(*) FROM user_namescore), (SELECT MAX(score) AS score FROM user_namescore), (SELECT MIN(score) AS score FROM user_namescore), (SELECT AVG(score) FROM user_namescore);
NOW(),
(SELECT COUNT(*) FROM user_namescore),
(SELECT MAX(score) AS score FROM user_namescore),
(SELECT MIN(score) AS score FROM user_namescore),
(SELECT AVG(score) FROM user_namescore)
);
insert into avg_score(caltime,amount,maxsocre,average)
select NOW(),
(SELECT COUNT(*) FROM user_namescore),
(SELECT MAX(score) AS score FROM user_namescore),
(SELECT MIN(score) AS score FROM user_namescore),
(SELECT AVG(score) FROM user_namescore);