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
What is query design?
How to convert character strings to dates?
What are mysql functions?
How would concatenate strings in mysql?
How do you rename a table in mysql?
Write a query to display current date and time?
Is mysql is a programming language?
Can we store images in mysql database?
Where’s database data actually stored? Is there a way to see the files which are stored?
Is microsoft sql same as mysql?
How do I grant privileges to a user in mysql phpmyadmin?
How can I connect mysql database?
What command is used to delete the data from the table without deleting the table structure?
How to use regular expression in pattern match conditions?
Why is mysql popular?