Author Topic: How to change the next value of an auto_increment field  (Read 3404 times)

Offline admin

  • Administrator
  • Sr. Member
  • *****
  • Posts: 296
    • View Profile
How to change the next value of an auto_increment field
« on: June 20, 2010, 06:14:13 AM »
Question:

I have a table where the primary key is an auto increment field. I just deleted the last 2 rows and when the next record will be created it will use the next higher number but I'd like to subtract 2 from the auto_increment value. How can I do this?


Answer:

Use the ALTER TABLE statement as shown below:

Code: [Select]
   
 /* this makes the next record have 911 in the auto increment field: */
alter table MYTABLE auto_increment=911;