Usually you'll want to do something like this:
my $sth = $dbh->prepare("DELETE FROM TABLE1");
$sth->execute();
Is that what you meant? It will delete all records.
-----Original Message-----
From: Sky Blueshoes [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 09, 2006 4:46 PM
To: beginners@perl.org
Subject: Clearing tables...
What is the sequel statement to clear an entire table using DBI?
SkyBlueshoes
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
