mysql insert or update

INSERT INTO vtm_addressinfo(UserId,AcceptUser,AcceptTel,AcceptLocation,Email,CreateTime)
VALUES(@UserId,@AcceptUser,@AcceptTel,@AcceptLocation,@Email,@CreateTime) 
ON DUPLICATE KEY UPDATE 
UserId=@UserId,AcceptUser=@AcceptUser,AcceptTel=@AcceptTel,AcceptLocation=@AcceptLocation,Email=@Email,ModifyTime=@ModifyTime

　　

UserId唯一约束

insert 失败后会update

索引自增断号问题
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/yyzyou/p/12707006.html