how to use temporary table mysql 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%';