Scenario: 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.
As a prerequisite to this Job, follow the steps described below to create the relevant
tables using an engine such as innodb:
In a command line editor, connect to your Mysql server.
Once connected to the relevant database, type in the following command to
create the parent table:1create table f1090_mum(id int not null auto_increment, name varchar(10), primary key(id)) engine=innodb;
Then create the second table:1create table f1090_baby (id_baby int not null, years int) engine=innodb;
, the Job requires seven components including
tMysqlConnection and tMysqlCommit.