InterBase (29)
MS-SQL (5)
mysql (37)
Oracle (1)
Exchange Links
About this site
| |
 |
How to change the next value of an auto_increment field
This article has not been rated yet. After reading, feel free to leave comments and rate it.
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: |  | |
/* this makes the next record have 911 in the auto increment field: */
alter table MYTABLE auto_increment=911;
| ||
 |  |
|
||||||||
Comments: