Error Code: 1248. Every derived table must have its own alias 0.0042 sec
1.错误分析昨天把代码上到生产上时报错了,原因是生产环境的mysql版本是5.7,distinct和order by不能一起用,然后想着在外面再套一层查询,然后进行order by,然后就报了1248这个错误。2.错误解决出现这个问题的原因就是子表没有加别名3.示例3.1 错误sql这种sql会报错select * from (select * from user);正确sql,添加别名select * from (select * from user) as tmp;..