no pains no gains
发布时间:2017-06-15 13:50:01
select into from 和 insert into select都是用来复制表,两者的主要区别为: select into from 要求目标表不存在,因为在插入时会自动创建。insert into select from 要求目标表存在备份表数据: create table emp as select * from scott.emp还原表数据:insert into emp select * from scott.emp.........【阅读全文】