What are the differences between drop a table and truncate
a table?
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
Is mysql a relational database?
What is difference between unix timestamp and mysql timestamp?
How many rows can a mysql table hold?
Is mysql a backend?
Write a command to view mysql database table structure?
What is a blob datatype?
What is mysql and how it works?
List the different types of normalization?
What is new mysqli?
Write a query to stop mysql in unix
What are the functions of commit and rollback statements?
Is mysql same as sql?
Can you tell how to find the number of rows in a resultset using php?
How many types of indexes are there in mysql?
How do I change mysql password?