What are the differences between drop a table and truncate
a table?
- 10 Answers
- 23247 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How many types of indexes are there in mysql?
What is the use of mysqli_fetch_assoc?
What is not null in mysql?
How do I setup a mysql database?
What is orm in mysql?
Can mysql store files?
Where is the mysql config file?
How can you export the table as an xml file in mysql?
How to delete a table.
How do I automate a backup in mysql?
What is difference between oracle sql and mysql?
What is key in mysql?
How to calculate expressions with sql statements?
What do you mean by % and _ in the LIKE statement?
What is select query in mysql?
