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
What is difference mysql and mysqli?
How to get current MySQL version?
What is delimiter in mysql stored procedure?
How to use sum function in where clause in mysql?
What is the difference between having and where clause in mysql? Explain
How can you increase the performance of mysql select query?
How do I install mysql?
What is select query in mysql?
What is view in mysql?
What is the use of mysql_fetch_array () function in php?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
How many primary keys can be there in a table?
Can varchar be primary key?
Why we use mongodb instead of mysql?
What happens if null values are involved in expressions?