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 data in mysql?

840


Explain the different types of constraints?

882


How large can a mysql table be?

875


How to analyze tables with 'mysqlcheck'?

1140


Why mysql is so popular?

897


What are the security alerts while using mysql?

974


How do I start mysql from command line?

961


How do I find the database name in mysql?

891


How to convert character strings to numeric values?

1054


Is number a datatype in mysql?

892


How many columns can a table have?

850


What is append query?

860


Is postgresql better than mysql?

971


What does blob mean in mysql?

907


How do I truncate all tables in mysql?

910