MySQL Forums
Forum List  »  Newbie

Re: Using date and increment as row id
Posted by: Peter Brawley
Date: June 10, 2021 11:30AM

Compound-value columns run afoul of the basic atomicity rule of relational databases. A compound key like (year.month.index) is best implemented as an index defined with year, month and incrementing index columns. Elementary SQL easily displays the compound value wherever required.

You asked this question a week ago and evidently didn't like the answer, so please tell us what problem you think you are solving by combining such values in one column.

Options: ReplyQuote

Written By
Re: Using date and increment as row id
June 10, 2021 11:30AM

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.