-- 创建表:test:
CREATE TABLE `test` (
`objId` int(10) NOT NULL,
`orgId` int(10) NOT NULL,
`objName` varchar(50) NOT NULL,
PRIMARY KEY (`objId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 插入数据:
insert into test (objId,orgId,objName) values
(1,1,'test1'),
(1,2,'test2'),
(1,3,'test3')
on DUPLICATE key update
objName = values(objName),
orgId = values(orgId),
objName = values(objName);
-- 插入结果:
objId orgId objName
1 3 'test3'
OK~