What is row level locking?



What is row level locking?..

Answer / Umesh Kumar Chourasia

Row-level locking in MySQL means that individual rows are locked instead of the entire table. This improves concurrency by allowing other transactions to proceed while a single row is being modified.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

change column name and make a unique column so we get no dupes.

1 Answers  


What is the default port number of mysql?

1 Answers  


What is blob and text in mysql?

1 Answers  


Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.

3 Answers  


How to get the number of rows selected or affected by a sql statement?

1 Answers  


Write a query to find duplicate rows in table?

1 Answers  


How to use rank function in mysql?

1 Answers  


What are date and time data types?

1 Answers  


How do I edit a stored procedure in mysql?

1 Answers  


What storage engines are used in MySQL?

1 Answers  


How to get help information from the server?

1 Answers  


How do I change mysql password?

1 Answers  


Categories