Practical method of deleting a row in a MySql table

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

DELETE FROM table name WHERE field1 = '' and field2 = '' and ...field1, ... are the field combinations that can uniquely identify a row of data. Fill in the field you want to

The specific value of the deleted field can be

If there is a primary key, you can directly use the primary key to identify a row.

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

delete from ms_cf01 where brxm='张三' and id='7598';

Among them: ms_cf01 is the table to which the data you want to delete belongs.

brxm, id is the condition for deleting data.

The above statement achieves the following effect: delete the row data in table ms_cf01 where brxm is equal to Zhang San and id is equal to 7598.

This completes the operation of deleting a row of data.