語句查詢,用這個(gè)更合適點(diǎn),解決了多個(gè)一級(jí)目錄問題
SELECT id,catename,path,IF (path,concat(path, ',', id),id) AS fullpath FROM likecate ORDER BY fullpath ASC; 語句查詢,用這個(gè)更合適點(diǎn),解決了多個(gè)一級(jí)目錄問題
SELECT id,catename,path,IF (path,concat(path, ',', id),id) AS fullpath FROM likecate ORDER BY fullpath ASC; 語句查詢,用這個(gè)更合適點(diǎn),解決了多個(gè)一級(jí)目錄問題
2021-02-26
舉報(bào)
2021-02-26