Describe the column structure of a MySQL table

Home -> Database -> MySQL

24251 views

From the computer of: qmchenry (339 recipes)
Created: Dec 14, 2003     Updated: Nov 06, 2006


1 comments:
View all comments

Add a comment

Add to:
Add to stumbleuponAdd to del.icio.usDigg itAdd to FURL

The SQL command 'describe' allows you to view the column structure of a MySQL table. It provides a listing of the columns of a table, the type of each column, and additional information on each column.

To view the structure of a MySQL table called 'recipes' use the following SQL command:

describe recipes;


The command can be issued from any SQL source including an application with database connectivity (i.e., PHP, Java, etc.) or directly from mysql command (see Connect to a MySQL server using the mysql command for more information).

Subscribe to the Tech-Recipes Newsletter

You can get tips like this delivered in your email every week!

Enter your Email

We will never, ever sell your email address or spam you.




1 Recipe comments: View comments

Describe the structure of a MySQL table by Anonymous



Related recipes:

  Add a column to an existing MySQL table
  Modify an existing MySQL column
  Delete a column from an existing MySQL table
  Create a MySQL table with a primary key
  Copy an existing MySQL table to a new table
  Create a basic MySQL table
  Drop or delete a table in MySQL
  Use regular expressions in MySQL SELECT statements
  Rename or change name of MySQL table
  Import CSV file directly into MySQL

 

Sponsored links

 

Affiliated Sites


Certification Journals
Free certification exam study guides and help

Tech-Recipes Blogs
More tips and news from the tech-recipes authors

 

Login

Nickname

Password

Don't have an account yet? You can create one. As a registered user you have some advantages like theme manager, comments configuration and post comments with your name.