<insert id="test">
INSERT INTO driver ( driver_name, id_card, mobile, driving_type, driving_age, urgent_user_name, urgent_user_phone )
VALUE
( '${driverName}', '${idCard}', '${mobile}', '${drivingType}', '${drivingAge}', '${urgentUserName}', '${urgentUserPhone}' )
ON DUPLICATE KEY UPDATE
driver_name = '${driverName}',
id_card = '${idCard}',
mobile = '${mobile}',
driving_type = '${drivingType}',
driving_age = '${drivingAge}',
urgent_user_name = '${urgentUserName}',
urgent_user_phone = '${urgentUserPhone}'
<selectKey keyProperty='id' resultType='Long' order='AFTER'>
SELECT ( select id FROM driver WHERE id_card = '${idCard}' ) id from DUAL
</selectKey>
</insert>
(MySQL) insert操作返回id与存在则插入,不存在则修改
最新推荐文章于 2022-10-26 11:29:17 发布