connecting to SQL 3

[perlone]

I learned some basics of SQL but how do i connect it to perl? So i could use the sql statements on perl like(SELECT,UPDATE).

 

[hmerrill]

I assume that by "SQL" you mean you want to connect Perl to a database - or use Perl to access a database using SQL statements like SELECT and UPDATE. Have a look at the Connecting Perl to Databases FAQ in this forum - it tells you where to find Perl Database resources. You'll first have to decide which database you're going to use - assuming that it will be MySQL(since I have to just pick one for an example), then you'll need to install

1. MySQL, and get it working, then
2. Perl "DBI"
3. Perl "DBD::mysql"

If you're not experienced with databases, then step 1 will probably take you some time. Don't dive into 2 or 3 until you are comfortable that your database is up and running smoothly, and you're able to connect to it and interact with it using the database client(for MySQL the client is "mysql", for Oracle the client is "sqlplus", etc.).

If you do choose MySQL, their website(

http://www.mysql.com)

has lots of very good information on all aspects of MySQL, including tutorials. Whichever db you choose, find a good tutorial, and I would advise to buy at least 1 good book on that db.

HTH.
Hardy Merrill
Mission Critical Linux, Inc.

http://www.missioncriticallinux.com

 

[goBoating]

Every thing you ever wanted to know about.....

http://dbi.symbolstone.org/cgi/summarydump?module=Msql-Mysql-modules

Short answer,

http://mysql.turbolift.com/mysql/DBD_3.21.X.php3#connect

HTH



keep the rudder amid ship and beware the odd typo

 

[perlone]

allright. Thanks.

 

[vcherubini]

I would also highly suggest reading Programming The Perl DBI by Descartes and Bunce. Excellent book by O'Reilly that is only about 30 bucks.

It is definitely the most comprehensive book I have read in regards to Perl and the DBI (seeing as Tim Bunce is the original author of the DBI).

Anyway, thats just what I suggest.

Hope this helps.

-Vic vic cherubini
krs-one@cnunited.com

http://www.cnunited.com

====
Knows: Perl, HTML, JavScript, C/C++, PHP, Flash
====

 

[hmerrill]

I agree with Vic - that is an excellent book that I would also highly recommend.

I also wanted to suggest you read the perldocs that come with your Perl installation and that come with each Perl module you install from CPAN.

To see the perldocs for the DBI module, do this(after you've successfully installed the module)

perldoc DBI

And to see the perldocs for the DBD::mysql module, do this:

perldoc DBD::mysql

This is true on *nix, but I'm not sure how to get those same perldocs on a windows system.

HTH.
Hardy Merrill
Mission Critical Linux, Inc.

http://www.missioncriticallinux.com