Re: Create Temporary Table from Partitioned Table

[Aftab Khan]

Questions

show create table...
and the query you tried to create temporary table?

Examples:

mysql> explain partitions select * from order where order_date between '2008-01-01 00:00:00' and '2008-12-01 00:00:00';
+----+-------------+-----------+------------+------+---------------+------+---------+------+--------+-------------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------+------------+------+---------------+------+---------+------+--------+-------------+
| 1 | SIMPLE | order | p2008 | ALL | order_date | NULL | NULL | NULL | 311145 | Using where |
+----+-------------+-----------+------------+------+---------------+------+---------+------+--------+-------------+
1 row in set (0.00 sec)

mysql> create temporary table sop_order_t select * from order where order_date between '2008-01-01 00:00:00' and '2008-12-01 00:00:00';
Query OK, 113830 rows affected (2.03 sec)
Records: 113830 Duplicates: 0 Warnings: 0