Jyotir Bhandari
Reputation: 109
set auto increment size to 200001 and offset 10000
I am trying to set auto_increment_increment = 200001 and auto_increment_offset = 10000
in my.cnf, but when i do show variable like '%auto%' it gives maximum increment value as 65535.
Then, I created a table with auto increment value as 200001, and inserted null value. When I do select * from table; it gives inappropriate result.
How can I set auto increment values to more 65535 and how can I receive correct results if i insert any values in table.
Upvotes: 1
Views: 1121
Answers (1)
Related Questions
- Mysql - how to set auto-increment to start from zero
- How do I change the Auto Increment counter in MySQL?
- MySQL - Auto_increment by 10
- How to add auto increment column in existing table in mysql which starts from 1000 and increment by 1
- Setting Auto_Increment to start from 1000 when creating table
- How to auto-increment start with 500 index not 1 in mysql
- Permanently setting auto_increment_offset in MySQL
- How do I set auto increment starting at 5000
- MySQL auto increment
- How can I set autoincrement format to 0001 in MySQL?