#!/usr/bin/perl
use strict;
use warnings;
use DBI;
my $db_source = 'DBI:mysql:mydatabase';
my $user = 'myname';
my $pass = 'mypassword';
my $statement = 'SELECT `id` FROM `mytable` LIMIT 0 , 30;';
my $dbh = DBI->connect($db_source, $user, $pass) || die $DBI::errstr;
my $sth = $dbh->prepare($statement) || die $dbh->errstr;
my $result_set = $sth->execute || die $sth->errstr;
if ($result_set) {
my $rows = $sth->rows;
print "$rows records found.\n";
for (my $i = 0; $i < $rows; $i++) {
my @result = $sth->fetchrow_array;
print "$result[0]\n";
}
}
$sth->finish;
$dbh->disconnect;