Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 26230 Views
- I also Faced
- E-Mail Answers
Answer Posted / meena bisht
Drop: drop means it will drop the table including structure
and free the memory from hard disk.
Truncate: Truncate will truncate the data. The structure
will remain there and also will free the memory.
| Is This Answer Correct ? | 33 Yes | 4 No |
Post New Answer View All Answers
Does mysql scale well?
What is difference between schema and table?
What is the role of a limit in a mysql query?
How can you plan the logshipping before processing?
Why do we need mysql?
How do I grant privileges to a user in mysql phpmyadmin?
In how many ways we can retrieve data in the result set of mysql using php?
Where is mysql used?
How to create table show example
What is mysql community edition?
Where is the myisam table stored?
Write a query to fetch duplicate records from a table using mysql?
List some mysql advantages and disadvantages?
What are the other commands to know the structure of a table using mysql commands except explain command?
What is a left join mysql?
