Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings
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

AltStyle によって変換されたページ (->オリジナル) /