Error in your SQL syntax

Owned by Former user (Deleted)
Last updated: Jan 25, 2023 by Stonebranch (Deactivated)

Problem

When you execute an SQL task that includes multiple SQL commands, the following error message (for example) may display:

INSERT INTO uc_demo (name, value) values ('A', 'F');
INSERT INTO uc_demo (name, value) values ('B', 'S');
INSERT INTO uc_demo (name, value) values ('C', 'F');

Solution

Multiple queries, by default, are disabled for MySQL. To enable multiple queries, append the following string to the Connection URL field in the Database Connections resource definition:

?allowMultiQueries=true

The following example is a URL connection string for a MySQL Database Connection resource definition:

jdbc:mysql://localhost:3306/uc?allowMultiQueries=true