insert into sys_org(id,name,code,short_name,pid,deleted,type)
select court_id id,court_name name,court_code code,court_short_name short_name,parent_id pid,display deleted,'COURT' as `type` from court_info 
union all
select court_room_id id,court_room_name name,court_room_code code,court_room_name short_name,`court_id` pid,0 deleted,'ROOM' as `type` from court_room_info
作者:admin  创建时间:2023-03-20 15:36
最后编辑:admin  更新时间:2024-10-12 13:59