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

Show Columns - MySQL Command

By , About.com Guide

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
About.com Special Features

The Best Web Trends of the Decade

A look back at the best innovations, ideas and technologies over the last 10 years, More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

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

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

All rights reserved.