您可以简单地将以下jdbc url参数添加到您的连接字符串中

http：// dev。 mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html#allowMultiQueries

从文档： p>

允许在一个语句
（true / false）中使用';'分隔
多个查询，默认为'false'

例如：

  Sql.newInstance（jdbc：mysql：// localhost？allowMultiQueries = true，usre，pass，com.mysql.jdbc.Driver）
 

I'm having problems running multiple SQL statements in one activaction from Groovy.

sql = Sql.newInstance("jdbc:mysql://localhost/", "usre", "pass", "com.mysql.jdbc.Driver")
sql.execute("USE foo; "); // this works
sql.execute("USE foo; USE foo;"); // this fails miserably

The error I'm getting is "You have an error in your SQL syntax". What gives?

You can simply augment the following jdbc url parameter to your connection string

http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html#allowMultiQueries

From the docs:

Allow the use of ';' to delimit multiple queries during one statement (true/false), defaults to 'false'

For example:

Sql.newInstance("jdbc:mysql://localhost?allowMultiQueries=true", "usre", "pass", "com.mysql.jdbc.Driver")