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 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/[email protected]
