INSERT INTO book (
id,
bName,
price,
authorld,
publishDate
)
VALUES
(
1,
'水浒传',
50.6,
'施耐庵1',
'2016-5-21'
)
ON DUPLICATE KEY
UPDATE
bName =
VALUES
(bName),
price =
VALUES
(price),
authorld =
VALUES
(authorld),
publishDate =
VALUES
(publishDate) ;
在mybatis中
<insert id="addDiag" parameterType="com.hfkj.entity.Diag">
insert into
<include refid="tableName"></include>
(
<include refid="Field"></include>
) values (
<include refid="FieldValue"></include>
)
ON DUPLICATE KEY
UPDATE
io_type=values(io_type),
icd_code=values(icd_code),
icd_name=values(icd_name),
dr_code=values(dr_code),
icd_type=values(icd_type),
icd_dr_date=values(icd_dr_date)
</insert>