Thread next_insert_id (12 answers)
Opened by Froschpopo at 2005-05-13 15:11

Strat
 2005-05-13 16:15
#33233 #33233
User since
2003-08-04
5246 Artikel
ModeratorIn
[Homepage] [default_avatar]
wenn du eine grosse datenmenge hast, dann vielleicht besser:
Code: (dl )
1
2
3
4
5
6
7
8
9
10
11
my $sql = "Select name FROM table WHERE Bedingung ORDER BY name";
my $sth = $dbh->prepare($sql)
or die "Error in preparing statement: $DBI::errstr\n$sql\n";
$dbh->execute() or die "Error in executing statement: $DBI::errstr\n$sql\n";
while (my $data = $sth->fetchrow_hashref()) {
foreach my $key (sort keys %$data) {
print "$key => $data->{$key}\t";
} # foreach
print "\n";
} # while
$sth->finish();
perl -le "s::*erlco'unaty.'.dk':e,y;*kn:ai;penmic;;print"
http://www.fabiani.net/

View full thread next_insert_id