Skip to content
upan edited this page Apr 6, 2017 · 3 revisions

花式更新 (重复插入时更新)

REPLACE INTO feeds (p_id,p_name) VALUES (1,'Olle');

ON DUPLICATE KEY UPDATE 的坑

是用该语句当使用innoDB时会产生gap,及自增ID会空跳

Clone this wiki locally