What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?
- 1 Answers
- 557 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 |
What is the difference between mysql_connect and mysqli_connect?
What is the difference between myisam dynamic and myisam static in mysql?
How much does mysql cost?
How do we delete a row in a table?
How database are managed?
How to see table's field formats or description of table .
How to drop an existing index in mysql?
What is blob and text in mysql?
Is mysql good for large database?
What language is mysql written in?
What is a deterministic function?
What is row level locking in mysql?
-
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)
