By default the driver of MySQL Connector / JDBC does not allow multiple queries within the cfquery, just for security reasons.

To work is only add a parameter in the connection, eg.:

jdbc:mysql://my-domain:3306/databasename?allowMultiQueries=true

Greetings,
Anderson Straube