This simple recipe shows how to execute database management and table related commands.
Create a new job
The steps to be performed are as follows:
cookbookDBconnection onto the canvas and select the component
" CREATE TABLE `test_mysqlrow` ( `id` int(11) NOT NULL, `data` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) "
testMysqlRowhas been created.
tMysqlRow component is the database equivalent of both
tJavaRow, it can be used within a flow like
tJavaRow or standalone like
That said, the
tMysqlRow component is most commonly ...