What is the difference Delete and Drop ?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
What is mysql workbench used for?
what is the advantage of stored procedures, triggers and indexing in mysql
What are different types of queries?
How can we convert between Unix & MySQL timestamps?
Give the syntax of GRANT commands?
Is mysql still relevant?
how to find 2nd highest salary in random database salary of employer.....
What is mysql data directory? How to determine the location of the data directory?
Explain the storage engines in mysql?
What is the size of mysql database?
What data structure does mysql use?
In which year mysql created?