More than 5 years have passed since last update.

MySQL で直近変更のあったテーブルを確認する

MySQL
備忘録
走り書き
サーバー移行

Posted at 2018-12-27

SELECT
  TABLE_SCHEMA,
  TABLE_NAME,
  UPDATE_TIME
FROM information_schema.tables
WHERE TABLE_SCHEMA = '{{ database_name }}'
ORDER BY UPDATE_TIME DESC;

TABLE_SCHEMA データベースの事

Reference

ベースの SQL を見つけた場所
https://stackoverflow.com/a/307488

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up