add this:
$sth -> finish;
$dbh -> disconnect;
to the end
- Original Message -
From: "Simon Chan" <[EMAIL PROTECTED]>
To: "mysql Mail List" <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 11:44 PM
Subject: DBI:mysql error message
> Hey ever
Hey everybody,
This is my perl DBI script:
#!/usr/bin/perl -w
use DBI;
$username = "myusername" ;
$mypassword="mypassword" ;
my $dbh = DBI->connect("DBI:mysql:table1:localhost", "$username",
"$mypassword");
die "Can't open DB\n" if (!defined $dbh);
my $sth = $dbh->prepare("SELECT * FROM abc
