Every derived table must have its own alias（mysql查询报错）

在做mysql分页查询是报错。报错英文的意思是：每个派生表都必须有自己的别名。

查询语句：select * from (select id,hid,name,price,city,xpath,ypath,pic,addr,score,start from hotel where start='5' order by id asc ) limit 0,6

select * from (select id,hid,name,price,city,xpath,ypath,pic,addr,score,start from hotel
 where start='5' order by id asc ) limit 0,6

报错详情：

select * from (select id,hid,name,price,city,xpath,ypath,pic,addr,
score,start from hotel where start='5' order by id asc ) limit 0,6
> 1248 - Every derived table must have its own alias
> 时间: 0.063s

原因是我没有给派生表加一个表名。把sql语句修改为：select * from (select id,hid,name,price,city,xpath,ypath,pic,addr,score,start from hotel where start='5' order by id asc )as a limit 0,6

在括号后面添加一个as a，运行得出正确结果

select * from (select id,hid,name,price,city,xpath,ypath,pic,addr,score,start from hotel 
 where start='5' order by id asc )as a limit 0,6

问题解决