tinalucky 2020-03-12 20:48 采纳率: 0%
浏览 414

ON DUPLICATE KEY UPDATE 更新显示 1 success 共 0 行受到影响。

INSERT INTO t_sp_team (TEAMID, TEAMNAME)VALUES( 'BZ', '备注99' ) ON DUPLICATE KEY UPDATE TEAMID='BZ';

1 queries executed, 1 success, 0 errors, 0 warnings

查询:INSERT INTO t_sp_team (TEAMID, TEAMNAME)VALUES( 'BZ', '员工报销99' ) ON DUPLICATE KEY UPDATE TEAMID='BZ'

共 0 行受到影响

但是用SELECT查询时能查得到数据:

SELECT * FROM t_sp_team WHERE teamid='BZ';

1 queries executed, 1 success, 0 errors, 0 warnings

查询:select * from t_sp_team where teamid='BZ' LIMIT 0, 1000

返回了 1 行

用ON DUPLICATE KEY UPDATE不生效,但直接用UPDATE语句是成功的,

UPDATE t_sp_team SET TEAMNAME='备注99' WHERE TEAMID='BZ';

1 queries executed, 1 success, 0 errors, 0 warnings

查询:update t_sp_team set TEAMNAME='备注99' where TEAMID='BZ'

共 1 行受到影响

请问这是什么原因或问题出在哪呢?
(没有C币,望各位多多包涵)

  • 写回答

1条回答 默认 最新

  • threenewbee 2020-03-12 22:31
    关注

    t_sp_team (TEAMID, TEAMNAME)
    这个表的主键是什么TEAMID是否允许重复,TEAMNAME是否允许NULL

    评论

报告相同问题?