>-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
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
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 need. What is the best way to accomplish this?
If I simply drop the table what can I do prior to dropping the table to ensure
I can recreate the table right after I drop it? I still need t
