数据库 - mysql 如何快速插入测试数据

Question

自己插入一条，
然后根据子查询继续插入

insert into `table` (`a`,`b`) values(select `a`,`b` from `table` );

如何才能做到这样?

Answer 1

insert into table_name(column...) select column... from source_table;

Answer 2

insert into table_name(a,b) select a,b from source_table;