mysql查询语句详解_mysql常用命令详解大全(二)之mysql查询语句select

1、查询语句(mysql更能最强的语句)

mysql> select author_id from authors;

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

| author_id |

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

| 1 |

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

1 row in set (0.00 sec)

mysql> select author_last from authors;

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

| author_last |

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

| Greene |

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

1 row in set (0.00 sec)

mysql> select * from authors;

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

| author_id | author_last | author_first | country |

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

| 1 | Greene | Graham | United Kingdom |

| 2 | summer | andy | chine |

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

2 rows in set (0.00 sec)

*是通配符，表示选择了所用的列，你也可以选择指定的列，在select 后面列出你写选择的列，并用逗号隔开。

使用where 可以选择指定的行。

更复杂的双表查询语句

mysql> select book_id,title,pub_year,

-> concat(author_first,' ',author_last) as author

-> from books

-> join authors using (author_id)

-> where author_last='Greene';

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

| book_id | title | pub_year | author |

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

| 1 | The End of the Affair | 1951 | Graham Greene |

+---------+-----------------------+----------+---------------+concat字符串连接函数，将concat所有的字符串连接起来作为一个字符串

as 根据我们指定的名称创建列标题，我们称这个列标题为别名。