Skip to content

Instantly share code, notes, and snippets.

@groman-me

groman-me/meta_info.sql

Created August 22, 2012 08:33
Show Gist options
  • Save groman-me/3423774 to your computer and use it in GitHub Desktop.
Save groman-me/3423774 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL meta info (table create time)
Raw
meta_info.sql
SELECT create_time FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'schema' AND table_name = 'name';
SHOW ENGINE INNODB STATUS;
SHOW CREATE TABLE foo;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment