在进行更新数据的时候,需要更新多条数据,由于不想一条一条写update,因此想用case when来进行批量更新
update t1 set date_time =
case when title like '小明%' then '2021-01-01'
when title like '小王%' then '2021-01-02'
else date_time end
但是,表中有几十万条数据,更新会很慢。
(测试数据23W条,更新15条数据,需要0.8s)
于是经过思考,考虑用join
代替case when
update t1 set t1.date_time = t2.date_time
from table1 as t1 inner join (
select '小明%' as title, '2021-01-01' as date_time union all
select '小王%', '2021-01-02') as t2
on t1.title like t2.title
经过测试,同样15条用时0.22s左右