DB

[mysql] Error Code: 1248. Every derived table must have its own alias

호밀밭의밀수꾼 2019. 1. 3. 16:36

각 서브쿼리마다 alias 를 달지 않아 생기는 에러입니다.



[에러]


select * from (select * from table);


 


[수정]


select * from (select * from table) t ;