koti688
Novice
Oct 29, 2008, 1:04 AM
Post #1 of 2
(1820 views)
|
|
Insert,update,select, delete quires in MySql Using Perl
|
Can't Post
|
|
Hi Guyz
i Have a Mysql DB which resides on my local machine. I want to Prepare a Perl Module which will be containing function for the following DB Operations
-Select
-Insert
-Delete
-Update
DB Deatils are :
Localhost,MySql,DatabaseName:perltest, username:root,pwd:sierra
I can able to do the following thing for selecting rows in Db.
#!/usr/bin/perl -w
use DBI;
$dbh = DBI->connect('dbi:mysql:perltest','root','sierra')
or die "Connection Error: $DBI::errstr\n";
$sql = "select * from samples";
$sth = $dbh->prepare($sql);
$sth->execute
or die "SQL Error: $DBI::errstr\n";
while (@row = $sth->fetchrow_array) {
print "@row\n";
}
But not able to do Insert , delet and update operations and made all the functions into a package.coul guyz help me in doing these things. I am a beginner to perl. expecting quick replys from u.
You can mail me ur proceeding to this id koti688@gmail.com or koteswara.devarasetty@sierraatlantic.com
Thanks in Advance
Koti.
|
MAIN
SEARCH
WHO'S 
LOG 