Mysql repeatable read-your-own-write behavior

Question

If my isolation level is repeatable read, and I have a transaction with 3 statements:

• SELECT * FROM table1 WHERE id = 1; (Read the row)
• UPDATE table1 SET ... WHERE id = 1; (Modify the row)
• SELECT * FROM table1 WHERE id = 1; (Read the row again)

Will the last select statement see the change made by the second statement?

Answer 1

Yes, of course! All transactions always see its own changes, no matter which isolation level they have.