What are the differences between drop a table and truncate
a table?
- 10 Answers
- 24161 Views
- I also Faced
- E-Mail Answers
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
Where is mysql installed on linux?
What is regex in mysql?
How Switch (select or use) to a database.
What is the difference between mysql and oracle?
How do I use mysql?
write a query to mysql in safe mode and to change the root password
Will mysql remain free?
How to Join tables on common columns.
How to use sum function in where clause in mysql?
How to make a column bigger and delete unique from table.
What is mysql aggregate functions? Explain
What happens if you no create privilege in a database?
How to dump one database for backup.
How can I create database in mysql?
How many columns can you create for an index?
