MySQL Forums
Forum List  »  Triggers

Select with trigger
Posted by: Richard Dunne
Date: November 14, 2017 01:23PM

I'm doing web development using wamp. I want create an after insert trigger which creates a table with at least 4 columns but only three are permanent column names, they don't change. Say I do a select query on a table and get an array with x values, those x values become column names in the trigger table. Do I create the table with the known columns names first, then do an alter for each value in the query result or is there a way of adding the new columns in the same alter query?
Any help appreciated.
If this is the wrong forum please advise.

Options: ReplyQuote


Subject
Views
Written By
Posted
Select with trigger
545
November 14, 2017 01:23PM
215
November 14, 2017 02:10PM


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.