第一个问题:mysql> select count(*) from a;
+----------+
| count(*) |
+----------+
| 1000000 |
+----------+
1 row in set (2.11 sec)mysql> insert into b select id as sid, name as sname, content as scontent, '' fr
om a ;
Query OK, 1000000 rows affected (23.58 sec)
Records: 1000000 Duplicates: 0 Warnings: 0
+----------+
| count(*) |
+----------+
| 1000000 |
+----------+
1 row in set (2.11 sec)mysql> insert into b select id as sid, name as sname, content as scontent, '' fr
om a ;
Query OK, 1000000 rows affected (23.58 sec)
Records: 1000000 Duplicates: 0 Warnings: 0
其次,二楼说的记录当前页面?是用MYSQL?