Answer Posted / guru

1.DELETE:
- delete space allocated by mysql server and the structure of table remains same.
- used by either 'WHERE' clause or without it in mysql.
- data can be roll backed
2.TRUNCATE:
- Remove rows from mysql table but the structure of table remains same.
- The data cannot be roll backed
- can be used by only without 'WHERE' clause in mysql.
3. DROP:
- Remove whole table from mysql database.
- The data cannot be roll backed

For more details visit: http://www.phponwebsites.com/2014/01/mysql-delete-truncate-drop-difference.html

What are the security alerts while using mysql?

1034

---

How does mysql encrypt passwords?

893

---

What are the differences between innodb and myisam engines?

979

---

What are the types of index?

952

---

Why do we use pragma autonomous transaction?

915

---

How do I clear a mysql database?

955

---

Is mysqli deprecated?

958

---

How do I show users in mysql?

1061

---

What is identity in mysql?

984

---

What is max_used_connections in mysql?

949

---

Which mysql function is used to concatenate string?

1483

---

How do I create a database in mysql workbench?

870

---

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

1387

---

What is federated tables in mysql?

910

---

what are the different tables present in mysql? : Mysql dba

1017

---