Answer / cp

Multiversion concurrency control (abbreviated MCC or MVCC),
in the database field of computer science, is a concurrency
control method commonly used by database management systems
to provide concurrent access to the database.
MVCC provides each user connected to the database with a
"snapshot" of the database for that person to work with. Any
changes made will not be seen by other users of the database
until the transaction has been committed.

Answer / amith

Each row has two additional columns associated with it -
creation time and deletion time, but instead of storing
timestamps, MySQL stores version numbers

Is mongodb faster than mysql?

0 Answers  

---

How can we encrypt and decrypt a data presented in a table using mysql?

0 Answers  

---

Explain GRANT command in MySQL.

1 Answers  

---

What happens if null values are involved in expressions?

0 Answers  

---

How many rows can mysql handle?

0 Answers  

---

How big is a blob mysql?

0 Answers  

---

How do I check mysql version?

0 Answers  

---

Can mysql store files?

0 Answers  

---

what is JOIN? Give example & types of join?

14 Answers   iMedia, Millennium, RAM Software, Satyam,

---

How do I start mysql server?

0 Answers  

---

What is mysql and mysqli?

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  

---