以前不知道mysql可以用merge的方式更新,今天看到了
CREATE TABLE day_hit_counter
(
DAY DATE NOT NULL,
slot tinyint unsigned NOT NULL,
cnt INT unsigned NOT NULL,
PRIMARY KEY(DAY,slot)
);
INSERT INTO day_hit_counter(DAY,slot,cnt)
VALUES(current_date,1,1)
ON duplicate KEY UPDATE cnt = cnt+1;
INSERT INTO day_hit_counter(DAY,slot,cnt)
VALUES(current_date,2,1)
ON duplicate KEY UPDATE cnt = cnt+1;
SELECT * FROM day_hit_counter;
INSERT INTO day_hit_counter(DAY,slot,cnt)
VALUES(current_date,2,1)
ON duplicate KEY UPDATE cnt = cnt+1;
SELECT * FROM day_hit_counter;
INSERT INTO day_hit_counter(DAY,slot,cnt)
VALUES(current_date,2,1)
ON duplicate KEY UPDATE cnt = cnt+1;
SELECT * FROM day_hit_counter;
效果如下:
mysql> CREATE TABLE d