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

Editor to share with you how to delete a line of sql, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

In SQL, you can delete a row of data through the DELETE method, using syntax such as "delete from ms_cf01 where brxm=' Zhang San 'and id='7598';", where "ms_cf01" indicates the table to which the data belongs.

First of all, you need to determine which fields or combinations of fields can uniquely determine your row of data.

DELETE FROM table name WHERE field 1 =''and field 2 =' 'and. Field 1. In order to uniquely determine the field combination of a row of data, fill in the specific value of the field you want to delete in''.

If you have a primary key, you can just use the primary key to determine a row.

DELETE FROM table name WHERE primary key = 'specific value'.

Delete from ms_cf01 where brxm=' Zhang San 'and id='7598'

Where: ms_cf01 is the table to which you want to delete the data.

Brxm,id is the condition for the data you want to delete.

The effect of the above statement is to delete the row data in the table ms_cf01 where brxm equals Zhang San and id equals 7598.

The above is all the content of the article "how to delete a line by sql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more 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.