How to insert multiple rows in a child table

1

Hi, just wondering on the best way to create new records in a child table.
I have 2 tables in MySQL, SurveyPromptTemplates, consisting of a dozen rows (in my test DB) and table SurveyAnswers, that is empty.

If I could type SQL freely, i would enter (for example)

Insert into SurveyAnswers (select * from SurveyPromptTemplates )

Note: all column names in the 2 tables are the same so this would result in all dozen rows being copied from SurveyPromptTemplates into SurveyAnswers .

Is it possible to create something like this in wappler (any examples of how the server component is set up) or do I have to resort to creating a stored procedure in MySQL and can a stored procedure be called from Wappler?

My Server Side component so far is…

image

If this can be done in wappler then I suspect that the last step needs to be a repeat of some sort. Any thoughts?

2

You can use a database custom query action and enter any sql command you’d like, including calling a stored procedure.

Or yes, spin through records with a repeat and do the inserts individually.