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 |
Why mongodb is faster than mysql?
How we can copy one table data into another table whose name same as table but in differ database
What is bigint in mysql?
Can python connect to mysql?
How do I start mysql server?
Why mysql is so popular?
What are the steps involved in query processing?
Is mysql and sql are same?
What is blob and clob?
What are some good ideas regarding user security in MySQL?
Why we use mysql database?
What is mysql ndb?