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
SELECT id,catename,path,concat(path,',',id) AS fullpath FROM `likecate` WHERE 1 ORDER BY fullpath ASC;
2017-05-31