Can somebody please tell me what happens when you LEFT JOIN tables for a SELECT FOR UPDATE using an innoDB storage engine.
Do all the rows from all the joined tables get locked, or is only the primary table rows?
For example, if I do..
SELECT userID, countryID FROM user LEFT JOIN address USING (userID) WHERE userID = 1 FOR UPDATE
Will the row in the address table also be locked? Or do I need to lock that separately.