以下语法可将查询结果直接插入指定表
更多精彩
- 更多技术博客,请移步 asing1elife’s blog
语法
INSERT INTO pt_project (
name,
teachingDate,
teachingNo,
description
)
SELECT
pr.name,
pr.teachingDate,
pr.teachingNo,
pr.description
FROM
pt_project pr
WHERE
pr.course_id = '8';
以下语法可将查询结果直接插入指定表
INSERT INTO pt_project (
name,
teachingDate,
teachingNo,
description
)
SELECT
pr.name,
pr.teachingDate,
pr.teachingNo,
pr.description
FROM
pt_project pr
WHERE
pr.course_id = '8';