MySQL data access

vignesh1985

hi,

can u please explain how to retrieve two colums of data from two different mysql table using perl with example.

thank u

savanm

hi,

Expand|Select|Wrap|Line Numbers

 
use DBI;
 
my $dbh = DBI->connect("DBI:mysql:database=perldbi;host=localhost","root","");
 
my $userid;

my $sth = $dbh->prepare('select usrid from foo1');

$sth->execute() or die $dbh->errstr;

$sth->bind_columns(\$userid);

while ($sth->fetch) {

    print "\t$userid\n";

}

$sth->finish();
 
my $name;

my $sth1=$dbh->prepare('select name from test');

$sth1->execute() or die $dbh->errstr;

$sth1->bind_columns(\$name);

while ($sth1->fetch) {

    print "\t$name\n";

}

$sth1->finish();
 
$dbh->disconnect();

Hi here two tables foo and test from a single database perldbi,

And we retrieve userid from foo and name from test, i think this is ur need

MySQL data access

re: MySQL data access

Similar Perl bytes

/bytes/development

/bytes/it

/bytes/about