Re: Return the column names of MySQL table?
| From: | Geoff Hankerson | Date: | Tue, 19 Mar 2002 22:50:02 +0000 |
| Subject: | Re: Return the column names of MySQL table? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-89228@lists.php.net to get a copy of this message | ||
I believe it is:
describe tablename;
----- Original Message -----
From: "Kevin Stone" <kevin@helpelf.com>
To: <php-general@lists.php.net>
Sent: Tuesday, March 19, 2002 4:43 PM
Subject: [PHP] Return the column names of MySQL table?
> Forgive me for the off topic question. This is a MySQL question.. has
> nothing to do with PHP directly. However I was not able to find an
> answer in the MySQL documentation, on Usenet, or the MySQL mailing list
> archives. Also MySQL.com's mail manager is on the fritz so I can't
> even subscribe to the MySQL email list. Anyway since many of you are
> familiar with SQL this is as good a place to ask this question as any.
>
> I simply need to return a list of column names of a MySQL table. What's
> the syntax to do that?
>
> Thanks,
> Kevin
>