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:
$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 sta
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 o
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
lievin
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
>
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 PRO
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
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 t
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
9 matches
Mail list logo
