How many rows will be locked by SELECT ... ORDER BY xxx LIMIT 1 FOR UPDATE?

How many rows will be locked by SELECT ... ORDER BY xxx LIMIT 1 FOR UPDATE?

mysql transactions rowlocking

mysql

How do I lock on an InnoDB row that doesn't exist yet?

mysql locking innodb rowlocking database-locking

mysql

When exactly MySQL locks a row on updating InnoDB table?

mysql locking innodb rowlocking

mysql