List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 27 1999 4:01pm
Subject:Re: Getting field names from a given table
View as plain text  
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
Thread
Getting field names from a given tableal27 Jul
  • Re: Getting field names from a given tablePaul DuBois27 Jul
  • Re: Getting field names from a given tableJeff Urban27 Jul
  • Getting field names from a given tablesinisa27 Jul
  • Re: Getting field names from a given tableRich Bowen27 Jul
    • Re: Getting field names from a given tablePaul DuBois27 Jul