select?id,catename,path,concat(path,',',id)?as?fullpath?from?likecate?where?1?order?by?fullpath?asc;

INSERT INTO likecate VALUES

(1,'','手機(jī)',0,0),

(2,'1','功能手機(jī)',0,0),

(3,'1,2','老人手機(jī)',0,0),

(4,'1,2','兒童手機(jī)',0,0),

(5,'1','智能手機(jī)',0,0),

(6,'1,5','Android手機(jī)',0,0),

(7,'1,5','iOS手機(jī)',0,0),

(8,'1,5','winphoto手機(jī)',0,0),

(9,'1,2,4','色盲手機(jī)',0,0),

(10,'1,2,3','大字手機(jī)',0,0),

(11,'12','臺式機(jī)',0,0),

(12,'','電腦',0,0),/*經(jīng)過一些增刪操作，有可能父類id大于子類id*/

(13,'12,11','一體機(jī)',0,0),

(14,'12,11','非一體機(jī)',0,0),

(15,'12','筆記本',0,0);