CREATE TABLE `fenlei` ( `id` int(100) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '', `pid` smallint(10) DEFAULT NULL, `path` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`))
准备数据：
INSERT INTO `python3`.`fenlei`(`id`, `name`, `pid`, `path`) VALUES (1, '国际新闻', 0, '0');INSERT INTO `python3`.`fenlei`(`id`, `name`, `pid`, `path`) VALUES (2, '国内新闻', 0, '0');INSERT INTO `python3`.`fenlei`(`id`, `name`, `pid`, `path`) VALUES (3, '国际娱乐新闻', 1, '0-3');INSERT INTO `python3`.`fenlei`(`id`, `name`, `pid`, `path`) VALUES (4, '国际体育新闻', 1, '0-4');INSERT INTO `python3`.`fenlei`(`id`, `name`, `pid`, `path`) VALUES (5, '国内娱乐新闻', 2, '0-5');INSERT INTO `python3`.`fenlei`(`id`, `name`, `pid`, `path`) VALUES (6, '国内体育新闻', 2, '0-6');INSERT INTO `python3`.`fenlei`(`id`, `name`, `pid`, `path`) VALUES (7, '国际足球新闻', 4, '0-4-7');INSERT INTO `python3`.`fenlei`(`id`, `name`, `pid`, `path`) VALUES (8, '国内篮球新闻', 6, '0-6-8');