mysql temporary tables data stay the same code example Example: how to view created temporary tables in mysql SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%';