mysql对树形结构表逐级赋值的update语句

UPDATE 表名
SET first_id = SUBSTRING_INDEX("-11/22/33/","/",1),
	second_id = IF(SUBSTRING_INDEX("-11/22/33/","/",2) = "-11/22/33/",0,SUBSTRING_INDEX(SUBSTRING_INDEX("-11/22/33/","/",2),"/",-1)),
	third_id = IF(SUBSTRING_INDEX("-11/22/33/","/",3) = "-11/22/33/",0,SUBSTRING_INDEX(SUBSTRING_INDEX("-11/22/33/","/",3),"/",-1)),
	fourth_id = IF(SUBSTRING_INDEX("-11/22/33/","/",4) = "-11/22/33/",0,SUBSTRING_INDEX(SUBSTRING_INDEX("-11/22/33/","/",4),"/",-1)),
	fifth_id = IF(SUBSTRING_INDEX("-11/22/33/","/",5) = "-11/22/33/",0,SUBSTRING_INDEX(SUBSTRING_INDEX("-11/22/33/","/",5),"/",-1)),
	sixth_id = IF(SUBSTRING_INDEX("-11/22/33/","/",6) = "-11/22/33/",0,SUBSTRING_INDEX(SUBSTRING_INDEX("-11/22/33/","/",6),"/",-1)),
    first_name = SUBSTRING_INDEX("一级名称/二级名称/三级名称/","/",1),
	second_name = IF(SUBSTRING_INDEX("一级名称/二级名称/三级名称/","/",2) = "一级名称/二级名称/三级名称/",NULL,SUBSTRING_INDEX(SUBSTRING_INDEX("一级名称/二级名称/三级名称/","/",2),"/",-1)),
	third_name = IF(SUBSTRING_INDEX("一级名称/二级名称/三级名称/","/",3) = "一级名称/二级名称/三级名称/",NULL,SUBSTRING_INDEX(SUBSTRING_INDEX("一级名称/二级名称/三级名称/","/",3),"/",-1)),
    fourth_name = IF(SUBSTRING_INDEX("一级名称/二级名称/三级名称/","/",4) = "一级名称/二级名称/三级名称/",NULL,SUBSTRING_INDEX(SUBSTRING_INDEX("一级名称/二级名称/三级名称/","/",4),"/",-1)),
    fifth_name = IF(SUBSTRING_INDEX("一级名称/二级名称/三级名称/","/",5) = "一级名称/二级名称/三级名称/",NULL,SUBSTRING_INDEX(SUBSTRING_INDEX("一级名称/二级名称/三级名称/","/",5),"/",-1)),
	sixth_name = IF(SUBSTRING_INDEX("一级名称/二级名称/三级名称/","/",6) = "一级名称/二级名称/三级名称/",NULL,SUBSTRING_INDEX(SUBSTRING_INDEX("一级名称/二级名称/三级名称/","/",6),"/",-1))
WHERE enabled_flag = 1;

注意事项："-11/22/33/"或"一级名称/二级名称/三级名称/"替换为表中的字段，字段里面最后的【/】是必须要带上的