Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
MySQL 5.6 Lock Tables

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?
Best Answer
-
they are ALL locked until you either unlock or end the session.
Dave Stokes
MySQL Community Manager
Answers
-
they are ALL locked until you either unlock or end the session.
Dave Stokes
MySQL Community Manager
-
Hi Dear
I need some guidance.Can you please share with me your email address ?
-
it would probably be better to get help from https://forums.mysql.com as i am travelling so much this time of year. Our MySQL Oracle Enginners monitor the forums and will be fast to answer then I
Dave Stokes
MySQL Community Manager
-
Actually i need guideline of MYSQL 5.6 Exam , and at forms i dont think i can get better information .
-
I am no longer involved with the MySQL certification exams but can tell you I took the beta of the 5.6 DBA exam and found it very hard. Another member of the MySQL Community Team at the time of the beta took the DBA and Developer exams and concurred that they were very hard. The best advise is to go through the list of items covered on the exam and study your rear end off.
Good luck.
Dave Stokes
MySQL Community Manager
-
Dear Sir
I know this exam is very hard because i have already attempted 2 times and not able to clear the exam. . & i have done my complete preparation from official documentation https://dev.mysql.com/doc/refman/5.6/en/preface.html plus 6 months practical work. Now i just trying to find out a way how to clear this exam because this task giving me a lot of headache.
-
Hi Dear
I am in search of open source data platform which can perform ETL over Big data (structured, semi-structured & un-structured) and analytical tools for data visualization to build analytical dashboards.
I will be grateful if you can share your choice of open source data platform and data visualization tools information & your use case high level information their key features and unique capabilities. Also relevant enablement resources/training options.
Looking forward for a healthy discussion over here.
Regards
Mubashar Iftikhar
-
Dear Dave Stokes,
I need some help.I have two MySQL Database Servers i.e. One is Active Server --> Master and second is Passive Server --> Slave.
And as we know we have 3-4 MySQL HR,DR Solutions / Clustering options.For example
01 : MySQL NDB Cluster
02 : MySQL InnoDB Cluster
03 : MySQL Cluster Carrier Grade
My First Question is i want to deploy One Active & One Passive MySQL Server so which Cluster Option / HA,DR Option will be fit for above mentioned scenario ?
My Second Question is suppose i have deploy One Active & One Passive MySQL Server in any above mentioned Cluster Option / HA,DR Option. So what about licensing ? I have to buy license of MySQL Servers/ Cluster ?
Regards,
Mubashar Iftikhar
-
Please see your other question asked today.
Dave Stokes
MySQL Community Manager