MySQL and Perl

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

Hello,
How with perl I can access MySql database? ( make queries and so on)?
Do I need some modules??? If "yes", then could you tell which modules are the most popular, best....

Edited by BazB: added formatting and fixed title: s/PERl/Perl/.

Comment on MySQL and Perl

Replies are listed 'Best First'.
Re: MySQL and Perl by davido (Cardinal) on Jul 01, 2004 at 07:39 UTC
You need the following: DBI - The DataBase Interface module. DBD::mysql - The Database Driver for MySQL. Class::DBI (optional) - Database abstraction. And while we're at it, I'll recommend "Programming the Perl DBI" (An O'Reilly & Assoc. book). I found it quite helpful. If you need to learn SQL too, there are a million books out there on that subject. All three of those modules are available on CPAN, as well as via PPM for Windows users. Dave	[reply]
Re: MySQL and Perl by falflag (Initiate) on Jul 01, 2004 at 09:06 UTC
For any database access perl can use the DBI module which provides a uniform access towards the database (any type of database). You have to combine the DBI with the rightfull DBD. Sounds hard, but you can find all on http://dev.mysql.com/downloads/dbi.html Explanations on how to use it ...http://www.danchan.com/feature/2000/10/16/mysql/mysql.htm Suc6, Frans. Edited by BazB: linkified links and added formatting	[reply]
Book recommendation by davebaker (Pilgrim) on Jul 01, 2004 at 15:43 UTC
MySQL and Perl for the Web, by Paul DuBois (New Riders). I wish there were more books like it to recommend!	[reply]