root@database-one 14:08: [gftest]> create table testot(id int not null auto_increment primary key,context text) engine=innodb;
Query OK, 0 rows affected (0.02 sec)
root@database-one 14:09: [gftest]> insert into testot(context) values(repeat('nanjing',100));
Query OK, 1 row affected (0.00 sec)
root@database-one 14:10: [gftest]> insert into testot(context) values(repeat('shanghai',100));
Query OK, 1 row affected (0.00 sec)
root@database-one 14:10: [gftest]> insert into testot(context) values(repeat('beijing',100));
Query OK, 1 row affected (0.00 sec)
root@database-one 14:10: [gftest]> insert into testot(context) values(repeat('shenzhen',100));
Query OK, 1 row affected (0.00 sec)
root@database-one 14:11: [gftest]> insert into testot(context) select context from testot;
Query OK, 4