mysql丢失更新解决

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;

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
START TRANSACTION;
SELECT * FROM table_name WHERE id = 1;
UPDATE table_name SET column = value WHERE id = 1;
COMMIT;

-- 行级锁
START TRANSACTION;
SELECT * FROM table_name WHERE id = 1 FOR UPDATE;
UPDATE table_name SET column = value WHERE id = 1;
COMMIT;