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

How to display odd rows in student table in mysql?

463


What is delimiter in mysql trigger?

525


How can you create and drop view in mysql?

505


What is int mysql?

515


How do you kill a long running query in mysql?

461






What are the mysql database files stored in system ?

504


Why do we use mysql?

482


Which is best pdo or mysqli?

476


Is mysql written in c?

484


How can I create database in mysql?

493


How do I run mysql?

489


How to upload a large file through phpmyadmin in mysql?

426


How do I start mysql server?

469


What is trigger in mysql with example?

490


What are the different mysql database engines?

529