What is the difference Delete and Drop ?

Answer Posted / 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

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What ascii 31?

510


What does mysqli_fetch_assoc do?

483


How to use rank function in mysql?

470


What is required to create mysql database?

515


How to display odd rows in student table in mysql?

459






What is regex in mysql?

527


Can I use mariadb instead of mysql?

484


How can I insert images into a Mysql database?

555


In how many ways we can retrieve data in the result set of mysql using php?

608


Does mysql automatically index foreign keys?

483


Where is the mysql config file?

457


How do I exit mysql?

497


How do you concatenate strings in mysql?

520


What is the difference between the LIKE and REGEXP operators?

529


What is the insert?

485