版权声明：本文首发 http://asing1elife.com ，转载请注明出处。 https://blog.csdn.net/asing1elife/article/details/82862220
以下语法可将查询结果直接插入指定表
更多精彩
- 更多技术博客，请移步 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';
