Re: duplicate key error on autoincrement field while inserting

2001-04-24 Thread Dan Shapella
oincrement problems at virtually the same time. And this is the only app running on this system. Why did MySql decide these 2 keys already exist when in fact they don't? >From: Gerald Clark <[EMAIL PROTECTED]> >To: Dan Shapella <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED]

duplicate key error on autoincrement field while inserting

2001-04-24 Thread Dan Shapella
I have a weird one here. I have an application that inserts records into one of 2 different tables. The other day, an insert attempt on one of the tables failed with a duplicate key error on key 1, an autoincrement field. About a minute later, an insert attempt on the other table failed simi