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 / anubhav tiwari

1.DELETE COMMANDS: ONLY DELETE DATA FROM TABLE NOT THE
STRUCTURE OF THE TABLE.DATA CAN BE CALL BACK USING ROLL
BACK.


2.DROP COMMANDS DLETE TABLE AND STRUCTURE BOTH FROM THE
DATABASE ie.DATA CANT BE ROLL BACK OVER HERE.

Is This Answer Correct ?    21 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

1023


Is mysql a server or database?

943


What is a table schema?

1044


Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

995


What does mysql_query return?

1108


Explain Access Control Lists.

1038


How do I start mysql manually?

972


How to see table's field formats or description of table .

936


What is the difference between b-tree and hash indexes?

1057


Can mysql handle big data?

1013


How do I drop a database in mysql?

1171


Why use stored procedures in mysql?

1029


How you can create a trigger in mysql?

1057


Where is the myisam table stored?

1007


What is max connections in mysql?

994