The Altair Community and the RapidMiner community is on read-only mode until further notice. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options
[SOLVED] Execute SQL more queries
![CharlieFirpo](https://us.v-cdn.net/6030995/uploads/defaultavatar/nCCNNSPK1YM69.jpg)
![](https://s3.amazonaws.com/rapidminer.community/vanilla-rank-images/contributor-16x16.png )
Dear all!
How can I execute more SQL queries with Execute SQL operator? If I edit query text and I use only one query, it works well. When I try to use two or more queries, I get an SQL syntay error message (Process Failed). The same queries work well when using MySQL Workbench. If I create a query file, the same problem occurs.
My queries:
UPDATE <table> SET <column1>='<value1>';
UPDATE <table> SET <column2>='<value2>';
If I use only the first (or only the second by itself), the query works. If I use two seperate Execute SQL operator, the queries work. Using in one, what the problem is?
Thank you trying to solve this!
How can I execute more SQL queries with Execute SQL operator? If I edit query text and I use only one query, it works well. When I try to use two or more queries, I get an SQL syntay error message (Process Failed). The same queries work well when using MySQL Workbench. If I create a query file, the same problem occurs.
My queries:
UPDATE <table> SET <column1>='<value1>';
UPDATE <table> SET <column2>='<value2>';
If I use only the first (or only the second by itself), the query works. If I use two seperate Execute SQL operator, the queries work. Using in one, what the problem is?
Thank you trying to solve this!
0
Answers
Best regards,
Marius
Roland
1) Using a query file, the same problem occures.
2) I have different WHERE conditions as well to my queries, so I think the Update Database operator is not good for me. At least I didn't find anything how to set conditions to modify an attribute with Update Database.
Now that I know it is a known problem, so not occures only in my case, I have the solution.
So as I see, Execute SQL operator works well if there is only one query (and not two or more). So I tried to pack my queries in one using CASE WHEN... THEN... ELSE.
And it worked!
Thank you again!!!