Re: Using AlphaNumeric Keys
Posted by:
Cat B
Date: January 29, 2019 04:14PM
Peter Brawley Wrote:
-------------------------------------------------------
> > If I used this design, it would allow me to more
> easily read my ENTITLEMENT table and see the
> relationships.
>
> And it opens your schema to lots of problems so
> it's still poor practice. There are non-trivial
> reasons that bridge tables are the RDBBMS standard
> for such problems. Use Views to create such
> self-explanatory readability.
How well does MySQL do Views? (I think I am using 5.7 on my webserver?)
Are there any big "gotchas" when using Views?
I have to confess that I have never created a View in MySQL, but maybe they are a way for me to "have my cake and eat it too"?
Subject
Written By
Posted
Re: Using AlphaNumeric Keys
January 29, 2019 04:14PM
Sorry, you can't reply to this topic. It has been closed.
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.