I've had the same issue. The problem, as I saw it, was that I inserted a
negatvie value into the ID field. For some reason, it "rolls" to the
highest possible positive numeric value if a negative number is used in the
ID field.
I made the field unsigned to address this issue in mySQL, but, t
Well it isn't. I created a table with auto_increment, added 25 records,
deleted 5, did an insert, and the next auto number was 21.
>From: Steve Ruby <[EMAIL PROTECTED]>
>To: John Tsangaris <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: auto_increment
>Date: Mon, 26 Feb 2001 15:02:38
How can I do Prepared Statements or Editable Cursors in MySQL? Using only
conact SQL strings is error prone...
I'm not getting any reply in the Java list...
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--