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

What is the difference Delete and Drop ?

Question Posted / sunil kumar

Answer Posted / sunil kumar

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

Is This Answer Correct ?

25 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is mysqlcommand?

1007

Where is the mysql data directory?

948

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

925

Which is faster mongodb or mysql?

900

What does mysqli stand for?

942

How to convert dates to character strings?

1081

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

1022

what is database black box testing? : Mysql dba

1122

How do I rename a table in mysql workbench?

966

How to create a trigger in mysql?

940

In which format data is stored in mysql database?

1001

What are the differences between mysql vs sql server?

1063

How to drop an existing index in mysql?

1110

What is blob storage?

989

what is the difference between gui testing and database testing? : Mysql dba

1100