存在则更新,不存在则插入
on duplicate key update
INSERT INTO `nursetrain_case_review_check`
(`id`,
`review_id`,
`checker`,
`checker_name`,
`check_date`,
`status`,
`complete_status`,
`true_status`,
`publish_status`,
`reason`,
`remark`)
VALUES (#{id},
#{review_id},
#{checker},
#{checker_name},
#{check_date},
#{status},
#{complete_status},
#{true_status},
#{publish_status},
#{reason},
#{remark})
on duplicate key update status=#{status} ,checker= #{checker}, checker_name=#{checker_name},check_date= #{check_date},
complete_status= #{complete_status},true_status= #{true_status},publish_status= #{publish_status},
reason= #{reason}, remark= #{remark}
通过此延伸
存在更新,不存在忽略
REPLACE INTO
REPLACE INTO 表名 () VALUES ()
存在忽略,不存在插入
INSERT IGNORE INTO
INSERT IGNORE INTO 表名 ()VALUES ()
存不存在主要是(主键,索引或者唯一条件存不存在)