高手帮忙解决下mysql的1248错误
我将oracle项目的数据库转换为mysql,部署之后执行任何SQL语句好象都会出现错误
2007-09-13 09:24:47,015 [org.hibernate.util.JDBCExceptionReporter]-[ERROR] Every derived table must have its own alias
2007-09-13 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
