Set MySQL Auto Increment Manually
ALTER TABLE table_name AUTO_INCREMENT = 100000
Related posts:
- MySQL: Remove Duplicate Entries
- Optimize MySQL Performance With MySQLTuner
- MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
- MySQL Concatenate: Adding String At The End Of Field Data
- Mysql Data Import
- Optimize MySQL for Low Memory Use
- Howto: How to Reset the MySQL Root Password
- MySQL Optimization and Performance Tips
- MySQL Performance Monitoring and Optimization Tools
- Compressing mysqldump output – mysql, gzip, bzip2 and LZMA (7z)
Popular Related Items »
Incoming search terms
- mysql set auto_increment
- mysql set autoincrement
- mysql set auto increment
- set autoincrement mysql
- set auto increment mysql
- set auto_increment mysql
- SET AUTOINCREMENT
- how to set auto increment in mysql
- mysql auto increment
- SET AUTO_INCREMENT
- set auto increment
- mysql autoincrement set
- mysql auto increment set
- mysql auto_increment set
- mysql set increment
- mysql change auto_increment
- set auto increment in mysql
- auto increment mysql
- mysql set autoincrement value
- set increment mysql
- how to set autoincrement in mysql
- mysql alter table auto increment
- setting auto increment mysql
- mysql set auto_increment value
- mysql set auto increment value
- mysql autoincrement change
- auto_increment mysql
- mysql set auto increment number
- mysql change autoincrement
- set autoincrement in mysql
- mysql disable auto increment
- MYSQL SET AUTO-INCREMENT
- mysql auto increment by 2
- mysql setting auto increment
- change auto increment mysql
- mysql change AUTO_INCREMENT number
- mysql change auto increment
- mysql set auto increment id
- mysql auto increment offset
- mysql change increment
- mysql disable auto_increment
- setting auto_increment mysql
- set mysql autoincrement
- set mysql auto increment
- auto_increment set
Søren Jansen said,
September 2, 2006 @ 20:18
Great point
Mikkel Andersen said,
April 25, 2007 @ 6:28
Hello,
Thank you for this great tip.
It s always great to be able set the offset for auto generated ids in the database
wqewqe said,
December 24, 2007 @ 2:01
ALTER TABLE tbl_name AUTO_INCREMENT = xxx
Kiran said,
June 25, 2009 @ 17:12
Hmmm, the problem lies in setting it automatically :
ALTER TABLE tbl_name AUTO_INCREMENT = (Select MAX(Contactid) from tablename);
I need it for automation scripts. Hope this bug gets resolved..
Remco said,
July 20, 2009 @ 12:29
Appearantly if you set auto_increment to 1 mysql sets it to max(id) automagically.
Quite annoying if you want to raise certain errors for testing.