my sql 查找父类下面的所有子类
WITH RECURSIVE result (
id,
GoodsTypeName,
parentid
) AS (
SELECT
id,
GoodsTypeName,
parentid
FROM
goodstype
WHERE
id = 2
UNION ALL
SELECT
i.id,
i.GoodsTypeName,
i.parentid
FROM
goodstype i
JOIN result ON i.parentid = 
result.id
) SELECT
*
FROM
result
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/16007.html
