What is row locking in mysql?



What is row locking in mysql?..

Answer / Neeraj Kumar Tomar

Row locking in MySQL is a mechanism to prevent conflicts when multiple transactions are accessing the same table. It allows for selective locking of individual rows, ensuring that one transaction doesn't interfere with another's read or write operations.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How to create a test table in your mysql server?

1 Answers  


Is microsoft sql same as mysql?

1 Answers  


How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?

4 Answers  


How to decrement dates by 1 in mysql?

1 Answers  


How do I zip a file in mysql?

1 Answers  


How do I change the max connection in mysql?

1 Answers  


I have two sql database at different PC.how can link b/w database and database tables.

2 Answers  


What is query design?

1 Answers  


Explain csv tables.

1 Answers  


What is myisamchk?

1 Answers  


I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 Answers  


Is there an object-oriented version of MySQL library functions?

1 Answers  


Categories