Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySQL 5.6 Lock Tables

Mubashar IftikharOct 31 2018 — edited May 17 2019

You want to lock the three tables a, b and c, and issue the following statements:

mysql> LOCK TABLES a READ;

mysql> LOCK TABLES b READ;

mysql> LOCK TABLES c READ;

Which tables are now locked?

This post has been answered by Dave Stokes-MySQL Community Team-Oracle on Oct 31 2018
Jump to Answer
Comments
Post Details
Added on Oct 31 2018
9 comments
399 views