如何将记录一条条的追加到另外一个表中?

[CSgogogo]

我想将yb里的数据通过查询语句查询出来后一条条的追加到new的表中?
这两个表的表结构相同!
select * into new from yb where xm='李新'
我通过上面的语句只能追加一次!再想追加XM='王心'怎么添加呢?

[愉快的登山者]

insert new select * from yb where xm='王心'

[txlicenhe]

1:insert into new select * from yb where xm = '王心'
2: 全部
select * into new from yb
或
insert into new select * from yb

[pengdali]

insert new select * from yb where xm='李新'

[zjcxc]

insert new select * from yb where xm='李新'

[cbzdream]

insert new select * from yb where xm='李新'

[wp0613]

第一次用select * into new from yb where xm='李新' 语句生成一个新的表。因后再向插入使用
insert into new select * from yb where xm='王心'

[Wally_wu]

insert into new select * from yb where xm='王心'