这是个视图
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))
)怎么把它当成表分页?
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))
)怎么把它当成表分页?
MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html
取前100条记录。
select * from v1 limit 101,200
100-200的记录。
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这样为什么不行?