Answer / Sakla Mardi

'Phantom problem' refers to an issue in database systems that occurs when deleting records, causing non-deleted records to appear as if they were deleted. This can happen during an update or join operation where newly inserted rows between the start and end cursor are mistakenly not included.

Explain the difference between delete and truncate.

1 Answers  

---

Is mysql query case sensitive?

1 Answers  

---

Why is it called mysql?

1 Answers  

---

What are the difference between and myisam and innodb?

1 Answers  

---

Can mysql store files?

1 Answers  

---

Write command to import an mysql file?

1 Answers  

---

How to use rank function in mysql?

1 Answers  

---

How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

1 Answers  

---

How to dump a table to a file with 'mysqldump'?

1 Answers  

---

What is the use of innodb in mysql?

1 Answers  

---

What is default password for mysql?

1 Answers  

---

how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

1 Answers  

---