Power Platform Community Forum Thread Details

I'm using Power automate desktop.

is it possible to put multiple sql query in one run sql command?

like in mysql, i can't put a ";" between the commands.

when i try
USE tongiaya_wp482;
USE tongiaya_ligaya;

then i get

ERROR [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-5.6.41-84.1]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USE tongiaya_ligaya' at line 2: Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: Fel i SQL-instruktionen ERROR [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-5.6.41-84.1]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USE tongiaya_ligaya' at line 2 ---> System.Data.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-5.6.41-84.1]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USE tongiaya_ligaya' at line 2

Categories:

Power Automate Desktop