Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Dump mysql table descriptions of all tables in db to tab separated file
mysql -h 127.0.0.1 -P 3306 db_name -u foo --password=bar -e "SELECT TABLE_NAME, COLUMN_NAME, COLUMN_TYPE FROM information_schema.columns WHERE table_schema = 'db_name';" > out.tsv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment