MySQL Forums
Forum List  »  Newbie

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"?

Options: ReplyQuote


Subject
Written By
Posted
January 28, 2019 11:55AM
January 28, 2019 01:40PM
January 28, 2019 02:01PM
January 29, 2019 06:20AM
January 29, 2019 03:04PM
January 29, 2019 03:38PM
Re: Using AlphaNumeric Keys
January 29, 2019 04:14PM
January 29, 2019 07:55PM
January 29, 2019 08:02PM
January 30, 2019 11:10AM
January 30, 2019 11:21AM
January 30, 2019 02:41PM
January 31, 2019 07:15AM
January 31, 2019 12:03PM


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.