Table Information
Hi All,
I want to get the information about a table i mean getting
the column name and type. I am using the below code:
my $possible_inquiryTypes = $dbh->prepare_cached('DESC
ticket_inquiry_type');
$possible_inquiryTypes->execute();
while( my $option = $possible_inquiryTypes->fetchrow() ) {
print $option;
}
It is not printing anything. But when i used the below code
my $count = $possible_inquiryTypes->execute();
print $count;
---------------------------------------------------------------> it
printed 2
Does anyone know the problem in this?
|