同时插入多条数据
<span style="font-size:24px;"> <span style="color:#ff6600;">//从一个表查询数据插入到新表</span>
insert into table(col1,col2) select col1,col2 from table2;
<span style="color:#ff0000;">//往表里直接插入数据</span>
insert into table (id,name) select 1,‘小明’ from dual
union all
select 2,‘晓红’ from dual 。。。。。</span>
同时更新多条数据
<span style="font-size:24px;">update table1 set(col1,col2)=(select col1,col2 from table2)where ?=?;</span>