how to view created temporary tables in mysql
snippet in sql

create temporary table in mysql

user7020

CREATE TEMPORARY TABLE new_tbl SELECT * FROM orig_tbl LIMIT 0;

how to view created temporary tables in mysql

user1902

 SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%';