EmploymentSite/doc/待更新脚本.txt

-- 2024-6-11 修改求职人员表，补全未填写的所属区县与所属街道
UPDATE pc_jobuser ju JOIN pc_site s ON ju.SiteID = s.SiteID SET ju.RegionCode = s.RegionCode
WHERE ju.RegionCode IS NULL OR ju.RegionCode = '';
UPDATE pc_jobuser ju JOIN pc_site s ON ju.SiteID = s.SiteID SET ju.StreetCode = s.StreetCode
WHERE ju.StreetCode IS NULL OR ju.StreetCode = '';