MySQL数据库内的表批量更新操作

方法

为了实现批量更新数据库内表a的数据，可以使用下面的两种方式。

UPDATE table_a a INNER JOIN table_b b ON a.id = b.uuid SET a.username = b.username 

或者

UPDATE table_a a, table_b b SET a.username = b.username WHERE a.id = b.uuid

表的结构

---- 表a-------------
DROP TABLE IF EXISTS "table_a";
CREATE TABLE "table_a" {
	"id" char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
	"username" varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名字',
	PRIMARY KEY ("id") USING BTREE
}ENGINE = InnoDB  CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

------ 表b ---------------
DROP TABLE IF EXISTS "table_b";
CREATE TABLE "table_b"  (
  "id" char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  "username" varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名字',
  "uuid" char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表a的主键',
  PRIMARY KEY ("id") USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;