RE: [PHP] SQL statement for clearing a table
| From: | Chadwick, Russell | Date: | Fri, 22 Jun 2001 22:19:53 +0000 |
| Subject: | RE: [PHP] SQL statement for clearing a table | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-54939@lists.php.net to get a copy of this message | ||
No one has yet mentioned TRUNCATE TABLE x which is a lot faster on large
tables because even DELETE FROM evaluates each row where TRUNCATE just
clears the data. - Russ
---
Toolshed Computer Productions - Professional PHP Hosting
Hosting - Dedicated Servers - Design - Programming
http://www.toolshed51.com
-----Original Message-----
From: Wilbert Enserink [mailto:wilbert@pdd.nl]
Sent: Friday, June 22, 2001 5:18 AM
To: php-general@lists.php.net
Subject: [PHP] SQL statement for clearing a table
Hi all,
anybody knows the mysql statement for clearing the contents of a table and
lieving the table itself intact?
Wilbert
-------------------------
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
http://www.pdd.nl
info@pdd.nl
-------------------------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net