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

This article mainly introduces mysql data query method, the text is very detailed, has a certain reference value, interested friends must read!

First we create a data table students, this operation is based on this data table, this data table data is as follows:

query record

select distinguish field 1, field 2 from table name;

Of which:

Field: refers to the field to be queried, such as id or age in the data table;

Table name: is the data table we operate on, such as my operation is the table students;

As long as there is a difference between field 1 and field 2, any field will be selected, generally used for distinct, only one field will be filtered;

At the same time, this statement can also be used to query under certain conditions. Conditional query comparison symbols: =,,>=,

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.