Sky Blueshoes wrote:
> What is the sequel statement to clear an entire table using DBI?
It depends on your database, but typically:
$dbh->do('delete from some_table');
Some databases support TRUNCATE:
$dbh->do('truncate some_table');
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For addit
Sky Blueshoes wrote:
What is the sequel statement to clear an entire table using DBI?
a) you mean "Ess Queue Ell" nor "sequel"
b) it depends on the database your using, but generally it will be a
DELETE FROM table or DROP TABLE table type statement. See your DB
vendor's documentation fro s
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
