mysql select 命令_mysql select语句中使用函数

实例如下：

mysql> CREATE TABLE Employee(

-> id int,

-> first_name VARCHAR(15),

-> last_name VARCHAR(15)

-> );

Query OK, 0 rows affected (0.03 sec)

向表中插入数据：

mysql> insert into Employee(id,first_name, last_name)values (1,'Jason','Martin');

Query OK, 1 row affected (0.00 sec)

mysql>

mysql> insert into Employee(id,first_name, last_name)values(2,'Alison','Mathews');

Query OK, 1 row affected (0.00 sec)

mysql>

mysql> insert into Employee(id,first_name, last_name)values(3,'James','Smith');

Query OK, 1 row affected (0.00 sec)

mysql>

mysql> insert into Employee(id,first_name, last_name)values(4,'Celia','Rice');

Query OK, 1 row affected (0.00 sec)

mysql>

mysql> insert into Employee(id,first_name, last_name)values(5,'Robert','Black');

Query OK, 1 row affected (0.00 sec)

mysql>

mysql> insert into Employee(id,first_name, last_name)values(6,'Linda', 'Green');

Query OK, 1 row affected (0.01 sec)

mysql>

mysql> insert into Employee(id,first_name, last_name)values(7,'David','Larry');

Query OK, 1 row affected (0.02 sec)

mysql>

mysql> insert into Employee(id,first_name, last_name)values(8,'James','Cat');

Query OK, 1 row affected (0.00 sec)

select语句中使用函数

mysql> SELECT concat(First_Name, " ",Last_Name) AS Name FROM Employee;

+----------------+

| Name |

+----------------+

| Jason Martin |

| Alison Mathews |

| James Smith |

| Celia Rice |

| Robert Black |

| Linda Green |

| David Larry |

| James Cat |

+----------------+

8 rows in set (0.00 sec)