sql更新数据的几种方式
1.全删除全插入
2.delete当天数据, insert当天数据
3.根据主键更新数据
merge into a
using b on()
when matched then update
when not matched then insertINSERT INTO a(id,name)
SELECT id,name FROM b
ON DUPLICATE KEY UPDATE nameb.name
4.更新拉链表
update…
2026/7/18 21:33:03