Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?
- 1 Answers
- 1450 Views
- I also Faced
- E-Mail Answers
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
How to connect html form to mysql database using php?
What are the different mysql database engines?
How many entries can mysql handle?
How to delete an existing column in a table?
How do I download mysql on my laptop?
What are the steps required to view your mysql database?
What is meant by decimal (5,2)?
Do I need python for mysql?
Is mysql an oracle product?
How do I start mysql in mysql workbench?
What is the query to display top 20 rows?
How do I restore a mysql database dump file in linux?
What is a blob datatype?
how to display nth highest salary from a table in a mysql query? : Mysql dba
How do I install mysql on windows 10 64 bit?
