...

Reseting data in tables using auto_increment

skinme!
08-04-2002, 02:15 AM
Hi,

I have a table which has a column, id, which uses auto_increment. Is there a quick way to flush all data from the table, reseting auto_increment to start again at 1?

What I have been doing so far is drop the table then re-creating it, which is very tedious. Am I missing something here?

Thanks



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum