checking presence of table columns in mysql

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Mike Starke
Date:  
Subject: checking presence of table columns in mysql
On Mon, Feb 10, 2003 at 08:44:48PM -0700, Lynn David Newton wrote:
/_
/_Since there seems to be some mysql expertise on the
/_list: Does anyone know of a SQL based way to check for
/_the existence of a particular column by name? This came
/_up in work today. I've never been able to do it. I'm
/_not so sure it's possible.
/_

Hmmm, have you tried looking in the array:

my $names = $sth->{NAME} ;