What are the differences between drop a table and truncate
a table?
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
What is max connection in mysql?
List data types in mysql? Explain
Is mysql relational database?
How to update a root password.
How many columns can a table have?
How do you concatenate strings in mysql?
What is a data directory?
How to create a test table in your mysql server?
What is the use of innodb in mysql?
What is the use of mysqli_query?
How do I restore a database in mysql workbench?
Explain % and _ inside like statement?
How to shutdown mysql server?
What is dirty read and phantom read?
What is max_used_connections in mysql?