Ich würde mal behaupten so:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
use strict;
use warnings;
use DBI;
my $dbh = DBI->connect("dbi:SQLite:dbname=test.sqlite","","") or die DBI::errstr();
$dbh->do("UPDATE test SET spalte3='verändert' WHERE spalte2='zeile2'");
# Mal schaun
my $sth = $dbh->prepare("SELECT * FROM test");
$sth->execute();
while (my @row = $sth->fetchrow_array()) {
local $, = '|';
print @row,"\n";
}
# Geht doch;p
$sth->finish();
$dbh->disconnect();
Gruß Alex