Shulou(Shulou.com)05/31 Report--

This article mainly introduces the sql sentence how to delete data, the article is very detailed, has a certain reference value, interested friends must read it!

The method of deleting data by sql statement

If we want to delete the data from the table in the database, we can use the delete statement.

The basic syntax of the DELETE statement is:

DELETE FROM WHERE...

For example, if we want to delete the record of id=10 in the user table, we can write this:

DELETE FROM user WHERE id = 10

Note:

1. If the WHERE condition does not match any records, the DELETE statement will not report an error and no records will be deleted

2. The DELETE statement without WHERE condition deletes the data of the entire table:

DELETE FROM user

At this point, all records for the entire table are deleted. Therefore, you should also be very careful when executing the DELETE statement, and it is best to use the select statement to test whether the WHERE condition filters out the desired recordset, and then delete it with DELETE.

The above is all the contents of the article "how to delete data in sql sentences". 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.