注意插入的sql语句的用法;
insert into 后面要跟着要插入的表中。
INSERT INTO dept_age (Sdept, Avg_age) SELECT
sdept,
AVG(sage)
FROM
student
GROUP BY
sdept
注意插入的sql语句的用法;
insert into 后面要跟着要插入的表中。
INSERT INTO dept_age (Sdept, Avg_age) SELECT
sdept,
AVG(sage)
FROM
student
GROUP BY
sdept