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

Timo Hahn
Answer

Isn't this exactly what you told the pivot table to do?

The two records can't be distinguished with the given values of startdate,  hat and sipno.

You can add the starttime to the row edge and you should see the two rows.

Timo

Marked as Answer by Okan Sutcuoglu · Sep 27 2020
Okan Sutcuoglu

Main problem here is i misunderstood pivot table's work principles. Thank you.

1 - 2

Post Details

Added on Oct 31 2018
9 comments
397 views