- 1248 - Every derived table must
- mysql错误Every derived table must
- Error Code: 1248. Every derived
- 别名的一个问题:Every derived table must
- MySQL8.0新特性CTE(Common Table Expr
- every thing has a beginning
- Why the first article has no pre
- Item 11: Always override hashCod
- 英文圆体字练习 2018.08.27
- [Summary] [Toastmaster CC3] Get
1248 - Every derived table must have its own alias (MYSQL错误)
翻译:每个派生出来的表都必须有一个自己的别名
Mysql语句是:select count(*) from (select * from dede_spacemoney group by sid) ;
当执行的时候抛出了这个异常,原来在用进行嵌套查询的时候,子查询(select * from dede_spacemoney group by sid)执行出来的的结果是需要作为一个派生表来给上一级进行查询(select count(*) from)使用的,所以子查询的结果必须要有一个别名,这里“别名”的使用可以理解为是用作临时变量记录子查询的结果
把MySQL语句改成:select count(*) from (select * from list where name="xiao") as t;
问题解决!
————————————————
版权声明:本文为CSDN博主「爱佳男士」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/cao478208248/article/details/28122113
网友评论