天天看点

mysql-1248_解决下mysql的1248异常

我将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

原载于:联动北方