What is the difference Delete and Drop ?

Answers were Sorted based on User's Feedback



What is the difference Delete and Drop ?..

Answer / sunil kumar

Delete command deletes the data from the table.
Drop command destroy,drop columns,tables.

Is This Answer Correct ?    25 Yes 0 No

What is the difference Delete and Drop ?..

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

What is the difference Delete and Drop ?..

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

What is the difference Delete and Drop ?..

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

What is the difference Delete and Drop ?..

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

What is the difference Delete and Drop ?..

Answer / reddi prasad

THE MAIN DIFFERENCE BETWEEN DELETE AND DROP:

DELETE: ONCE WE DELETE ANY DATA FROM THE DATABASE WE CAN
EASILY RETURN BACK THE DATA BY USING ROLLBACK.

DROP: ONCE WE DELETE ANY DATA FROM THE DATABASE WE CAN'T EA
RETURN BACK THE DATA AND WE CAN SEE THE STRUCTURE OF OBJECT
ONLY.

Is This Answer Correct ?    9 Yes 15 No

Post New Answer

More MySQL Interview Questions

What is mysql workbench used for?

0 Answers  


what is the advantage of stored procedures, triggers and indexing in mysql

1 Answers  


What are different types of queries?

0 Answers  


How can we convert between Unix & MySQL timestamps?

0 Answers  


Give the syntax of GRANT commands?

3 Answers  






Is mysql still relevant?

0 Answers  


how to find 2nd highest salary in random database salary of employer.....

4 Answers  


What is mysql data directory? How to determine the location of the data directory?

0 Answers  


Explain the storage engines in mysql?

0 Answers  


What is the size of mysql database?

0 Answers  


What data structure does mysql use?

0 Answers  


In which year mysql created?

0 Answers  


Categories