- Original Message -
From: "Basil Hussain" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 6:32 PM
Subject: RE: Table gets wiped out!
> Hi,
>
> > $sth = $dbh -> prepare (&qu
Hi,
> $sth = $dbh -> prepare ("LOCK TABLES $table WRITE");
> die $dbh->errstr if (not defined ($sth -> execute));
>
> $sth = $dbh -> prepare ("DELETE FROM $table");
> die $dbh->errstr if (not defined ($sth -> execute));
>
> This truncated the table. Then I filled the table anew, an
Still need help with this, guys. :) I read that was a problem with the list
being over some limit (?). So, in case you did not receive this, I hereby
resent it. Otherwise, I am sorry for posting it twice.
Thanks,
- Mark
Ok, rebuillding a table, I did (in Per
Ok, rebuillding a table, I did (in Perl):
$sth = $dbh -> prepare ("LOCK TABLES $table WRITE");
die $dbh->errstr if (not defined ($sth -> execute));
$sth = $dbh -> prepare ("DELETE FROM $table");
die $dbh->errstr if (not defined ($sth -> execute));
This truncated the table. Then I
