How to use mysql distinct

In mysql, the distinct keyword is used to filter duplicate data. It can filter duplicate data in one or more fields in the data table and only return one piece of data to the user; the distinct keyword needs to be Used together with the SELECT statement, the syntax is "SELECT DISTINCT column1, column2, ... FROM table_name;".

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

When using the SELECT statement to perform a simple data query in MySQL, all matching records are returned. If some fields in a table do not have unique constraints, duplicate values ​​may exist in these fields. In order to query unique data, MySQL provides the DISTINCT keyword.

The main function of the DISTINCT keyword is to filter duplicate data in one or more fields in the data table, and only return one piece of data to the user.

The syntax format of the DISTINCT keyword is:

SELECT DISTINCT column1, column2, ...
FROM table_name;

where "column" is the name of one or more fields that need to eliminate duplicate records , separate multiple fields with commas.

You need to pay attention to the following points when using the DISTINCT keyword:

• The DISTINCT keyword can only be used in a SELECT statement.

• When deduplicating one or more fields, the DISTINCT keyword must be at the front of all fields.

• If there are multiple fields after the DISTINCT keyword, the multiple fields will be combined and deduplicated. That is to say, only when the combination of multiple fields is exactly the same. will be deduplicated.

Demo Database

The following is a selection of the "Customers" table in the Northwind sample database:

No SELECT instance using DISTINCT

The following SQL statement selects ALL (including duplicates) values ​​from the "Country" column in the "Customers" table:

SELECT Country FROM Customers;

##SELECT DISTINCT instance

SELECT DISTINCT Country FROM Customers;

SELECT COUNT(DISTINCT Country) FROM Customers;

mysql video tutorial]

The above is the detailed content of How to use mysql distinct. For more information, please follow other related articles on the PHP Chinese website!