Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 25928 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
What is trigger in mysql with example?
What is the difference between mysql and pdo?
How to include comments in sql statements?
What are the similarities between a function and a procedure?
How do I find users in mysql?
What are the features of mysql?
What is 'mysqldump'?
What is the use of mysqli_fetch_assoc?
How do I insert multiple rows in a table?
Where is mysql used?
what is the procedure to configure the application of mysql?
What are the advantages of myisam over innodb?
What is the difference between procedure and function in mysql?
explain GROUPBY & HAVING clause with examples.
Where MyISAM table will be stored and also give their formats of storage?
