1、.replace into 批量更新
replace into t_student(id,dr) values (1,'2'),(2,'3'),...(x,'y');
例子:
replace into t_student
(`Id`,`Author`,`CreatedTime`,`UpdatedTime`)
values
(1,'王五','2016-12-12 12:20','2016-12-12 12:20'),
(2,'张三','2016-12-12 12:20','2016-12-12 12:20');
2、insert into ...on duplicate key update批量更新
insert into t_student(id,dr) values (1,'2'),(2,'3'),...(x,'y') on duplicate key update dr=values(dr);
例子:
insert into t_student
(`Id`,`Author`,`CreatedTime`,`UpdatedTime`)
values
(1,'张三','2017-12-12 12:20','2017-12-12 12:20'),
(2,'王五','2017-12-12 12:20','2017-12-12 12:20')
on duplicate key update
Author=values(Author),
CreatedTime=values(CreatedTime),
UpdatedTime=values(UpdatedTime);
replace into 和 insert into on duplicate key update的不同在于: