CODE EXAMPLE FOR SQL

how to view created temporary tables in mysql

 SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%';