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
If we use sum function in mysql, does it return sum of that row or for that column?
What is myisam?
How to calculate expressions with sql statements?
How we get sum of column.
What are enums used for in mysql?
How do I run mysql on a mac?
Why mysql is used with php?
List data types in mysql? Explain
How to get last inserted id after insert data from a table in mysql?
What is innodb_buffer_pool_size?
Is mariadb better than mysql?
What are features of mysql?
What is processlist in mysql?
how to display nth highest salary from a table in a mysql query? : Mysql dba
What is data types in mysql?