1. Home
  2. Computing & Technology
  3. PHP / MySQL

Show Columns - MySQL Command

By Angela Bradley, About.com

Definition: The show columns MySQL command is used to display all the columns on a given table as well as any details about them. It is phrased as: show columns from table_name;
Examples:
show columns from new_cars;

This would show all the columns and their information from the table 'new_cars'.

Explore PHP / MySQL

More from About.com

  1. Home
  2. Computing & Technology
  3. PHP / MySQL
  4. MySQL Commands
  5. Show Columns MySQL - MySQL Command Show Columns - Show MySQL Columns

©2008 About.com, a part of The New York Times Company.

All rights reserved.