Problem with the MySQL Connector

[stefan2]

Hello everyone

I have a beginner’s question
I’m using the MySQL Connector to write two values to a database. I’ve connected the database and can map the table. That’s good enough.

The table looks like this in MySQL:

I do the following in the MySQL Connector:

But now I get the following error message:

Unknown column ‘output’ in ‘SET’
sql: UPDATE intrest_rates SET output = intrest_rate_10 = ‘1.66%’, company_name = ‘1’ WHERE company_name = NULL, code: ER_BAD_FIELD_ERROR

Isn’t the query somehow wrong? Why is “output” in the query and why is company_name = NULL?

I’m kind of confused right now.

Thank you for your support.

Stefan

[jabbson]

What you want to do is add a Set Node after your Information extractor and set the variables one by one like this

So all together it will look something like this:

[stefan2]

Oh my God, it works!
Thanks. @jabbson If you were a woman, I’d marry you

[jabbson]

Haha, no problem, at all, glad I was able to help.