MySQL从数据表中查询数据的基本语句为SELECT语句，其基本格式为：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
SELECT
{* | <字段列表>}
[
FROM
<表1>,<表2>...
[
WHERE
表达式
[
GROUP
BY
<
group
by
definition>]
[
HAVING
<expression> [{<operator> <expression>}...]]
[
ORDER
BY
<
order
by
definition>]
[LIMIT [<offset>,] <row
count
> ]
]
]
SELECT
[字段1,字段2,...,字段n]
|
