Cascading Insert via a Trigger

[Steve Johnson]

I need to insert records into a child table within a trigger. When a new Survey record is added, I want the Question Table copied to the Answer Table to maintain the answers.

SurveyTable
ID

AnswerTable
ID
SurveyID
QuestionID
Answer

QuestionTable
ID
Question

I’m not sure of the syntax, I’m new to MySQL. I have been doing this with Firebird/Interbase for years using the “FOR SELECT” syntax.

Thanks,
Steve