What are the differences between drop a table and truncate
a table?
Answer Posted / velmurugan
Drop - will Delete the table date as well as the table
structure.
Truncate - Will Delete the table data only. The table
structure will remains.
| Is This Answer Correct ? | 71 Yes | 9 No |
Post New Answer View All Answers
Is mysql and sql are same?
What are the steps required to view your mysql database?
What is root password?
What is view in mysql?
What is mysql database used for?
What is ISAM?
What is mysql port?
Does facebook still use mysql?
How do I connect to mysql database?
What is mysql connection limit?
How internally data stores in MyISAM and INNODB table types?
What is mysql architecture?
How do you determine the location of mysql data directory?
Explain the difference between procedure and function in mysql?
Can mysql handle billions of records?