What are the differences between drop a table and truncate
a table?
- 10 Answers
- 24147 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudha
Truncate Table - Truncate table is the combination of Drop
and Create. It [Truncate]can drop and recreate the table.
Delete - Delete will deletes all the data in the table and
structure of the table.
| Is This Answer Correct ? | 4 Yes | 20 No |
Post New Answer View All Answers
What is row locking in mysql?
How internally data stores in MyISAM and INNODB table types?
Can you tell few best practices to be followed for optimization in sql?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
How to make a copy values from one column to another in mysql?
Can we write procedure in mysql?
What is maximum table size in mysql?
How do I run a query in mysql?
What is the size of mysql database?
What is the use of mysql_close()?
Where is mysql data stored linux?
How do I start mysql in linux?
What are the advantages of mysql?
Restore database (or database table) from backup.
Write a program using the select statement, while loop.
