Reading & Writing to MySQL

Question

Hi,

I am reading data for MySQL and would like to prevent migrating the same data each time i run the workbence (it will be running as a scheduled task). To do this I have created an 'export' field in MySQL, with a default value of '0'. The workbench has a tester at the start, that will only allow a value of '0' through, and at the end of the workflow, I want to change all '0' values to '1'. I get an error when trying to run this writing back to the MySQL database.

My question is this, normally I would use the database updater transformer, but this will not write to MySQL, so how would I update the MySQL database and change these values.

Many thanks in advance.

Page 1 / 1

Hi,

What kind of error are you getting from MySQL?

Also, have you tried using an SQLExecutor?

David

Thanks David, I was trying to use the standard writer wich failed, the SQLExecutor worked a treat.

Many thanks

Reply

david_r · Accepted Answer

Hi,What kind of error are you getting from MySQL?Also, have you tried using an SQLExecutor?David

dilip · Answer

Thanks David, I was trying to use the standard writer wich failed, the SQLExecutor worked a treat.Many thanks

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded