I have a question about autoincremend id:
If I have an autoincrement id set on my first column field of my table and I have the
And then I make a INSERT INTO foobar VALUES(''); , the next field would be automatically
Is there a possibility to take a free ID to not use too high IDs for nothing?
I would like to take the ID 2 and not 4, because ID 2 is free.
My problem is that my system which uses the ID numbers in applications which uses them
as signed int or unsigned int,
so I will soon have a problem, because I insert (and delete some times) many entries in my
but not more than the highest value of an signed integer.
Attachment: [application/pgp-signature] Digital signature signature.asc