faqts : Computers : Databases : MySQL : Language and Syntax

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

11 of 13 people (85%) answered Yes
Recently 9 of 10 people (90%) answered Yes

Entry

How do I get only get the names of the columns of a table?

Jun 22nd, 2001 16:00
John Marc, Mike DeWolfe,


See the documentation.
The syntax is SHOW FIELDS from table_name
or
SHOW COLUMNS from table_name
or 
EXPLAIN table_name
or 
DESCRIBE table_name