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

Quote:

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

Quote:

Originally Posted by 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

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.

Resetting AUTO_INCREMENT after deleting records

re: Resetting AUTO_INCREMENT after deleting records

re: Resetting AUTO_INCREMENT after deleting records

re: Resetting AUTO_INCREMENT after deleting records

/bytes/development

/bytes/it

/bytes/about