What is the difference Delete and Drop ?

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


Please Help Members By Posting Answers For Below Questions

How do I start mysql client?

510


How to returns the columns and column information pertaining to the designated table.

566


Will mysql remain free?

502


What are the types of queries?

487


How do I insert an image into mysql workbench?

473






What happens if you no create privilege in a database?

552


Explain about the architecture of MYSQL?

548


What is mysqli_connect_error ()?

515


Does mysql use sql?

485


What does mysql flush privileges do?

481


What is delimiter in mysql?

472


How can you calculate the sum of any column of a table?

503


What is save point in mysql?

513


Why does mysql have so many connections?

486


How do I stop a mysql service?

500