Resetting AUTO_INCREMENT after deleting records

[sasheena]

I add a column named deptid in my dept table which is auto incremented.
After adding 3 records I deleted those records and inserted another record.
But it take the deptid as 4. I want it to start from 1.
If U know how to do this pls help.

Best Regards

[code green]

After adding 3 records I deleted those records and inserted another record.
But it take the deptid as 4. I want it to start from 1.

OK but why? This is what auto-number does.
If you want to define the id yourself, don't use auto-number.

[r035198x]

I add a column named deptid in my dept table which is auto incremented.
After adding 3 records I deleted those records and inserted another record.
But it take the deptid as 4. I want it to start from 1.
If U know how to do this pls help.

Best Regards

See the post #2 by Atli in this thread.

[pbmods]

Note that MySQL doesn't care whether the ID of the first record is 1, 6 or 548633. Forcing MySQL to reset the AUTO_INCREMENT value of a table will not improve performance.