What is the difference Delete and Drop ?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why mysql is so popular?

508


How to decrement dates by 1 in mysql?

508


What is innodb mysql?

486


What is clob in mysql

476


What is trigger in mysql?

485






How do I start mysql database?

470


What is session variable in mysql?

495


What is the difference between a heap table and temporary table?

495


What are procedures in mysql?

484


How do I set user privileges in mysql?

470


How do I edit a trigger in mysql?

479


What you can use regular expression for in mysql? Support your answer with an example?

479


What is ddl, dml, and dcl?

568


What is index length in mysql?

482


Write a query to fetch duplicate records from a table using mysql?

496