MySQL Forums
Forum List  »  General

Re: Dynamic assignment of month based on current date
Posted by: Peter Brawley
Date: April 11, 2022 08:51PM

Thank you for the clarifications.

It's a bizarre database design, creating otherwise unnecessary query difficulties for users of the system and for query designers. The fundamental error is encoding data as column names, which is most always a design mistake. SQL is an incomplete computer language---it's not designed for treating table column names as variables on this scale.

All those monthly fiscal year data tables you propose to create could be replaced by one efficiently queryable table. What problem was this Rube Goldberg design meant to address?

If for some reason your organisation has committed itself to this design, I'm afraid you may pay dearly to have it written, maintained and supported.

Options: ReplyQuote


Subject
Written By
Posted
Re: Dynamic assignment of month based on current date
April 11, 2022 08:51PM


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.