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
- 1452 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 you tell how to find the number of rows in a resultset using php?
Why do we use pragma autonomous transaction?
What is mysqladmin flush hosts?
How to return query output in xml format?
How can I insert images into a Mysql database?
How can I see connections in mysql?
Can you shard mysql?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
How to convert numeric values to character strings?
Explain what is mysql?
ru compare the 2 null values?
What is pragma autonomous_transaction?
-
Oracle (3253) - 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)
