News
The third form of the CREATE TABLE statement stores the results of any query-expression in a table and does not display the output. It is a convenient way to create temporary tables that are subsets ...
If I create an identical non-temporary table the on-disk data file is ~100MB (engine=myisam). I have tmp_table_size for MySQL set to 256MB and max_heap_table_size set to 512MB.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback