mysql SQL在Java中语法无效，但在Workbench中无效

Question

为什么这条语句在workbench中运行良好，而在Java中运行不好

SET @sqlstmt := IF( @exist <= 0, 'select ''INFO: Key does not exist.''', 'ALTER TABLE `SOMETABLE` DROP FOREIGN KEY `SOMEKEY`');

在Java中，我得到

MySQLSyntaxErrorException: 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 'SET @sqlstmt := IF( @exist <= 0, 'select ''INFO: Key does not exist.''', 'ALTER ' at line 1

Answer 1

事实证明，执行了多条语句（用分号分隔）。在JDBCMySQL中，您需要allowMultiQueries=true