MySQL总结-3

1、连接

 mysql -u username -ppassword -P 3306 -D database -hip

2、列显示:"\G"

1. mysql> select * from HUMMOCK_BLACK_LIST limit 1 \G; 
2. *************************** 1. row *************************** 
3.                       id: 483222 
4.                  version: 2 
5.                 app_name: gxw 
6.                     type: 128 
7.                     name: ip 
8.                    value: 1.1.9.98 
9.                   status: 0 
10.            punish_status: 1 
11.              punish_mode: 509 
12.          available_begin: 2011-03-15 14:50:25 
13.            available_end: 2011-03-15 14:52:05 
14.             attack_begin: 2011-03-15 14:50:24 
15.               access_num: 1 
16.                block_num: 0 
17.                    speed: 0.01 
18.             gmt_modified: 2011-03-15 14:59:58 
19.              gmt_created: 2011-03-15 14:50:25 
20.              server_name: LoadTest 
21. gmt_modified_microsecond: 1300172398493 

 3、去重操作:distinct  

1. mysql> select distinct  server_name from HUMMOCK_BLACK_LIST limit 10; 
2. +-------------+ 
3. | server_name | 
4. +-------------+ 
5. | LoadTest    |  
6. | localhost   |  
7. | QA-TEST-2   |  
8. | DEV         |  
9. | A-QA-TEST   |  
10. | B-QA-TEST   |  
11. | ?????       |  
12. | online-test |  
13. +-------------+ 
14. 8 rows in set (2.30 sec) 

 本文转自 tianya23 51CTO博客，原文链接：http://blog.51cto.com/tianya23/676727，如需转载请自行联系原作者