I’m learning SQL with MySQL 5.7. And I wanna enumerate all tables include temporary tables!
But when I query SHOW TABLES; It shows only non-temporary tables.
How can I list all tables?
Advertisement
Answer
In innodb you could us e
SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%';
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html