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

In mysql, what is joins? Explain

533


What is user in mysql?

434


How does mysql clustering work?

479


How can we run batch mode in mysql?

537


How can you validate emails using a single query?

454






how to add a new column to an existing table?

561


Do I need python for mysql?

490


how can you test for null values in a database? : Mysql dba

471


Explain the difference between mysql and mysql interfaces in php?

551


How do I insert an image into mysql workbench?

476


Can python connect to mysql?

479


How do I uninstall mysql connector?

468


What is back end and front end?

463


How do I clear the screen in mysql?

520


Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

582