MySQL Forums
Forum List  »  Newbie

Maybe There is a Problem about auto_increment_increment
Posted by: five small
Date: February 18, 2021 06:46AM

I'm Very Sorry To interrupt~~Code First,Maybe it's a BUG...

create table test(id int not null primary key auto_increment unique);
Query OK, 0 rows affected (0.04 sec)

set @@auto_increment_offset=10;
set @@auto_increment_increment=3;

insert into test values(null),(null),(null),(null),(null);

select * from test;
+----+
| id |
+----+
| 3 |
| 6 |
| 9 |
| 10 |
| 13 |
+----+

I Think There must be Wrong about number 9 and number 10, And What's Worse ,SomeTimes The 3rd number is 10 like following,I Swear I use THe Same Santences,But I get different results.
+----+
| id |
+----+
| 3 |
| 6 |
| 10 |
| 13 |
| 16 |
+----+

Options: ReplyQuote


Subject
Written By
Posted
Maybe There is a Problem about auto_increment_increment
February 18, 2021 06:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.