select * from
select a.CDNID AS NODEID,a.SERVID AS SERVID,c.TYPE AS NODETYPE,c.ACTIVE AS
NODE_ACTIVE,a.ACTIVE AS SERV_ACTIVE,
b.IP1 AS WANIP,b.IP3 AS LIP,b.CTRLIP AS CTRLIP,a.KEYID AS KEYID,
a.HASH1_START AS HASH1_START,a.HASH1_END AS HASH1_END,a.STAYPATH AS STAYPATH
from ((tb_store_node a join tb_hosts b) join tb_node_info c)
where ((a.SERVID = b.SERVID) and (c.CDNID = a.CDNID))
)
limit 0,10这样为什么不行?把上面的查询结果当成一张表为什么不行?
select a.CDNID AS NODEID,a.SERVID AS SERVID,c.TYPE AS NODETYPE,c.ACTIVE AS
NODE_ACTIVE,a.ACTIVE AS SERV_ACTIVE,
b.IP1 AS WANIP,b.IP3 AS LIP,b.CTRLIP AS CTRLIP,a.KEYID AS KEYID,
a.HASH1_START AS HASH1_START,a.HASH1_END AS HASH1_END,a.STAYPATH AS STAYPATH
from ((tb_store_node a join tb_hosts b) join tb_node_info c)
where ((a.SERVID = b.SERVID) and (c.CDNID = a.CDNID))
)
limit 0,10这样为什么不行?把上面的查询结果当成一张表为什么不行?
(select a.CDNID AS NODEID,a.SERVID AS SERVID,c.TYPE AS NODETYPE,c.ACTIVE AS
NODE_ACTIVE,a.ACTIVE AS SERV_ACTIVE,
b.IP1 AS WANIP,b.IP3 AS LIP,b.CTRLIP AS CTRLIP,a.KEYID AS KEYID,
a.HASH1_START AS HASH1_START,a.HASH1_END AS HASH1_END,a.STAYPATH AS STAYPATH
from ((tb_store_node a join tb_hosts b) join tb_node_info c)
where ((a.SERVID = b.SERVID) and (c.CDNID = a.CDNID))
)
limit 0,10
corresponds to your MySQL server version for the right syntax to use near 'rsele
ct * from
(select a.CDNID AS NODEID,a.SERVID AS SERVID,c.TYPE AS NODETYP' at line 1
(select a.CDNID AS NODEID,a.SERVID AS SERVID,c.TYPE AS NODETYPE,c.ACTIVE AS
NODE_ACTIVE,a.ACTIVE AS SERV_ACTIVE,
b.IP1 AS WANIP,b.IP3 AS LIP,b.CTRLIP AS CTRLIP,a.KEYID AS KEYID,
a.HASH1_START AS HASH1_START,a.HASH1_END AS HASH1_END,a.STAYPATH AS STAYPATH
from ((tb_store_node a join tb_hosts b) join tb_node_info c)
where ((a.SERVID = b.SERVID) and (c.CDNID = a.CDNID))
)
limit 0,10