我将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
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
每个表必须有自己的别名
select * from ( select userdo0_.userOID as userOID15_, userdo0_.userName as userName15_....where userdo0_.userLoginName='admin' and userdo0_.userPasswrod='admin' ) where rownum <= ?分析了应该是子查询的问题,该怎么改?