Some RDBMS allow you set a 'seed' value for auto-incrementing columns. I
haven't looked at this in awhile, but I know of a couple of work-arounds:
- Set the first record in your INSERT to an explicit value (4711, etc.),
then put NULLs in subsequent rows.
- Insert a bogus record with a number one
At 11:03 PM +0200 7/17/01, Alexander Skwar wrote:
>So sprach »Warren van der Merwe« am 2001-07-17 um 22:31:02 +0200 :
>> in my plain language there it is, but the pro's may give a more detailed
>> approach.
>
>Yeah, that's sorta how I understand it as well. Also auto_increments
>BREAK when you
So sprach »Warren van der Merwe« am 2001-07-17 um 22:31:02 +0200 :
> in my plain language there it is, but the pro's may give a more detailed
> approach.
Yeah, that's sorta how I understand it as well. Also auto_increments
BREAK when you manually insert a row and set the column with the
auto_inc
Hi
I am no pro with Mysql, but had similar results when first starting out. My
understanding is that the Auto Increment value is held in a file other than
the actual data file, so when it uses the auto-increment it is not reading
the last value from the actual DB and then adding one, but rather l
