语法格式
1
| select 字段名1,字段名2... from 表名;
|
查询员工年薪
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| mysql> SELECT ename, sal*12 from emp;
+
| ename | sal*12 |
+
| SMITH | 9600.00 |
| ALLEN | 19200.00 |
| WARD | 15000.00 |
| JONES | 35700.00 |
| MARTIN | 15000.00 |
| BLAKE | 34200.00 |
| CLARK | 29400.00 |
| SCOTT | 36000.00 |
| KING | 60000.00 |
| TURNER | 18000.00 |
| ADAMS | 13200.00 |
| JAMES | 11400.00 |
| FORD | 36000.00 |
| MILLER | 15600.00 |
+
|
给查询结果的列重命名
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| mysql> SELECT ename, sal*12 AS yearsal FROM emp;
+
| ename | yearsal |
+
| SMITH | 9600.00 |
| ALLEN | 19200.00 |
| WARD | 15000.00 |
| JONES | 35700.00 |
| MARTIN | 15000.00 |
| BLAKE | 34200.00 |
| CLARK | 29400.00 |
| SCOTT | 36000.00 |
| KING | 60000.00 |
| TURNER | 18000.00 |
| ADAMS | 13200.00 |
| JAMES | 11400.00 |
| FORD | 36000.00 |
| MILLER | 15600.00 |
+
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| mysql> SELECT ename, sal*12 AS '年薪' FROM emp;
+
| ename | 年薪 |
+
| SMITH | 9600.00 |
| ALLEN | 19200.00 |
| WARD | 15000.00 |
| JONES | 35700.00 |
| MARTIN | 15000.00 |
| BLAKE | 34200.00 |
| CLARK | 29400.00 |
| SCOTT | 36000.00 |
| KING | 60000.00 |
| TURNER | 18000.00 |
| ADAMS | 13200.00 |
| JAMES | 11400.00 |
| FORD | 36000.00 |
| MILLER | 15600.00 |
+
|
标准sql语句中字符串最好使用单引号括起，MySQL虽然支持双引号
