What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?
- 1 Answers
- 584 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 |
Can mysql scale horizontally?
What is sqlyog?
What is mysql data directory? How to determine the location of the data directory?
What is the data source name for mysql?
What is the difference between MyISAM Static and MyISAM Dynamic?
How can we run batch mode in mysql?
what is collation? how many types of installations in sql server?
Write a command to list all databases in mysql?
In which format data is stored in mysql database?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
Is mysql good for big data?
How do I restart mysql on windows?
-
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)
