Hi all,
I have MySQL 3.23.23-beta running, and an interesting problem arose recently:
I have a table called Profiles which has an auto-increment field called Profile_ID (int). I recently needed to add a record with a Profile_ID of -1, and ever since then, the auto-increment doesn't seem to work. It either creates a larger than possible number (2 billion or so), or it gives an error:
Duplicate entry '-1' for key 1
Any ideas? Is it a bug in the software or my program?
Thanx in adv.
-- JOhn
I have MySQL 3.23.23-beta running, and an interesting problem arose recently:
I have a table called Profiles which has an auto-increment field called Profile_ID (int). I recently needed to add a record with a Profile_ID of -1, and ever since then, the auto-increment doesn't seem to work. It either creates a larger than possible number (2 billion or so), or it gives an error:
Duplicate entry '-1' for key 1
Any ideas? Is it a bug in the software or my program?
Thanx in adv.
-- JOhn