从一张表抓取数据插入另外一张表

insert into t2 select * from t1 limit 100;