ecco un pò di esempi:

codice:
use DBI;

$dbh = DBI->connect ("DBI:mysql:dbname=prova_db");
@linea = $dbh->selectrow_array("SELECT * FROM indirizzi");

foreach $line (@linea) {
  print $line, "\n";
}
codice:
use DBI;

$dbh = DBI->connect ("DBI:mysql:dbname=prova_db");

$sth = $dbh->prepare( q{
  SELECT nome, cognome, email 
  FROM indirizzi
} );

$sth->execute;

while (($nome, $cognome, $email) = $sth->fetchrow_array) {
  print "$nome $cognome, $email\n";
}
codice:
use DBI;

$dbh = DBI->connect ("DBI:mysql:dbname=prova_db");

$sth = $dbh->prepare("INSERT INTO table(foo,bar,baz) VALUES (?,?,?)");

$sth->execute( $foo, $bar, $baz );