mysql list temporary tables code example

Example: how to view created temporary tables in mysql

SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%';