What are the differences between drop a table and truncate
a table?
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
How can you take the backup and restore a mysql database using php?
What command is used to delete the data from the table without deleting the table structure?
How do I assign a variable in mysql?
How to convert character strings to numeric values?
What are the different tables present in MySQL?
How do I insert multiple rows in a table?
What is full text indexing in mysql?
How to analyze tables with 'mysqlcheck'?
What is the difference between mysql and oracle?
How to Join tables on common columns.
How can you increase the performance of mysql select query?
Describe mysql transaction properties.
What is offset limit?
What does do in mysql?
Explain the different types of constraints?