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
- 1293 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 |
How we can copy one table data into another table whose name same as table but in differ database
How do I set user privileges in mysql?
What is the difference between database and table?
in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.
What is blob storage?
How to Set a root password if there is on root password.
What is pragma serially_reusable and why is it used?
How to update a root password.
What are date and time data types in mysql?
What is the maximum connection pool size?
How do you select a table?
What is the difference between mysql_fetch_array and mysql_fetch_object?
-
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)
