![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
ID
20000000000
20001000000
20001050000
20001060000
20001070000
20001080000
20001090000
20001100000
20001110000
20002000000
20002050000
20002060000
20002070000
20003000000
20003050000
20003060000
20003070000
20005000000
20006000000
20006010000
20006010100
20006010200
20006010300
20006020000
20006020100
20006030000
20006030100
20006030200
20006030300
20006050000
有如上一个表,ID为反应数据集之间关系的唯一字段。其中“20000000000 ”为根目录,我用WEBFXtree做的树形结构。第一层取出20001000000,20002000000……,如何使用200001000000如何取出第二层200001010000,20001020000……?请给个思路?或SQL如何写?

