首页 > 数据库技术 > 详细

mysql存在就更新,不存在就新增

时间:2017-05-24 09:41:11      阅读:239      评论:0      收藏:0      [点我收藏+]

INSERT INTO newest_log_operation(
    ACTION, OPERATION, KEY_VALUE, BUS_KEY, CONTENT, USER_ID, VERSION, MODULE,CREATE_TIME)
   VALUES (:action, :operation, :keyValue, :busKey, :content, :userId, 1, :module,now())
   ON DUPLICATE KEY UPDATE
    ACTION = VALUES(ACTION),OPERATION = VALUES(OPERATION),BUS_KEY = VALUES(BUS_KEY),CONTENT = VALUES(CONTENT),
    USER_ID = VALUES(USER_ID),VERSION = VERSION + 1,CREATE_TIME = VALUES(CREATE_TIME);

1.ON DUPLICATE KEY UPDATE:表示唯一键重复或者主键重复

2.VALUES (:action, :operation, :keyValue, :busKey, :content, :userId, 1, :module,now()):假如不存在值,则新增记录,并且赋值

3.ACTION = VALUES(ACTION),OPERATION = VALUES(OPERATION),BUS_KEY = VALUES(BUS_KEY),CONTENT = VALUES(CONTENT),
    USER_ID = VALUES(USER_ID),VERSION = VERSION + 1,CREATE_TIME = VALUES(CREATE_TIME):表示假如唯一健或者主键已经存在,则更新部分字段.

mysql存在就更新,不存在就新增

原文:http://www.cnblogs.com/nizuimeiabc1/p/6897337.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!