// 给t_base_model_material 车辆配置表新加的network字段 赋值所关联的 t_base_model车型表的network字段的值
UPDATE public.t_base_model_material
SET network = (select network from t_base_model where t_base_model_material.model_id = t_base_model.id)
WHERE network is null
UPDATE public.goods
SET network = (select network from worker where goods.worker_id = worker.id)
WHERE network is null
处理历史数据脚本
于 2024-07-10 19:40:40 首次发布