Shulou(Shulou.com)06/01 Report--

This article mainly introduces what is the difference between delete and drop. It is very detailed and has certain reference value. Friends who are interested must finish reading it.

The difference between delete and drop is that drop is mainly used to delete structures, while delete is mainly used to delete data. If we want to delete a database or table, we will use drop to delete it, such as [drop database XX].

Drop is mainly used to delete structures.

For example, delete the database: drop database XX, delete the table drop table XX. Field is also a kind of structure, can you also use drop? That's right, but we changed the table structure to alter method first. For example, to delete the information for the age field on the student table, we could write: alter table student drop age

Delete is mainly used to delete data.

For example, to delete all the information on the student table named 'Zhang San': delete from student where name=' Zhang San'. Delete is used in this case, so it can be seen that delete is often used to delete data.

These are all the contents of the difference between delete and drop. Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.