>-Original Message-
>From: Jones, Keven [mailto:keven.jo...@ncr.com]
>Sent: Monday, November 09, 2009 11:21 AM
>To: mysql@lists.mysql.com
>Subject: Best way to purge a table
>
>Hi,
>
>I need to get rid of all data in one table of my database. The table just has
>old
>Data that I no longer n
Just truncate the table, this will get rid of data whilst preserving the
table structure.
eg: truncate tablename;
regards
John
On Mon, 2009-11-09 at 11:20 -0500, Jones, Keven wrote:
> Hi,
>
> I need to get rid of all data in one table of my database. The table just has
> old
> Data that I no
If DELETE FROM [table_name] is not suitable for your task then try ->
TRUNCATE [table_name] : http://dev.mysql.com/doc/refman/5.0/en/truncate.html
Regards,
Mikhail
Jones, Keven wrote:
Hi,
I need to get rid of all data in one table of my database. The table just has
old
Data that I no longer