CREATE TABLE deepClassify(
id int(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
pid int(10) UNSIGNED,
classifyName varchar(30),
classifyOrder int(10) UNSIGNED,
createTime int(10) UNSIGNED
);
id int(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
pid int(10) UNSIGNED,
classifyName varchar(30),
classifyOrder int(10) UNSIGNED,
createTime int(10) UNSIGNED
);
2017-07-24
個(gè)人覺得還是全路徑無線分類比較好,減少很多次數(shù)據(jù)庫查詢。
像京東這樣的公司如何做無限極分類?
像京東這樣的公司如何做無限極分類?
2017-05-31
SELECT id,catename,path,concat(path,',',id) AS fullpath FROM `likecate` WHERE 1 ORDER BY fullpath ASC;
2017-05-31