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币,望各位多多包涵)