foreign key insert to a different table in mysql

Anonymous — Mon, 06 Jun 2016 22:40:31 GMT

I have a job where the job reads data from excel sheet and insets data to a mysql table. Let's say that it inserted 25 rows in Table "A". In table "A", I have one column as 'run id' which inserts a unique uuid for every job run. So, for all the 25 rows it inserted in a single run the 'run id' column has the same uuid value. I wanted to insert a single row into another table- "Table B" where "run id" column acts as foreign key between "Table A" and "Table B". How do I insert a single row in "Table B" for every job run, while inserting 25 rows in "Table A"?

Re: foreign key insert to a different table in mysql

Anonymous — Fri, 17 Jun 2016 07:24:41 GMT

Hi,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina

topic Re: foreign key insert to a different table in mysql in Talend Studio

foreign key insert to a different table in mysql

Re: foreign key insert to a different table in mysql