Search code examples
mysqlmariadbdbeaver

Multipe Update statements - MariaDB

I use dbeaver to connect to a Mariadb. When I try to run a multi-line update statements, e.g.

update x set warehouse_id='WH02' where soh_id='f0b4d220';
update x set warehouse_id='WHU1' where soh_id='17482705';

I get the error 'Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '...''. If I run the same queries against the database connection created in MySQL workbench, it runs without any problem.

I assume that there is an issue with the usage of ';' but I cannot find a way of running multiple update statements in Mariadb. What am I doing wrong?

Solution

  • To do a batch update in dbeaver, one needs to run script by selecting the queries and running Alt+X.