如何做到 findByIdAndUpdate 仅更新不为空的字段
答案:2 悬赏:30 手机版
解决时间 2021-03-19 20:39
- 提问者网友：饥饿走向夜
- 2021-03-19 09:34
如何做到 findByIdAndUpdate 仅更新不为空的字段
最佳答案
- 五星知识达人网友：街头电车
- 2021-03-19 09:41
如何做到 findByIdAndUpdate 仅更新不为空的字段
12345678910111213 update test_v8_busy_revisit t set (t.outbound_type,t.outbound_stat,t.outbound_count,t.user_code,t.outbound_time)= ( select '0','11','1',t1.sales_person,t1.sales_time from tbl_sp_sales_records t1 where t1.target_table='TBL_CUST_DATA_TABLE_0000000298' and t1.sales_results = 'CALL_NOT_CONN_SENDMSG' and t1.sales_time >= start_time and t1.sales_time <= end_time and t2.field_50028161 = t.contact_id )WHERe t.contact_id IN(SELECt t2.field_50028161 FROM tbl_cust_data_table_0000000298 t2);
12345678910111213 update test_v8_busy_revisit t set (t.outbound_type,t.outbound_stat,t.outbound_count,t.user_code,t.outbound_time)= ( select '0','11','1',t1.sales_person,t1.sales_time from tbl_sp_sales_records t1 where t1.target_table='TBL_CUST_DATA_TABLE_0000000298' and t1.sales_results = 'CALL_NOT_CONN_SENDMSG' and t1.sales_time >= start_time and t1.sales_time <= end_time and t2.field_50028161 = t.contact_id )WHERe t.contact_id IN(SELECt t2.field_50028161 FROM tbl_cust_data_table_0000000298 t2);
全部回答
- 1楼网友：青灯有味
- 2021-03-19 11:18
我是来看评论的
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯