Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 25937 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 are date and time functions in mysql?
What is difference between microsoft sql and mysql?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
What is a data directory?
How to create a table?
What is mysql server?
How to make a copy values from one column to another in mysql?
What is the function of myisamchk?
Where is the mysql config file?
Is mysql still relevant?
How to display odd rows in student table in mysql?
What storage engines are used in MySQL?
What is a simple query?
What is mysql routine?
What is difference between mysql and mariadb?
