Mysql碰到“Every derived table must have its own alias”类似错误说明
来源:互联网 发布:临汾直销软件 编辑:程序博客网 时间:2024/06/05 12:51
Every derived table must have its own alias
这句话的意思是说每个派生出来的表都必须有一个自己的别名
一般在多表查询时,会出现此错误。
因为,进行嵌套查询的时候子查询出来的的结果是作为一个派生表来进行上一级的查询的,所以子查询的结果必须要有一个别名
把MySQL语句改成:select count(*) from (select * from ……) as total;
问题就解决了,虽然只加了一个没有任何作用的别名total,但这个别名是必须的
select name1 name, java, jdbc, hibernate,total
结果正确:
+----------+------+------+-----------+-------+
| name
+----------+------+------+-----------+-------+
| wangwu
| lisi
| zhangsan |
+----------+------+------+-----------+-------+
3 rows in set (0.02 sec)
- Mysql碰到“Every derived table must have its own alias”类似错误说明
- MySQL错误:Every derived table must have its own alias
- mysql错误 Every derived table must have its own alias
- Mysql错误:Every derived table must have its own alias
- mysql出现“Every derived table must have its own alias”
- 【mysql】Every derived table must have its own alias
- 5.4mysql Every derived table must have its own alias
- mysql 提示:Every derived table must have its own alias
- mysql出现错误“ Every derived table must have its own alias”
- 1248 - Every derived table must have its own alias (MYSQL错误)
- mysql出现错误“ Every derived table must have its own alias”
- mysql出现错误“ Every derived table must have its own alias”
- mysql出现错误“ Every derived table must have its own alias”
- mysql出现错误“ Every derived table must have its own alias”
- mysql出现错误“ Every derived table must have its own alias”
- mysql出现错误“ Every derived table must have its own alias”
- mysql出现错误 Every derived table must have its own alias
- mysql出现错误“ Every derived table must have its own alias”
- Model Training and Tuning
- vc6.0 中getline需要按两次回车的解决方法
- Codeforces Round #278 (Div. 1) B
- 用java对密码进行MD5加密
- python 装饰器与AOP
- Mysql碰到“Every derived table must have its own alias”类似错误说明
- 互联网协议入门(二)
- 捕捉尝试登陆失败的用户信息
- 《字符串和多维数组》的思维导图
- Reading files in MySQL with file_priv = no
- test
- (30 hackdays day 10) Material design - 可用的Material
- VS2010中,调用SaveFileDialog 工具并结合DEV控件之GridControl导出到Excel
- UITableView整理