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

Mysql queries table data through commands

1. Syntax:

SELECT

Field 1, field 2. Field n

FROM

Table name AS alias

WHERE

Conditions

[GOURP BY grouping field]

[HAVING grouping query criteria]

[ORDER BY sort field]

[LIMIT [starting index], show quantity]

two。 Syntax parsing:

SELECT: keywords in query syntax

Field 1, field 2. Field n: fields in the current table

FROM: keywords in query syntax

Table name AS alias: you can have an alias for this table name

WHERE: keywords in query syntax

Criteria: filter criteria when querying

[GOURP BY grouping field]: group some fields

[HAVING grouping query condition]: it is the second filter for the results of where query.

[ORDER BY sort field]: sort some fields. Default is ascending order.

[LIMIT [starting index], display quantity]: take part of the data in the query result

3. Example:

Single condition query

Query the information of students whose scores are greater than 60.

Statement:

SELECT

Sid

Name

Sex

Score

FROM

Student as s

WHERE

Score > 60

Screenshot:

Multi-condition query

Query the information of female students whose scores are less than 60.

Statement:

SELECT

Sid

Name

Sex

Score

FROM

Student as s

WHERE

Score > 60 and sex = 0

Screenshot:

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.