SET autocommit = 0; START TRANSACTION; SELECT * FROM t1 WHERE `is_uncommitted` > 0; pk id int1 int1_key int1_unique int2 int2_key int2_unique for_update timestamp connection_id thread_id is_uncommitted is_consistent COMMIT;