mysql出现错误“ Every derived table must have its own alias”
来源:互联网 发布:2017有哪些网络剧上映 编辑:程序博客网 时间:2024/06/06 01:39
mysql出现错误“ Every derived table must have its own alias”
(2011-10-09 13:09:25)宋体
别名
嵌套查询
派生表
进行
杂谈
分类: 计算机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”
- 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”
- 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”
- Mac下android_sdk配置环境变量
- ubuntu 编译opencv2.4.10
- Sqlite数据库中的数据类型及字符串比较
- JAVA中GBK转UTF-8
- CopyOnWriteArrayList操作java.lang.UnsupportedOperationException
- mysql出现错误“ Every derived table must have its own alias”
- NSUserDefaults
- Android TextView以及子类
- webstrom的字体改变
- 海思HI3516A开发板顺利上线
- 如何诊断和解决CPU高度消耗(100%)的数据库问题
- Python中的模块与包
- 夜
- 传奇绘图更换笔记:ZenGL 一些需要注意的事情