Answer / sunil kumar

Delete command deletes the data from the table.
Drop command destroy,drop columns,tables.

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.

Answer / lalit samant

Where clause can de used with delete .

You can use where clause with drop or truncate

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

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...

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.

What happens if a table has one column defined as TIMESTAMP?

1 Answers  

What is the difference between primary key and candidate key?

0 Answers  

how to delete duplicate rows in sql server 2005?

2 Answers   EWIT, Reliance,

Is mysqli faster than mysql?

0 Answers  

What are the ways in which you can retrieve data in the result set of mysql using php?

0 Answers  

What are the drivers in MySQL?

1 Answers  

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

0 Answers  

how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me

6 Answers  

What does schema mean?

0 Answers  

How do you stop an access query?

0 Answers  

How to load data files into tables with 'mysqlimport'?

0 Answers  

Can mysql handle big data?

0 Answers