MySQL Forums
Forum List  »  Newbie

Re: Populating columns with sequential values
Posted by: Phillip Ward
Date: January 31, 2023 08:21AM

Why do you feel the need to do this?

If "order by order1" gets you records in the sequence you want, then why go to all the trouble of "hard-coding" that sequence into values held in order2?

If this is to store a user-specified sequence, then I'd recommend generating those sequence values the client Application and storing them along with everything else in the records.

Regards, Phill W.

Options: ReplyQuote

Written By
Re: Populating columns with sequential values
January 31, 2023 08:21AM

Sorry, only registered users may post in this forum.

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.