Skip to content

Instantly share code, notes, and snippets.

@sankars

sankars/mysql_meta.sql

Created April 23, 2014 07:01
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sankars/11205143 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sankars/11205143 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql meta data related queries
Raw
mysql_meta.sql
-- http://stackoverflow.com/questions/898688/how-to-get-database-structure-in-mysql-via-query
DESCRIBE table;
SHOW TABLES;
SHOW TABLES LIKE '%filter%'
-- print create table query
SHOW CREATE TABLE table;
-- show active sessions
show PROCESSLIST
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment