close
一般插入重覆pk的資料如
insert into cities (id,name) values(1,"高雄")
insert into cities (id,name) values(1,"台北")
會duplicate key
但你加了
insert into cities (id,name) values(1,"台北") on duplicate key update name="台北"
就會將id=1的高雄改成台北
全站熱搜
留言列表
