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 / lalit samant

Where clause can de used with delete .

You can use where clause with drop or truncate

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to update info already in a table and delete a row(s) from a table.

859


Is mysql from oracle?

970


Write a query to fetch duplicate records from a table using mysql?

937


What does the file with the extension: frm, myd, and myi contain?

924


What is unsigned int in mysql?

928


I want to find out all databases starting with ‘test’, I have access to?

1156


How to increment dates by 1 in mysql?

1034


How do I restore a mysql database dump file in linux?

976


Tell us something about heap tables?

990


How many sql ddl commands are supported by 'mysql'?

1134


What storage engines are used in MySQL?

1052


In how many ways we can retrieve data in the result set of mysql using php?

1131


What is cursor in mysql?

897


How many threads can mysql handle?

975


How to run a sql statement?

1036