mysql> select * from t_subscribe; +------+-------------+---------------------+
| uid | strategy_id | date | +------+-------------+---------------------+
| 1233 | 123414 | 2015-06-11 10:19:52 |
| 0 | 0 | 2015-06-11 10:19:52 |
| 1 | 1 | 2015-06-11 10:19:52 |
| 2 | 2 | 2015-06-11 10:19:52 |
| 3 | 3 | 2015-06-11 10:19:52 |
| 4 | 4 | 2015-06-11 10:19:52 |
| 5 | 5 | 2015-06-11 10:19:52 |
| 6 | 6 | 2015-06-11 10:19:52 |
| 7 | 7 | 2015-06-11 10:19:52 |
| 8 | 8 | 2015-06-11 10:19:52 |
| 9 | 9 | 2015-06-11 10:19:52 | +------+-------------+---------------------+
11 rows in set (0.00 sec)
mysql> create table test select * from t_subscribe; Query OK, 11 rows affected (0.03 sec) Records: 11 Duplicates: 0 Warnings: 0mysql> select * from test; +------+-------------+---------------------+
| uid | strategy_id | date | +------+-------------+---------------------+
| 1233 | 123414 | 2015-06-11 10:19:52 |
| 0 | 0 | 2015-06-11 10:19:52 |
| 1 | 1 | 2015-06-11 10:19:52 |
| 2 | 2 | 2015-06-11 10:19:52 |
| 3 | 3 | 2015-06-11 10:19:52 |
| 4 | 4 | 2015-06-11 10:19:52 |
| 5 | 5 | 2015-06-11 10:19:52 |
| 6 | 6 | 2015-06-11 10:19:52 |
| 7 | 7 | 2015-06-11 10:19:52 |
| 8 | 8 | 2015-06-11 10:19:52 |
| 9 | 9 | 2015-06-11 10:19:52 | +------+-------------+---------------------+
mysql> insert into test select * from t_subscribe; Query OK, 11 rows affected (0.00 sec) Records: 11 Duplicates: 0 Warnings: 0mysql> select * from test; +------+-------------+---------------------+
| uid | strategy_id | date | +------+-------------+---------------------+
| 1233 | 123414 | 2015-06-11 10:19:52 |
| 0 | 0 | 2015-06-11 10:19:52 |
| 1 | 1 | 2015-06-11 10:19:52 |
| 2 | 2 | 2015-06-11 10:19:52 |
| 3 | 3 | 2015-06-11 10:19:52 |
| 4 | 4 | 2015-06-11 10:19:52 |
| 5 | 5 | 2015-06-11 10:19:52 |
| 6 | 6 | 2015-06-11 10:19:52 |
| 7 | 7 | 2015-06-11 10:19:52 |
| 8 | 8 | 2015-06-11 10:19:52 |
| 9 | 9 | 2015-06-11 10:19:52 |
| 1233 | 123414 | 2015-06-11 10:19:52 |
| 0 | 0 | 2015-06-11 10:19:52 |
| 1 | 1 | 2015-06-11 10:19:52 |
| 2 | 2 | 2015-06-11 10:19:52 |
| 3 | 3 | 2015-06-11 10:19:52 |
| 4 | 4 | 2015-06-11 10:19:52 |
| 5 | 5 | 2015-06-11 10:19:52 |
| 6 | 6 | 2015-06-11 10:19:52 |
| 7 | 7 | 2015-06-11 10:19:52 |
| 8 | 8 | 2015-06-11 10:19:52 |
| 9 | 9 | 2015-06-11 10:19:52 | +------+-------------+---------------------+
22 rows in set (0.00 sec)