insert into ... from
mysql> create table tmp_02 as select * from tmp where 1 = 0;
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> select * from tmp;
+---------------------+
| dt |
+---------------------+
| 2012-12-11 14:24:33 |
| 2012-12-11 14:24:39 |
| 2012-12-11 14:25:53 |
| 2012-12-11 14:31:11 |
| 2012-12-11 14:31:11 |
+---------------------+
5 rows in set (0.01 sec)
mysql> select * from tmp_02;
Empty set (0.00 sec)
mysql> insert into tmp_02 select * from tmp;
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql> select * from tmp_02;
+---------------------+
| dt |
+---------------------+
| 2012-12-11 14:24:33 |
| 2012-12-11 14:24:39 |
| 2012-12-11 14:25:53 |
| 2012-12-11 14:31:11 |
| 2012-12-11 14:31:11 |
+---------------------+
5 rows in set (0.00 sec)
select into ... from