What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?
Answer Posted / hrindows@gmail.com
DELETE TABLE is a logged operation, and every row deleted is logged. Therefore, the process is usually slow.
TRUNCATE TABLE also deletes rows in a table, but it will not log any of the rows deleted. The process is faster here in comparison. TRUNCATE TABLE can be rolled back and is functionally similar to the DELETE statement without a WHERE clause.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is mysql a free database?
write a command to view the content of the table
What is blob storage?
How to drop an existing table in mysql?
What is session variable in mysql?
can you tell how can you display the maximum salary in sql? : Mysql dba
How to create a new table by selecting rows from another table in mysql?
Why mysql is so popular?
Can you tell the difference between mysql_fetch_object and mysql_fetch_array?
What you can use regular expression for in mysql? Support your answer with an example?
What are mysql queries?
What is normalization and list the different types of normalization?
What is mysql uuid?
What is dirty read and phantom read?
How many triggers are possible in mysql?