Explain MySQL locks?

Answer Posted / amith

Table-level locks allow the user to lock the entire table,
page-level locks allow locking of certain portions of the
tables row-level locks are the most granular and allow
locking of specific rows.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of mysql in comparison to oracle?

543


Why do gaps in sequences occur?

510


Can you tell how many values can set the function of mysql to consider?

508


What is dirty read and phantom read?

439


How do I assign a variable in mysql?

471






How to concatenate two character strings?

554


What is the use of mysqli_fetch_assoc?

484


How can I create database in mysql?

489


How many entries can mysql handle?

494


What is mysqli_select_db?

511


Which is better mysql or microsoft sql?

431


How do I insert an image into mysql workbench?

472


How to update a root password.

529


What is pdo mysql?

496


What are the technical features of MySQL?

572