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%';
SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%';