Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 25468 Views
- I also Faced
- E-Mail Answers
Answer Posted / shital
Delete - delete all the data from table but structure still remains as it is.
Truncate - delete all data from table but structure remains and memory still allocated for table.
Drop - delete all data as well as structure and also free the memory.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you name a table?
Restore database (or database table) from backup.
What is difference between inner vs self vs cross?
What is innodb mysql?
What does the file with the extension: frm, myd, and myi contain?
What is data type for image in mysql?
What is the latest mysql version?
Describe mysql transaction properties.
Explain triggers and stored procedures?
What is meant by mysqli?
What is a heap table?
What tools available for managing mysql server?
How do I remove a user from mysql?
What is deterministic in mysql?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
