insertinto?onduplicatekeyupdate/replaceinto澶?琛??版???缁?
?烘??????风??锛?????KV????琛??寤鸿〃璇??ュ?涓?锛?
CREATETABLE`dkv`(
`k1`int(11)NOTNULLDEFAULT"0",
`k2`int(11)NOTNULLDEFAULT"0",
`val`varchar(30)DEFAULTNULL,
PRIMARYKEY(`k1`,`k2`)
)ENGINE=InnoDBDEFAULTCHARSET=utf8
?版??ぇ姒?????风??:
+----+----+-----------+
|k1|k2|val |
+----+----+-----------+
| 1| 1|value1-1|
| 1| 2|value1-1|
| 1| 3|value1-1|
| 1| 5|value1-1|
| 1| 7|value1-1|
+----+----+-----------+
褰??????ヤ??℃?版???讹???瑕??ゆ??k1,k2)???﹀凡缁?瀛????1??elete锛?,?ュ??ㄥ氨update锛?涓?瀛??ㄥ氨insert锛?杩????涓??稿????merge杩?绋?锛??界?舵????K?ц???浣?????搴﹂??甯稿揩锛?浣????绔?SQL浜や???涓??讳?锛?濡???????100绗?杩??风??SQL锛??h?涓????????????锛???娌℃??浠?涔?涓???QL灏辫?芥??瀹???浜??????
??涓ょ???娉?锛?
绗??绉?锛?insertinto?onduplicatekeyupdate
insertDELAYEDintodkv
values
(1,2,"new12a"),
(1,3,"new33ba"),
(1,4,"new23222"),
(1,6,"new12333"),
(1,8,"newvaaaa"),
(1,20,"newvaff"),
(1,25,"newvaff")
ONDUPLICATEKEYUPDATEval=VALUES(val);
绗??绉?replaceinto锛?
??缁??借?藉??版???规??杩??凤?
replaceintodkv
values
(1,2,"new12a"),
(1,3,"new33ba"),
(1,4,"new23222"),
(1,6,"new12333"),
(1,8,"newvaaaa"),
(1,20,"newvaff"),
(1,25,"newvaff");
+----+----+-----------+
|k1|k2|val |
+----+----+-----------+
| 1| 1|value1-1|
| 1| 2|new12a |
| 1| 3|new33ba |
| 1| 4|new23222|
| 1| 5|value1-1|
| 1| 6|new12333|
| 1| 7|value1-1|
| 1| 8|newvaaaa|
| 1|20|newvaff |
| 1|25|newvaff |
+----+----+-----------+