DELETE FROM tablename
or
TRUNCATE TABLE tablename
lenar.
Wilbert Enserink [EMAIL PROTECTED] wrote in message
001101c0fb15$5daa49e0$[EMAIL PROTECTED]">news:001101c0fb15$5daa49e0$[EMAIL PROTECTED]...
Hi all,
anybody knows the mysql statement for clearing the contents of a table and
DELETE FROM table_name;
adamw
- Original Message -
From: Wilbert Enserink [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 22, 2001 1:17 PM
Subject: [PHP] SQL statement for clearing a table
Hi all,
anybody knows the mysql statement for clearing the contents of a table and
try
delete from table;
Julia
Quoting Wilbert Enserink ([EMAIL PROTECTED]):
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
This SQL statement:
DELETE FROM myTable;
That should work... pretty much, unless you give a WHERE statement, it will
do whatever you want (UPDATE, SELECT, DELETE, etc) to every record in the
table.
--Jason
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
if you have a numbered primary key,
delete from table where primary_key 0 ?
(to be handled with care)
py
- Original Message -
From: Wilbert Enserink [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 22, 2001 1:17 PM
Subject: [PHP] SQL statement for clearing a table
Hi
delete from tablename
-Original Message-
From: Wilbert Enserink [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 22, 2001 07:18
To: [EMAIL PROTECTED]
Subject: [PHP] SQL statement for clearing a table
Hi all,
anybody knows the mysql statement for clearing the contents of a table and
isn't it,
DELETE FROM tablename;
q.
-Original Message-
From: Wilbert Enserink [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 22, 2001 6:18 AM
To: [EMAIL PROTECTED]
Subject: [PHP] SQL statement for clearing a table
Hi all,
anybody knows the mysql statement for clearing the contents
$query = delete * from table;
table is empty
mailto:[EMAIL PROTECTED]
-Original Message-
From: Wilbert Enserink [mailto:[EMAIL PROTECTED]]
Sent: Freitag, 22. Juni 2001 14:18
To: [EMAIL PROTECTED]
Subject: [PHP] SQL statement for clearing a table
Hi all,
anybody knows the mysql
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
9 matches
Mail list logo