CREATE TABLE `country` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`NAME` varchar(255) NOT NULL COMMENT '国家名称',
`CODE` varchar(255) NOT NULL COMMENT '国家编码',
PRIMARY KEY (`ID`),
UNIQUE KEY `u_code` (`CODE`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='国家表'
INSERT INTO country ( `NAME`, `CODE` )
VALUES
( "Test", "1" )
ON DUPLICATE KEY UPDATE `CODE` = `CODE`
INSERT INTO country ( `NAME`, `CODE` )
VALUES
( "Test", "1" ),
( "Test2", "1" )
ON DUPLICATE KEY UPDATE `CODE` = `CODE`