mysql 查出二级分类_sql多级分类的级联查询

CREATE TABLE t_category

(

ID INT IDENTITY(1,1) PRIMARY KEY,

Name VARCHAR(40) NOT NULL,

ParentID INT DEFAULT(-1)

)

?-- 插入一些测试数据

INSERT INTO t_category(name) VALUES('计算机类')

INSERT INTO t_category(name) VALUES('吃的类')

INSERT INTO t_category(name, parentid) VALUES('linux', 1)

INSERT INTO t_category(name, parentid) VALUES('python', 1)

INSERT INTO t_category(name, parentid) VALUES('oracle', 1)

INSERT INTO t_category(name, parentid) VALUES('水果', 2)

INSERT INTO t_category(name, parentid) VALUES('主食', 2)

INSERT INTO t_category(name, parentid) VALUES('米饭', 7)

INSERT INTO t_category(name, parentid) VALUES('面食', 7)

INSERT INTO t_category(name, parentid) VALUES('django', 4)

INSERT INTO t_category(name, parentid) VALUES('tornado', 4)