Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?

Question Posted / hrindows@gmail.com


What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?..

Answer / hrindows@gmail.com

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

Post New Answer

More MySQL Interview Questions

What is index length in mysql?

0 Answers  

What happens if you no create privilege in a database?

0 Answers  

What is mysql url?

0 Answers  

How does triggers work in mysql?

0 Answers  

What does mysql_fetch_assoc do?

0 Answers  

What is the use of mysqli_query?

0 Answers  

Does mysql use tcp or udp?

0 Answers  

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

4 Answers   Aufait, CSS, Wipro,

What does tinyint mean?

0 Answers  

How do I change mysql password?

0 Answers  

What are the different mysql database engines?

0 Answers  

What is memory table?

0 Answers  

For more MySQL Interview Questions Click Here
Categories