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,

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