Shulou(Shulou.com)06/01 Report--

1. First set the full_name (full path) update S_DEPARTMENT t set t.full_name ='XX Group 'where fid='-1' of the first-level menu 2. Set the full_nameupdate of the secondary menu (select a. Depended name dd,b.full_name cc from (select * from S_DEPARTMENT where dep_level ='2') a -- get second-level menu (select * from S_DEPARTMENT where dep_level ='1') b-- get first-level menu where a.fid = b.id) set full_name = cc | |'/'| | dep_name

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.