sql语句问题为什么在数据库中文可以执行但在mybatis中就不行求大佬指点 万分感谢

这可以执行
但在mybatis中PREPARE texts FROM @a就出现异常错误了
异常是
SQL: SET @a=CONCAT('SELECT a.accout_,a.name,a.birthday_,b.name_j FROM users a,role b,users_role c WHERE a.id=c.user_id AND b.id_j=c.role LIMIT ',(1-1)*3,",",3,'') PREPARE texts FROM @a EXECUTE texts

Cause: 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 'PREPARE texts FROM @a

EXECUTE texts' at line 2
; bad SQL grammar []; nested exception is 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 'PREPARE texts FROM @a
EXECUTE texts' at line 2

mybatis里的sql语句写法跟数据库里的sql写法并不完全一致，所以要先去查找对应的mybatis

一位大佬的指点成功解决， 贴出解决方法解救遇到相同类型的菜鸟，这个写法我的学习资料都没有说过，学海无涯苦作舟