What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?
- 1 Answers
- 585 Views
- I also Faced
- E-Mail Answers
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 |
Is mysql workbench a dbms?
What is pragma serially_reusable and why is it used?
How to enter microseconds in sql statements?
What are the functions of mysql?
What are procedures in mysql?
What is dbms in mysql?
How can we get the number of rows affected by query?
How do you prevent MySQL from caching a query?
What's the latest version of mysql?
What is the maximum length of a table name, database name, and fieldname in MySQL?
3 Answers Accenture, Pioneer, TISL,
How do I make an action query?
What are the differences between binary and varbinary?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
