Skip to content

Instantly share code, notes, and snippets.

@hmert

hmert/get_table_and_column_names.sql

Created August 2, 2013 13:48
Show Gist options
  • Save hmert/6140007 to your computer and use it in GitHub Desktop.
Save hmert/6140007 to your computer and use it in GitHub Desktop.
Download ZIP
getting all column names from all tables in Mysql without having to list all the tables
Raw
get_table_and_column_names.sql
select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME from information_schema.columns
where table_schema = 'eba'
order by table_name,ordinal_position limit 10000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment