What are the differences between drop a table and truncate
a table?
- 10 Answers
- 24210 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
Can mysql function return a table?
How to execute mysql query in php?
How to get current MySQL version?
Can we use mysql and mysqli together?
Where is mysql data stored linux?
In which year mysql created?
What is tee command in mysql?
What are the functions used to encrypt and decrypt the data present in mysql?
How do I quit mysql?
What is strict mode in mysql?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
Why does mysql have so many connections?
What is an example of a delimiter?
Is mysql free download?
Why use stored procedures in mysql?
