Interested to Buy Any Domain ? << Click Here >> for more details...
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 the innodb in mysql?
What is the difference between the primary and unique key in mysql?
What is procedures in mysql?
Explain triggers and stored procedures?
How to convert dates to character strings?
What is the maximum size of mysql database?
How to see table's field formats or description of table .
What are the non-standard sql commands supported by 'mysql'?
How to see the create table statement of an existing table?
How do I uninstall mysql connector?
Why do we use pragma autonomous transaction?
What is difference between oracle and mysql?
What are the advantages of mysql?
How do I copy a table in mysql?
Write a query to create a database and a table?
