O'Reilly logo

Talend Open Studio Cookbook by Rick Barton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Database and table management

This simple recipe shows how to execute database management and table related commands.

Getting ready

Create a new job jo_cook_ch07_0100_tableManagement.

How to do it…

The steps to be performed are as follows:

  1. Drag the cookbookDB connection onto the canvas and select the component tMysqlRow.
  2. In the Query area add the following code:
    "
    CREATE TABLE `test_mysqlrow` (
      `id` int(11) NOT NULL,
      `data` varchar(45) DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) 
    "
  3. Run the job and you will see that the table testMysqlRow has been created.

How it works…

The tMysqlRow component is the database equivalent of both tJava and tJavaRow, it can be used within a flow like tJavaRow or standalone like tJava.

That said, the tMysqlRow component is most commonly ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required