ON DUPLICATE KEY UPDATE根据数据库索引唯一性进行插入或更新(mybatis)

数据库操作

sql

INSERT INTO address_bak (NAME,lat,lng) VALUES ("jack",1461.1561,2532.14561) ON DUPLICATE KEY UPDATE  NAME="jack1111",lat=3.33333,lng=4.44444444

使用mybatis进行sql操作

    @Insert("INSERT INTO shop (shop_name,dish_type) VALUES 
    (#{meituan_shop.shop_name},#{meituan_shop.dish_type}) 
    ON DUPLICATE KEY UPDATE 
    shop_name=VALUES(shop_name),dish_type=VALUES(dish_type),")

记得先给表创建唯一索引或主键