List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 31 2002 6:11am
Subject:Re: column names
View as plain text  
At 0:06 -0600 3/31/02, Alex Behrens wrote:
>Hey Guys,
>
>What is the command to display the names of all the columns in a table?

SHOW COLUMNS FROM tbl_name;
DESCRIBE tbl_name;
EXPLAIN tbl_name;

They're described in the manual.

>
>-mysql
>Thanks!
>--------------------------------------------
>-Alex "Big Al" Behrens
>E-mail: bigal@stripped
>Urgent E-mail: bigal-cell@stripped (Please be brief!)
>Phone: 651-482-8779
>Cell: 651-329-4187
>Fax: 651-482-1391
>ICQ: 3969599
>Owner of the 3D-Unlimited Network:
>http://www.3d-unlimited.com
>Send News:
>news@stripped

Thread
column namesAlex Behrens31 Mar
  • Re: column namesPaul DuBois31 Mar