我将oracle项目的数据库转换为mysql,部署之后执行任何SQL语句好象都会出现错误
09:24:47,015 [org.hibernate.util.JDBCExceptionReporter]-[ERROR] Every derived table must have its own alias
09:24:47,015 [ERROR] org.hibernate.exception.SQLGrammarException: could not execute query
以下是我查找的mysql信息
Error: 1248 SQLSTATE: 42000 (ER_DERIVED_MUST_HAVE_ALIAS)
Message: Every derived table must have its own alias
------解决思路----------------------
Message: Every derived table must have its own alias
很明显了。
每个表必须有自己的别名
------解决思路----------------------
()括号之后加个 AS a
高手帮忙解决下mysql的1248错误,谢谢!