PDA

View Full Version : Reseting data in tables using auto_increment


skinme!
08-04-2002, 03: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