MySQL Forums
Forum List  »  Triggers

mySQL trigger on record that creates a new table
Posted by: Michael Fayol
Date: June 12, 2020 10:59AM

It's been quite a few years since I have done DB work. MySql backend (thru workbench) and I am using MS Access as a frontend.

I have a base table that I am multilinking (basically a name column, and # of months column). Through a form, the table is updated (a record added) and I want that new record to trigger an event that creates a table and that table is named based on what the user inputted in the form/record, and create columns for the months - just named month1, month2, etc.

Any thoughts on how to do this? Any thoughts on a better way to do this? lol

I am also looking for recommended reads/videos to get me back up to speed.
Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
mySQL trigger on record that creates a new table
303
June 12, 2020 10:59AM


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.