MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

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!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
mySQL trigger on record that creates a new table
818
Michael Fayol
June 12, 2020 10:59AM
Re: mySQL trigger on record that creates a new table
383
Peter Brawley
June 12, 2020 11:26AM
Re: mySQL trigger on record that creates a new table
402
Michael Fayol
June 12, 2020 01:09PM
Re: mySQL trigger on record that creates a new table
359
Peter Brawley
June 12, 2020 01:18PM
Re: mySQL trigger on record that creates a new table
353
Michael Fayol
June 12, 2020 01:35PM
Re: mySQL trigger on record that creates a new table
322
Peter Brawley
June 12, 2020 02:49PM


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.