mysql并发update

START TRANSACTION;
SELECT * FROM table_name WHERE id = 1 FOR UPDATE;
-- 执行更新操作
UPDATE table_name SET column = value WHERE id = 1;
COMMIT;

-- 假设有一个版本号字段 version
START TRANSACTION;
SELECT * FROM table_name WHERE id = 1;
-- 执行更新操作，检查版本号是否一致
UPDATE table_name SET column = value, version = version + 1 WHERE id = 1 AND version = current_version;
COMMIT;

START TRANSACTION;
SELECT * FROM table_name WHERE id = 1 FOR UPDATE;
-- 执行更新操作
UPDATE table_name SET column = value WHERE id = 1;
COMMIT;