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
- 1348 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 timestamp and datetime in mysql?
What are the different column comparison operators in mysql?
What is the date format in mysql?
How do I delete a mysql user?
What is the difference between BLOB AND TEXT?
How to filter data from a mysql database table with php?
How can we convert between Unix & MySQL timestamps?
about foregine
How do I copy an entire mysql database?
What is blob storage?
What is the phantom problem?
How to enter boolean values in sql statements?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
