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

Today, what the editor shares with you is the writing of the delete sentence. I believe many people do not understand it very well. In order to let you know more about the delete sentence, I have summarized the following contents for you. Let's look down together. I'm sure you'll get something.

How to write the delete statement?

DELETE statement

The DELETE statement is used to delete rows from a table.

Grammar

DELETE FROM table name WHERE column name = value

Delete a row

"Fred Wilson" will be deleted:

DELETE FROM Person WHERE LastName = 'Wilson'

Delete all rows

You can delete all rows without deleting the table. This means that the structure, properties, and indexes of the table are complete:

DELETE FROM table_name

Or:

DELETE * FROM table_name

On the writing of delete sentences to share here, I hope that the above content can have a certain reference value, you can learn to apply. If you like this article, you might as well share it for more people to see.

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.