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 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 the table just not
The data in it. I'm running out of space.
Thank you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org