perl + mysql

rjsaulakh has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: perl + mysql by xorl (Deacon) on May 26, 2005 at 12:24 UTC
DBI and DBD::mysql EDIT: As mentioned below there is also Net::MySql	[reply]
Re: perl + mysql by marto (Cardinal) on May 26, 2005 at 12:27 UTC
Hi, Check out this link. Hope this helps. Cheers Martin	[reply]
Re: perl + mysql by lamp (Chaplain) on May 26, 2005 at 12:30 UTC
Please go through Class::DBI Intro for more information. --Binoj	[reply]
Re: perl + mysql by tbone1 (Monsignor) on May 26, 2005 at 13:56 UTC
how can i interact using perl with mysql "Poorly" would be my guess, based on empirical evidence and a cantankerous morning. -- tbone1, YAPS (Yet Another Perl Schlub) And remember, if he succeeds, so what. - Chick McGee	[reply]
Re: perl + mysql by displeaser (Hermit) on May 26, 2005 at 13:17 UTC
Hi, I've used Net::MySql and find it quite good for the simple tasks I gave it. Hope this helps Displeaser	[reply]
Re: perl + mysql by chas (Priest) on May 26, 2005 at 14:35 UTC
Here is a simple script to test use of DBI, etc: `use DBI; @driver_names = DBI->available_drivers; print "@driver_names\n"; $DSN="DBI:mysql:database=test"; my $dbi=DBI->connect($DSN,"","") or die "Can't connect\n"; my $sth=$dbi->prepare("SHOW DATABASES"); $sth->execute(); $databases=$sth->fetchall_arrayref; for(@$databases){print "@$_\n"} $sth->finish(); $dbi->disconnect; exit;` [download] (You have to have mysql running first. Also, in the connect statement you may need to put the username and password; you can give the password as an argument to the script so you don't hardcode it in.) chas	[reply] [d/l]