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
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
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 Table
Hello;
DELETE FROM