What Is Row Level Locking

Row-level locking means that only the row that is accessed by an application will be locked. Hence, all other rows that belong to the same page are free and can be used by other applications. The Database Engine can also lock the page on which the row that has to be locked is stored.

What is row lock in SQL?

ROWLOCK means that SQL will lock only the affected row, and not the entire table or the page in the table where the data is stored when performing the delete. This will only affect other people reading from the table at the same time as your delete is running.

How do I lock a row in MySQL?

SELECT * FROM table_name WHERE id=10 FOR UPDATE ; 2) Lock In Share mode: Any lock placed with ` LOCK IN SHARE MODE ` will allow other transaction to read the locked row but it will not allow other transaction to update or delete the row.