[Chicago-talk] perl DBI error
Don Drake
don at drakeconsulting.com
Tue Apr 2 10:55:53 PDT 2013
Try using the INFORMATION SCHEMA database:
my $dbh = DBI->connect( "DBI:mysql:information_schema;192.168.0.1", $usrr, $passw, { RaiseError => 3 } );
-Don
--
Don Drake
www.drakeconsulting.com
www.maillaunder.com
312-560-1574
800-733-2143
On Apr 2, 2013, at 12:51 PM, Richard Reina <richard at rushlogistics.com> wrote:
> use DBI;
> my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, { RaiseError => 3 } );
> my $dbs = $dbh->selectcol_arrayref("show databases");
>
> my $dbs = $dbh->selectcol_arrayref('show databases');
>
> print "@$dbs\n";
>
> When I query the server for a list of databases with the code above it returns the name of just two and there are over 10.
>
> Any ideas?
>
> Thanks
> --
> Richard Reina
> Rush Logistics, Inc.
> Watch our 3 minute movie:
> http://www.rushlogistics.com/movie
>
> _______________________________________________
> Chicago-talk mailing list
> Chicago-talk at pm.org
> http://mail.pm.org/mailman/listinfo/chicago-talk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/chicago-talk/attachments/20130402/c77cfcaf/attachment.html>
More information about the Chicago-talk
mailing list