java自動生成自增id sql查詢某表中父列表及父下子的個(gè)數(shù)?
sql查詢某表中父列表及父下子的個(gè)數(shù)?select *,(select count(1) from tabname b where b.parentid = a.id) child_countfro
sql查詢某表中父列表及父下子的個(gè)數(shù)?
select *,(select count(1) from tabname b where b.parentid = a.id) child_countfrom tabname a where parentID ="" or parentID is null