... User-B inserts his new data with INSERT INTO table (ID,FLD1,FLD2) VALUES ( 3, 'DD','DDDD' ) User-B's insertion will be successful. But User-A's insertion fails with an error. Note: The problem remains the same even if we read auto_increment value from the table_schema. ...