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

The editor will share with you how MySQL deletes a row from the table. I hope you will gain a lot after reading this article. Let's discuss it together.

How to delete a row of data in a table in a Sql statement? generally, you only need to add a condition to delete a row.

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.

This completes the data operation to delete a row.

After reading this article, I believe you have a certain understanding of how MySQL deletes a row in the table. You want to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

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.