mysql 错误代码 1248 [英] mysql error code 1248

问题描述

我收到错误代码 1248，不知道为什么.提前致谢.

I am getting an error code 1248 and have no idea why. Thanks in advance.

select substr(cbt,1,8) day, 
    max((delta_GTP_InDataPktGn+delta_GTP_OutDataPktGn))/900
from 
(
    select a.cbt, a.datetime, 
    a.GTP_InDataPktGn - b.GTP_InDataPktGn as delta_GTP_InDataPktGn,
    a.GTP_OutDataPktGn - b.GTP_OutDataPktGn as delta_GTP_OutDataPktGn

    from
        (   select cbt, STR_TO_DATE(substr(cbt,1,12),'%Y%m%d%H%i') as datetime, 
            GTP_InDataPktGn, 
            GTP_OutDataPktGn
            from sgsn_GTP 
        ) a

        right join 
        (
            select cbt, STR_TO_DATE(substr(cbt,1,12),'%Y%m%d%H%i') as datetime, 
            GTP_InDataPktGn, 
            GTP_OutDataPktGn
            from sgsn_GTP 
        ) 
     on a.datetime = addtime(b.datetime,"00:15:00")
) z

where z.cbt between 20130429000000 and 20130430980000
group by day

推荐答案

Error 1248 is ER_DERIVED_MUST_HAVE_ALIAS，每个派生表都必须有自己的别名".

Error 1248 is ER_DERIVED_MUST_HAVE_ALIAS, "Every derived table must have its own alias".

您联接右侧的派生表没有别名:

The derived table on the right of your join has no alias:

    right join 
    (
        select cbt, STR_TO_DATE(substr(cbt,1,12),'%Y%m%d%H%i') as datetime, 
        GTP_InDataPktGn, 
        GTP_OutDataPktGn
        from sgsn_GTP 
    ) 
  --  ^ missing b

这篇关于mysql 错误代码 1248的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！