mysql 递归查询:mysql实现递归查询[朗读]

selectid,name,pidfrom(select*fromproductsorderbypid,id)products_sorted,(select@道pv:='1')initialisationwherefind_in_set(pid,@pv)andlength(@pv:=concat(@pv,',',id))。