sqlite 同个数据库下把一个表中的某些数据复制到另一个表中

数据库test.db中有两个已经建立了的表：people、new_people。

sqlite> select * from people
   ...> ;
1|Limin|20|15768600001
2|zhangsan|21|15768600002
3|chenpi|22|15768600003
4|huangyuan|21|15768600002
5|zhangsi|22|15768600003

语句： insert into 目标表 select * from 原表 where 索引项 = 索引值；

sqlite> select * from new_people;
sqlite> insert into new_people select *  from people where name = 'chenpi';
sqlite> select * from new_people;
3|chenpi|22|15768600003