Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 25962 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 I switch users in mysql?
Write a query to display even rows in student table using mysql?
What are the types of database engines available in mysql?
How do I change the max connections in mysql?
How many rows mysql can handle?
What data structure does mysql use?
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
What is pdo mysql?
Why phpmyadmin is used for mysql?
How to delete a trigger in mysql?
What is difference between microsoft sql and mysql?
What is row level locking in mysql?
How to run a sql statement?
Is mysql a good database?
What is the difference between mysql and sql?
