语句查询,用这个更合适点,解决了多个一级目录问题
SELECT id,catename,path,IF (path,concat(path, ',', id),id) AS fullpath FROM likecate ORDER BY fullpath ASC; 语句查询,用这个更合适点,解决了多个一级目录问题
SELECT id,catename,path,IF (path,concat(path, ',', id),id) AS fullpath FROM likecate ORDER BY fullpath ASC; 语句查询,用这个更合适点,解决了多个一级目录问题
2021-02-26
举报