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 |
What is pragma autonomous_transaction?
What is the purpose of using ifnull() function?
Describe mysql transaction properties.
How do I backup mysql database on linux?
what is the difference between gui testing and database testing? : Mysql dba
How do you use auto increment?
How can we run batch mode in mysql?
Is mysql relational?
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
How to get a version of mysql?
What are the steps required to view your mysql database?
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