How to get the latest created table in MySQL?

mysql

Solution

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

Problem

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

Original source