Skip to content

Instantly share code, notes, and snippets.

@stormwild

stormwild/show_table_columns

Created June 10, 2013 06:26
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save stormwild/5746877 to your computer and use it in GitHub Desktop.
Download ZIP
SHOW COLUMNS displays information about the columns in a given table. It also works for views as of MySQL 5.0.1.
Raw
show_table_columns
#http://dev.mysql.com/doc/refman/5.0/en/show-columns.html
SHOW COLUMNS FROM City;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment