What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?
- 1 Answers
- 576 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 |
Why is it called mysql?
If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
What is difference between statement and preparedstatement?
How to write optimized query in mysql?
how to declare unique key in creating a table..?
Which is best pdo or mysqli?
How to validate email addresses in mysql?
What is mysqli_connect_error ()?
What is a mysql model?
What is the command used to create a database using php and mysql?
How to write query to select word java's from column employees and from emp table
-
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)
