MySQL错误:Every derived table must have its own alias

最新推荐文章于 2022-10-21 19:20:28 发布

weixin_30856965

最新推荐文章于 2022-10-21 19:20:28 发布

阅读量236

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/googlegis/archive/2011/12/22/2978760.html

版权

Select distinct(LAC_CI) from (Select LAC_CI from `dtdb_sh_test`.dt_measurment where callid='04021002ms31310379260576' union Select LAC_CI from `dtdb_sh_test`.dt_measurment where callid='04021002ms31310379260576')

在执行稍微复杂查询的时候，

MySQL有时会遇到如下报错情况：

Error Code : 1248
Every derived table must have its own alias

解决方法：

在执行复杂查询处为你的表任意起个别名就可以了。

Select distinct(LAC_CI) from (Select LAC_CI from `dtdb_sh_test`.dt_measurment t where t.callid='04021002ms31310379260576' union Select LAC_CI from `dtdb_sh_test`.dt_measurment d where d.callid='04021002ms31310379260576') as t

此处 as t 虽然无任何作用和意义，但是SQL语句是万万少不得的。

转载于:https://www.cnblogs.com/googlegis/archive/2011/12/22/2978760.html