MySQL Forums
Forum List  »  Perl

Re: How to get column names
Posted by: potherca catcher
Date: July 18, 2007 05:49PM

I was looking for this to, only in PHP... I don't know the PERL function for it, but the MySQL query is
DESCRIBE `person`;
or you can use
SHOW COLUMNS FROM `person`;
which does the same thing...
I found it in the online manual:
13.5.4.3. SHOW COLUMNS Syntax http://dev.mysql.com/doc/refman/5.0/en/show-columns.html
and
13.3.1. DESCRIBE Syntax http://dev.mysql.com/doc/refman/5.0/en/describe.html
Hope this helps.

Options: ReplyQuote


Subject
Written By
Posted
June 19, 2007 04:29AM
Re: How to get column names
July 18, 2007 05:49PM
November 05, 2007 08:10PM
J H
July 07, 2008 06:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.