Re: Question on V5.0.9 and SHOW command

2005-08-05 Thread Gleb Paharenko
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,

Question on V5.0.9 and SHOW command

2005-08-04 Thread TheRefUmp
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 asso