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
- 1388 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 are the advantages of myisam over innodb?
What is 1nf 2nf 3nf?
How would you get the current date in mysql?
Print 3 highest salary
how to find 2nd highest salary in random database salary of employer.....
What is the latest mysql?
Explain the difference between mysql and mysql interfaces in php?
Can we store images in mysql database?
What is processlist in mysql?
Can you tell a way to know the number of days between the two given dates in php?
How do I switch users in mysql?
How do you login to MySql using Unix shell?
-
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)
