CREATE TABLE `user_card` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`uid` INT(10) DEFAULT '0' COMMENT '用户ID',
`grade_id` INT(10) DEFAULT '0' COMMENT '等级ID',
`name` VARCHAR(255) DEFAULT '' COMMENT '姓名',
`money` DECIMAL(10,2) DEFAULT '0.00' COMMENT '余额',
PRIMARY KEY (`id`),
UNIQUE KEY `uid_gid` (`uid`,`grade_id`) -- 业务上的唯一键
) ENGINE=INNODB DEFAULT CHARSET=utf8 ;
SELECT * FROM user_card
INSERT INTO user_card(uid,grade_id,NAME,money)
VALUES(1,1,'aaaa',11),(2,2,'bbbb',22),(3,3,'cc',3)
ON DUPLICATE KEY UPDATE money=money,NAME=VALUES(NAME),grade_id=777