无需先建表,并将select的查询结果导入到新表中
CREATE TABLE new_emp AS SELECT * FROM emp WHERE deptno IN(20, 30);
将select查询出的数据,插入到 new_emp 中
INSERT INTO new_emp SELECT * FROM emp WHERE deptno = 10;
注意:insert into XXX select 语句,小数据量没事,如果数据量大的话,有些坑,防范的方法
https://blog.csdn.net/weixin_45586158/article/details/107255421?utm_medium=distribute.pc_relevant.none-task-blog-OPENSEARCH-1.pc_relevant_is_cache&depth_1-utm_source=distribute.pc_relevant.none-task-blog-OPENSEARCH-1.pc_relevant_is_cache