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

How does mysql delete the first row of data? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Mysql deletes the first row of data: first determine the field or field combination of that row of data; then enter the relevant delete statement, the code is [DELETE FROM table name WHERE primary key = 'specific value'].

Mysql method to delete the first row of data:

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.

Thank you for reading! After reading the above, do you have a general idea of how mysql deletes the first row of data? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are 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.