UltraSmooth
Programmer
Is there any way of creating a temporary table from a partitioned table? I do not require the partitions for the temporary table, just the table structure. Mysql gives me the error "Cannot create temporary table with partitions" using the command
CREATE TEMPORARY TABLE tmp_tbl LIKE tblname;
(Actually that command executes fine but any subsequent commands on the temporary table gives the error message)
Any ideas?
CREATE TEMPORARY TABLE tmp_tbl LIKE tblname;
(Actually that command executes fine but any subsequent commands on the temporary table gives the error message)
Any ideas?
