What are the differences between drop a table and truncate
a table?
Answer Posted / karthik
truncate means it will truncate the data, we can retrieve
it whenever we want using commit
drop - it delete the full structure as well as the data.
cant make a recovery.
Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
How do I backup mysql database on linux?
How do I connect to mysql database?
Where is mysql data stored linux?
What is mysql ndb?
How do I find my mysql username and password?
What are the advantages of myisam over innodb?
What is query design?
How to check if a record exists in a mysql database php?
What is difference between statement and preparedstatement?
How do I check mysql version?
Why do we use group by and order by function in mysql?
How to store binary data in mysql?
What is sqlyog?
What do I do if I forgot my mysql root password?
What is difference between mysqli and pdo?