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