Or simply,
Delete from table_name;
Andy
-Original Message-
From: Sommerfield, Thomas P <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; MySQL Mailing List <[EMAIL PROTECTED]>
Sent: Tue Jul 20 22:16:14 2004
Subject: RE: Removing Entries From a MySQL Tab
Hello;
DELETE FROM table_name WHERE 1 ;
This command will remove all rows from the table.
For more information, see:
http://dev.mysql.com/doc/mysql/en/DELETE.html
Make sure you have a backup if you think you may need the data in the
future.
-Tom
-Original Message-
From: Michael Mas
Hello,
Michael Mason schrieb am Dienstag, 20. Juli 2004 um 22:46:
> I basically just want to clear a table I use for logon entries. Can anyone
> help with this please.?
http://dev.mysql.com/doc/mysql/en/TRUNCATE.html
http://dev.mysql.com/doc/mysql/en/DELETE.html
HTH,
A.
--
MySQL General
