Auto increment works with step 2
Posted: Mon 22 Aug 2016 21:37
Hello!
I use dbFOrge for MySQL 7.1.13. I have some table in my database.
For example:
If i try add the first record to this table, field "ID" sets value 1, but if i try add one more record, field "ID" sets value 3 (not 2). And any new records will increment with step 2: 1, 3, 5, 7, 9, 11...
What am i doing wrong?
I use dbFOrge for MySQL 7.1.13. I have some table in my database.
For example:
Code: Select all
CREATE TABLE Certification.Applicant (
ID int(11) NOT NULL AUTO_INCREMENT,
ApplicantName varchar(255) NOT NULL COMMENT 'Заявитель',
CreateUserID int(11) NOT NULL COMMENT 'Пользователь, создавший запись',
CreateDateTime datetime NOT NULL COMMENT 'Дата создания записи',
LastEditUserID int(11) DEFAULT NULL COMMENT 'Последний редактировавший пользователь',
LastEditDateTime datetime DEFAULT NULL COMMENT 'Дата и время последнего редактирования',
Deleted tinyint(1) NOT NULL COMMENT 'Признак удаления записи',
PRIMARY KEY (ID),
UNIQUE INDEX ApplicantName (ApplicantName)
)
ENGINE = MYISAM
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = 'Заявители';What am i doing wrong?