RE: Duplicate entry '0' for key 1

2001-05-13 Thread Tyrone Mills
Thanks Cal, Anything in particular in the config I should be looking for? Thanks, Tyrone -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 9:40 AM To: Mysql@Lists. Mysql. Com Subject: RE: Duplicate entry '0' for key 1 Other than the f

RE: Duplicate entry '0' for key 1

2001-05-13 Thread Cal Evans
levans.com -Original Message- From: Tyrone Mills [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 11:24 AM To: Mysql@Lists. Mysql. Com Subject: RE: Duplicate entry '0' for key 1 Here's the CREATE TABLE syntax I used on the latest table to do this to me... CREATE TABLE sit

RE: Duplicate entry '0' for key 1

2001-05-13 Thread Tyrone Mills
[mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 9:06 AM To: Tyrone Mills; Mysql@Lists. Mysql. Com Subject: RE: Duplicate entry '0' for key 1 What's your datatype? Cal http://www.calevans.com -Original Message- From: Tyrone Mills [mailto:[EMAIL PROTECTED]] Sent: Su

RE: Duplicate entry '0' for key 1

2001-05-13 Thread Cal Evans
What's your datatype? Cal http://www.calevans.com -Original Message- From: Tyrone Mills [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 10:59 AM To: Mysql@Lists. Mysql. Com Subject: Duplicate entry '0' for key 1 Importance: High Why is it that a seemingly r

Duplicate entry '0' for key 1

2001-05-13 Thread Tyrone Mills
Why is it that a seemingly random intervals anyone of the tables in my database will decide to start auto incrementing back to 0? More importantly how to I stop this? I've tried not inserting a value for the auto increment column, I've tried inserting NULL, or '', nothing works!!