Question

请教mysql一个sql语句，存在则更新，不存在则插入

Answer 1

操作方法如下：
CREATE TABLE `test` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Index` int(4) NOT NULL DEFAULT '0',
`IntVal` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`Id`),
UNIQUE KEY `Index` (`Index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into test(`Id`, `Index`, `IntVal` ) values ( 1, 1, 2 );
insert into test(`Id`, `Index`, `IntVal` ) values ( 2, 1, 2 ) ON DUPLICATE KEY UPDATE IntVal=10;

Answer 2

replace into table