[SOLVED] Execute SQL more queries
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!