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

Question

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币，望各位多多包涵）

Answer 1

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