Hello.
I'm using MySQL 5.0.10 and perl-DBD-mysql-2.90.06-alt1 (from ALT Linux).
I didn't find such weird behavior. Can you send the code of your
program. Here is the example of mine which works fine:
#!/usr/bin/perl
#
use strict;
use DBI;
use User::pwent;
use POSIX;
my ($dbh,$sth,$sql,@row,$numFields,$i);
$dbh = DBI->connect
("DBI:mysql:test:localhost;mysql_read_default_file=/home/gleb/mysqls/mysql-debug-5.0.10-beta-linux-i686/my.cnf;".
"mysql_read_default_group=client",
"root","",
{RaiseError => 1})
or die "connecting : $DBI::errstr\n";
$sth = $dbh->prepare("SHOW FIELDS FROM vch");
$sth->execute;
$numFields = $sth->{'NUM_OF_FIELDS'};
my $names = $sth->{'NAME'};
while((@row) = $sth->fetchrow_array () ) {
for($i=0; $i < $numFields; $i++)
{
print $$names[$i].": ".$row[$i]."\n";
}
}
$sth->finish;
$dbh->disconnect;
And the output:
Field: a
Type: varchar(40)
Null: YES
Key:
Default:
Extra:
netscape.net wrote:
> Hello,
> I have a strange issue. When I issue the command SHOW COLUMNS from TABLE
> XYZ I get the usual output.The key field is blank because there is no key on
> the field. However, when I issue the command from a PERL script the the
> DBI::DBD it returns MUL in the key field. There is no index associated with
> this column either it's a straight VARCHAR(40) field.
> Anyone have any ideas?
>
> Regards,
> George
>
> __________________________________________________________________
> Switch to Netscape Internet Service.
> As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
>
> Netscape. Just the Net You Need.
>
> New! Netscape Toolbar for Internet Explorer
> Search from anywhere on the Web and block those annoying pop-ups.
> Download now at http://channels.netscape.com/ns/search/install.jsp
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
