摘要:
1、主要思想:根据已有数据,规则性的造数据select * FROM(select lId,strName,lId as lParentId,-1 as orderIdx from tbClassify WHERE lParentId = 0 UNION ALL(select t1.* from tbClassify t1 join(select lId from tbClassify where lParentId=0 order by orderIdx) t2 ont1.lParentId = t2.lId where 1=1 order by t1.lParentId,t1.orderI 阅读全文