2018年8月9日
mysql 查询所有父级名称
摘要： SELECT T2.id, T2.name FROM ( SELECT @r AS _id, @stop:=@stop+if(@r=2,1,@stop) as stop, (SELECT @r := p_id FROM goods_class WHERE id = _id) AS p_id, @l := @l + ... 阅读全文
posted @ 2018-08-09 17:04 itvita 阅读(2544) 评论(0) 推荐(0) 编辑