mysql find recently created-tables

on

The query to find recently created tables in mysql

select table_schema, table_name, create_time
from information_schema.TABLES
where table_schema not in ('information_schema', 'mysql')
order by CREATE_TIME desc

Suggested posts:

  1. Display keys added to ssh-agent using ssh-add
  2. Git – how to view diff for a given commit id
  3. CSS – round toggle switch using checkbox and label
  4. How to find mysql query rate on Linux
  5. Chrome – copy any request as cURL including headers
  6. Mysql – get total queries since beginning
  7. prevent wordpress xmlrpc.php attack
  8. HTML li tag
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in | Tagged