Re: Getting field names from a given table

[Paul DuBois]

At 4:56 PM +0000 7/27/99, al wrote:
>Does anyone no a way that I can get a list of all the field names I am
>using in a particular mysql table? That is, is there a way either using
>the mysql command-line client or the Perl DBI module to do this?

Issue a DESCRIBE tbl_name statement.

If you're doing this with DBI, handle it the same way you would for
a SELECT (prepare + execute + fetch loop) and look at the first
column of the output.

-- 
Paul DuBois, paul@stripped