sql 基礎--mysql 5 （7）

標籤：

14.進階連接表

　　使用別名

mysql> select uid as u,name as n,msg as m from pw_luck;+----+-----------+------+| u  | n         | m    |+----+-----------+------+|  0 | Wilson    |  100 ||  1 | zhangsan  |  100 ||  2 | lisi      | 1001 ||  3 | wang5     | 1001 ||  7 | zhangsan7 | 1000 ||  8 | zhangsan8 | 1000 ||  9 | zhangsan9 | 1000 || 10 | wang5     | 1000 || 11 | wang5%    | 2000 || 12 | WANG5     | 1000 || 13 | wang5     |  100 || 14 | wang5     |  100 || 15 | zhangsan7 | 1000 || 16 | zhangsan7 | 1002 || 17 | zhangsan7 | 1002 |+----+-----------+------+15 rows in set (0.03 sec)

 

sql 基礎--mysql 5 （7）