Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
08-04-2002, 02:15 AM #1
- Join Date
- Jul 2002
- London, UK
- Thanked 0 Times in 0 Posts
Reseting data in tables using auto_increment
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?