Link to home
Create AccountLog in
Avatar of rgb192
rgb192Flag for United States of America

asked on

missing rows of auto_increment column

create table schedule(
schedule_id int auto_increment primary key,
row int,
col int,
event_id int,
checked int
)

alter table schedule add unique index (row,col,event_id);

select * from schedule

 
  INSERT INTO schedule (row,col,event_id,checked) VALUES (1,2,4,1)
  ON DUPLICATE KEY UPDATE checked=1


why are some schedule_id missing when I do inserts
ASKER CERTIFIED SOLUTION
Avatar of johanntagle
johanntagle
Flag of Philippines image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of rgb192

ASKER

thanks all about auto_increment