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...

What is the difference Delete and Drop ?

Answer Posted / senthil d

Delete Command - Options to Delete particular record using
where clause and to delete all records. Table structure
remains. But it slower in performance as we compared with
truncate command

Drop Command - Drops the entire table from data base

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between schema and table?

916


What are the two types of queries?

967


What is the difference between char and varchar in mysql?

1117


What is mysqli procedural?

961


What is the current version of mysql?

970


all the queries used in sql

2657


What is “i_am_a_dump” flag in mysql?

1068


What is 'mysqlshow'?

1060


Is mysqli faster than mysql?

927


Is there a free mysql?

901


What is blob and text in mysql?

1172


What is schema in mysql?

895


How to filter data from a mysql database table with php?

899


Why myisam is faster than innodb?

934


How many mysql connections can handle?

893