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

What are the mysql database files stored in system ?

0 Answers  

---

What is the difference between the LIKE and REGEXP operators?

0 Answers  

---

What is the datatype for password in mysql?

0 Answers  

---

How to drop an existing view in mysql?

0 Answers  

---

Explain the difference between mysql and mysqli interfaces in PHP?

10 Answers   TCS,

---

What is row level locking in access?

0 Answers  

---

What are the functions used to encrypt and decrypt the data present in mysql?

0 Answers  

---

What is the difference between char and varchar?

0 Answers  

---

What is mysql shell?

0 Answers  

---

What are the other commands to know the structure of a table using mysql commands except explain command?

0 Answers  

---

Restore database (or database table) from backup.

0 Answers  

---

write a c++ program to add a user to mysql.the user should be permitted to only "insert" into the given database

3 Answers   Infosys, Webyog,

---