SQL数据库出错

来源：百度知道 编辑：UC知道 时间：2024/05/21 08:08:42
Query Error: INSERT INTO xsd98_memberdata SET uid= '2707' , postnum='0', lastvisit='1252147472', thisvisit='1252147472', onlineip='60.168.250.85' The URL Is:MySQL Server Error:Duplicate entry '2707' for key 1 ( 1062 ) 查看错误相关信息

SQL语句写错了，INSERT INTO 是插入操作，应该写成INSERT INTO xsd98_memberdata values('2707','0','1252147472','1252147472','60.168.250.85' )
SET是用在修操作里面的：
UPDATE xsd98_memberdata SET postnum='0', lastvisit='1252147472', thisvisit='1252147472', onlineip='60.168.250.85' where uid= '2707'

uid值重复