目录
1.准备
CREATE DATABASE mahaiwuji;
USE mahaiwuji;
CREATE TABLE emp
(
empno INT PRIMARY KEY,
ename VARCHAR(10),
sal INT
) ENGINE = INNODB DEFAULT CHARSET = utf8;
INSERT INTO emp VALUES (1,'smith',2800);
INSERT INTO emp VALUES (2,'allen',1500);
INSERT INTO emp VALUES (3,'ward',3500);
INSERT INTO emp VALUES (4,'jones',1300);
INSERT INTO emp VALUES (5,'martin',1600);
INSERT INTO emp VALUES (6,'blake',3000);
2.方式一:主键冲突更新
INSERT [INTO] 数据表名 [(字段列表)] {VALUES | VALUE} (字段列表) ON DUPLICATE KEY UPDATE 字段名1 = 新值1[,字段名2 = 新值2] …;
INSERT INTO emp (empno,ename,sal) VALUE