CREATE TABLE fullPath(
id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
cateName VARCHAR(30),
path VARCHAR(100) NOT NULL,
cateOrder SMALLINT,
createTime SMALLINT
);
id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
cateName VARCHAR(30),
path VARCHAR(100) NOT NULL,
cateOrder SMALLINT,
createTime SMALLINT
);
2017-07-24
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