mysql replace into测试调研

性能测试

• 数据量: 10000调整

• 字段数量: 60个

  
  image.png

数据库结构

image.png

REPLACE INTO 测试

REPLACE INTO demo(id,name,age) VALUES (1,'wsy',30);

image.png

REPLACE INTO demo(id,demo1,demo2) VALUES (1,'demo1','demo2');

image.png

insert into

insert into demo(id,name,age) VALUES (1,'wsy',30);

image.png

insert into demo (id,demo1,demo2) VALUES 
(1,'demo1','demo2'),
(2,'demo1','demo2')
on duplicate key update 
id=values(id),
demo1=values(demo1),
demo2=values(demo2)

image.png

insert into demo(id,demo3) VALUES (1,'demo3') on duplicate key update id=values(id), demo3=values(demo3);

image.png