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

This article mainly explains the basic syntax of SELECT query in MySQL. The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn the basic syntax of SELECT query in MySQL.

Basic syntax of SELECT query

Select * from table name

The table name is written after the from keyword, indicating that the data comes from this table.

Write the name of the column in the table after select. If it is *, it shows all the columns in the table in the result.

In the column names section after select, you can use as to list aliases that appear in the result set

If you want to query multiple columns, separate them with commas

Eliminate duplicate lines

Use distinct before the column after select to eliminate duplicate rows

Select distinct gender from students

Conditions

Use the where clause to filter the data in the table, and the row with the result of true appears in the result set

The syntax is as follows:

Select * from table name where condition

Comparison operator

Equal to =

Greater than >

Greater than or equal to > =

Less than

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.