How to get the latest created table in MySQL?

Question

I have a MySQL database and every 6 months, a new table is created with the latest entries. What SQL command can get you the latest created table in a database?

Many thanks

Answer 1

You can select the last create_time from information_schema.TABLES.

For example:

select table_name, create_time 
from information_schema.TABLES
where table_schema = 'andomar'
order by CREATE_TIME desc
limit 1

Answer 2

You can display from a particular database

SELECT *
FROM information_schema.TABLES
WHERE table_schema = 'database_name'
ORDER BY `TABLES`.`CREATE_TIME` DESC