mysql 批量修改

使用的是联合主键，表结构：

CREATE TABLE `yw_hs_test` (
    `id` INT ( 11 ) NOT NULL,
    `version` INT ( 11 ) NOT NULL,
    `name` VARCHAR ( 255 ) CHARACTER 
    SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `age` INT ( 11 ) NULL DEFAULT NULL,
    `sex` INT ( 11 ) NULL DEFAULT NULL,
    PRIMARY KEY ( `id`, `version` ) USING BTREE 
) ENGINE = INNODB CHARACTER 
SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

批量修改的sql语句

UPDATE yw_hs_test 
SET
    NAME =
    CASE
        WHEN id = 1 AND version = 1 THEN
        'rr' 
        WHEN id = 2 AND version = 1 THEN
        'a1' 
        WHEN id = 2 AND version = 2 THEN
        'c1' 
        WHEN id = 3 AND version = 1 THEN
        'd1' 
    END ,
    AGE= 
    CASE
        WHEN id = 1 AND version = 1 THEN
        110
        WHEN id = 2 AND version = 1 THEN
        210 
        WHEN id = 2 AND version = 2 THEN
        220
        WHEN id = 3 AND version = 1 THEN
        310 
    END
WHERE
    (id = 1 and version = 1) or
    (id = 2 and version = 1) or
    (id = 2 and version = 2) or
    (id = 3 and version = 1) 

在mybaits中sql后续测试后更新
待续...