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 / kasirajan

delete command deletes the table temporarily from the database. we can get it back using the keyword ROLLBACK.
but the drop keyword deletes the table permanently from the database,we cant able to get it back...

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the functions of mysql?

920


Why is it called mysql?

900


Can mysql and mariadb coexist?

1068


What is mysql architecture?

997


What are programming functions?

929


How we get sum of column.

992


What is “i_am_a_dump” flag in mysql?

1045


How can you handle the –secure-file-priv in mysql?

923


I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

3930


why not null is not allowed at table level

2737


How is oracle different from mysql?

995


What is maximum table size in mysql?

926


What does tinyint mean?

895


How do I automate a backup in mysql?

962


How would you enter characters as hex numbers?

923