Skip to main content

Inserting data in mother/daughter tables

The following Job is dedicated to advanced database users, who want to carry out multiple table insertions using a parent table id to feed a child table.

For more technologies supported by Talend, see Talend components.

As a prerequisite to this Job, follow the steps described below to create the relevant tables using an engine such as innodb:

  1. In a command line editor, connect to your Mysql server.

  2. Once connected to the relevant database, type in the following command to create the parent table:

    create table f1090_mum(id int not null auto_increment, name varchar(10), primary key(id)) engine=innodb;
  3. Then create the second table:

    create table f1090_baby (id_baby int not null, years int) engine=innodb;

Back in Talend Studio , the Job requires seven components including tMysqlConnection and tMysqlCommit.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!