我将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
原載于:關聯北方