Explain MySQL locks?



Explain MySQL locks?..

Answer / 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

More MySQL Interview Questions

What is pragma autonomous_transaction?

0 Answers  


What is the purpose of using ifnull() function?

0 Answers  


Describe mysql transaction properties.

0 Answers  


How do I backup mysql database on linux?

0 Answers  


what is the difference between gui testing and database testing? : Mysql dba

0 Answers  


How do you use auto increment?

0 Answers  


How can we run batch mode in mysql?

0 Answers  


Is mysql relational?

0 Answers  


Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers  


How to get a version of mysql?

0 Answers  


What are the steps required to view your mysql database?

0 Answers  


when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

1 Answers  


Categories