Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 26229 Views
- I also Faced
- E-Mail Answers
Answer Posted / shital
Delete - delete all the data from table but structure still remains as it is.
Truncate - delete all data from table but structure remains and memory still allocated for table.
Drop - delete all data as well as structure and also free the memory.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the full form of mysql?
Is mysql a distributed database?
How important is to list the column names when doing an insert?
How to extract a unit value from a date and time?
What is strict mode in mysql?
Where does mysql store data?
What is 'mysqld'?
all the queries used in sql
What is a crosstab query?
Can you tell what are various ways to create an index?
What is pdo :: fetch_assoc?
How can we change the data type of a column of a table?
What is pdo connection?
explain GROUPBY & HAVING clause with examples.
What are the differences between char and varchar?
