CREATE TABLE `t1` (
`id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `t2` (
`id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
INSERT INTO `t1` (`id`, `name`) VALUES (1, 'xxx1');
INSERT INTO `t2` (`id`, `name`) VALUES (2, 'xxx');
UPDATE t1,t2
SET
t1.name = "王二",
t2.name = "张三"
WHERE
t1.id = 1
AND
t2.id = 2;
MYSQL 多表同时更新操作
最新推荐文章于 2024-07-08 19:28:21 发布