Hi,
You didn't say if you are running Windows, Linux or something else...
If you have Linux, you probably already have perl. If you use Windows, get
and install perl from www.activestate.com.
You must also get and install MySQL from www.mysql.com if you don't have
it
installed.
Then you need to install the modules DBI and DBD::mysql using (under
Unix/Linux):
$ cpan
cpan> install DBI
cpan> install DBD::mysql
or
cpan> force install DBD::mysql
Then you could read more about these modules using:
$ perldoc DBI
$ perldoc DBD::mysql
and you can start using them like:
my $dbh = DBI->connect("dbi:mysql:database=test", "username",
"thePassword");
#Create a table
$dbh->do("create table foo(id int unsigned not null autoincrement primary
key, body text)");
#Insert a few rows
my $sth = $dbh->prepare("insert into foo(id, body) values(?, ?)");
my @[EMAIL PROTECTED]
= qw/foo bar baz/;
foreach my $body(@[EMAIL PROTECTED]
) {
$sth->execute(undef, $body);
}
#select a row
my $sth2 = $dbh->prepare("select id, body from foo where id=?");
$sth2->execute(3);
my ($id, $body) = $sth2->fetchrow_array;
You will find many ways of using DBI from the POD doc.
HTH.
Octavian
----- Original Message -----
From: "Richard Lee" <rich.japh@[EMAIL PROTECTED]
>
Cc: <beginners@[EMAIL PROTECTED]
>
Sent: Sunday, April 27, 2008 6:24 AM
Subject: sql and perl
> Hello guys,
>
> I want to start learning about sql and how it interacts w/ perl.
>
> My rough idea is to install mysql server and read some books to start
> playing w/ it along w/ perl.
> Any advice?
>
> For now, I just plan to go through the book 'mysql and perl for the
> web'....
>
> If someone can post some excellent site relates to mysql and perl..
would
> be appreciated.
> I will post related questions along the way(also, please let me know if
> this is not the right mailing list for this and if something exists that
I
> am not aware of at this point)
>
> thanks!!
>
> --
> To unsubscribe, e-mail: beginners-unsubscribe@[EMAIL PROTECTED]
> For additional commands, e-mail: beginners-help@[EMAIL PROTECTED]
> http://learn.perl.org/
>
>
|
