MySQL 插入查询数据 asing1elife | 2017-09-14 | database , mysql 版权声明:本文首发 http://asing1elife.com ,转发请注明出处,讲文明懂礼貌! 以下语法可将查询结果直接插入指定表 语法 123456789101112131415INSERT 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';