Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 25554 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
what is the procedure to configure the application of mysql?
How to convert character strings to numeric values?
What is csv?
How do I create a mysql database?
What is the use of innodb in mysql?
How to include character strings in sql statements?
Is mysql good for big data?
How to calculate the difference between two time values?
What is strict mode in mysql?
How MySQL Optimizes DISTINCT?
Is mysqli faster than mysql?
Where MyISAM table will be stored and also give their formats of storage?
How do you kill a long running query in mysql?
What do ddl, dml, and dcl stand for?
How do you select a table?
