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
492
June 12, 2020 01:18PM


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.