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

How does triggers work in mysql?

1023


What is the latest mysql version?

1073


What is pdo :: fetch_assoc?

948


What is definer in mysql trigger?

968


Why do we use pragma autonomous transaction?

958


What are the drivers in MySQL?

1526


What is data type for image in mysql?

901


What is 'mysqlimport'?

979


Why do we need mysql?

1017


Why use mysql procedures?

1022


How do I run mysql?

1082


How to get data from mysql in php?

945


How do I flush privileges in mysql?

1057


How can I remotely connect to mysql database?

961


What does mysqli stand for?

987