比较菜的问题

[jimever]

把表1中部分数据剪切到表2，怎么做
要insert into后再delete吗

[pengdali]

insert 表2 (xx,yy) select xx,yy from 表1 where xx=34

[txlicenhe]

insert 表2 (xx,yy) select xx,yy from 表1 where xx=34
delete 表 1 where xx = 34

[愉快的登山者]

select colname, ... into table2 from table1 where ...

[friendliu]

insert tablename select * from sourcetablename where 条件。。。。。