摘要:
根据子ID找到父ID SELECT T2.id, T2.name FROM ( SELECT @r AS _id, (SELECT @r := parent_id FROM table1 WHERE id = _id) AS parent_id, @l := @l + 1 AS lvl FROM ( 阅读全文
摘要:
根据子id找到最终父id ,放开parent_id = '0' 看到所有父id WITH RECURSIVE dict AS ( SELECT * FROM category WHERE id= '6' union ALL SELECT category.* FROM category, dict 阅读全文