Answer Posted / 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 View All Answers
How do I download a mysql community server?
What are procedures in mysql?
What is a trigger in mysql?
Will mysql remain free?
List the different types of normalization?
What are the differences between char and nchar?
Can we store videos in mysql database?
What is the use of pdo?
How do you create a primary key?
What is the difference between sql and mysql and oracle?
I want to start and stop mysql on windows? How do I do that?
What are different types of queries?
What is orm in mysql?
What is the query to display top 20 rows?
How to drop an existing index in mysql?