mysql set多个值

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

UPDATE users
SET name = 'John Doe', age = 30, address = '123 Main St'
WHERE user_id = 1;

-- 错误的示例
UPDATE users
SET name = 'John Doe' age = 30, address = '123 Main St'
WHERE user_id = 1;

-- 正确的示例
UPDATE users
SET name = 'John Doe', age = 30, address = '123 Main St'
WHERE user_id = 1;

-- 错误的示例
UPDATE users
SET name = 'John Doe'
WHERE user_id = 100; -- 假设user_id为100的用户不存在

-- 正确的示例
UPDATE users
SET name = 'John Doe'
WHERE user_id = 1; -- 确保user_id为1的用户存在

-- 分批更新的示例
START TRANSACTION;
UPDATE users
SET status = 'active'
WHERE user_id BETWEEN 1 AND 1000;
COMMIT;

START TRANSACTION;
UPDATE users
SET status = 'active'
WHERE user_id BETWEEN 1001 AND 2000;
COMMIT;