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: 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
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
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