create temporary table mysql while executing query code example
Example 1: create temporary table in mysql
CREATE TEMPORARY TABLE new_tbl SELECT * FROM orig_tbl LIMIT 0;
Example 2: how to view created temporary tables in mysql
SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%';