无论里面的代码如何，mysql事务都会失败

Question

我正在尝试在 mySQL 中编写事务，但无论我在标签之间放置什么，都会出现错误。

start transaction;
set @email = "FOO";
PRINT @email;
commit; 

该 block 总是会产生错误:

SQL Error [1064] [42000]: 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 @email_name = "FOO";
PRINT @email_name;
commit' at line 2
com.mysql.jdbc.exceptions.jdbc4.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 @email_name = "FOO";
PRINT @email_name;
commit' at line 2

无论事务中放置什么代码，这种行为都会发生，如果有注释，这种行为甚至会持续存在。

Answer 1

没有 PRINT，请使用 SELECT 代替。