MySQL Forums
Forum List  »  Triggers

Re: mySQL trigger on record that creates a new table
Posted by: Peter Brawley
Date: June 12, 2020 01:18PM

Still unclear what this setup is actually meant to do, and why a more conventional relational design would not be preferable to creating tables based on user input.

You come from a spreadsheet/pivot background ... are you hoping to implement an entity-attribute-value (EAV) design? If so, please think again ... EAV databases are pigs to query, and those queries perform too like pigs.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mySQL trigger on record that creates a new table
64
June 12, 2020 01:18PM


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.