Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 25469 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
Is mysql free for enterprise?
List some mysql advantages and disadvantages?
Can a table have multiple primary keys?
Is mysql a odbc?
What is regexp?
What is the use of mysql workbench?
How many rows can a mysql table hold?
What is 'mysqlshow'?
How do I start mysql in linux?
How important is to list the column names when doing an insert?
What is mysql and mysqli?
What is database migration in mysql?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
What is meant by sharding?
How to concatenate two character strings?
