MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Bigint unsigned value out of range
Posted by: Phillip Ward
Date: January 22, 2024 07:57AM

Quote

I want to list the ID values and the next existing ID values and their difference (alias delta).

Sorry, but I have to ask ... Why?

Serial values are intended to be unique, but that's about all you should expect of them.
The actual, numeric, value assigned to any given record should not matter to you one jot.

You absolutely cannot expect them to be consecutive (i.e. without "gaps") because that's just not how they work. If you really, really, really believe you need this (and. IMHO, you never should), then you'll have to implement it yourself.

Regards, Phill W.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Bigint unsigned value out of range
András Keszthelyi
January 21, 2024 02:58AM
Re: Bigint unsigned value out of range
Phillip Ward
January 22, 2024 07:57AM
Re: Bigint unsigned value out of range
András Keszthelyi
January 24, 2024 10:41AM


Sorry, only registered users may post in this forum.
Click here to login

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.