新增一个字段,需要往这个字段插入与别的表相关联的数据

技术2022-07-12 88

UPDATE t_nv_traffic_violation SET intersection_id = b.guid FROM t_nv_intersection_management b WHERE t_nv_traffic_violation.intersection_name = b.intersection_name

Processed: 0.009, SQL: 10