create temporary table in enginge with innodb code example

Example: how to view created temporary tables in mysql

SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%';