MySQL总结-3
1、连接mysql -u username -ppassword -P 3306 -D database -hip
2、列显示:"\G"
[*]mysql> select * from HUMMOCK_BLACK_LIST limit 1 \G;
[*]*************************** 1. row ***************************
[*] id: 483222
[*] version: 2
[*] app_name: gxw
[*] type: 128
[*] name: ip
[*] value: 1.1.9.98
[*] status: 0
[*] punish_status: 1
[*] punish_mode: 509
[*] available_begin: 2011-03-15 14:50:25
[*] available_end: 2011-03-15 14:52:05
[*] attack_begin: 2011-03-15 14:50:24
[*] access_num: 1
[*] block_num: 0
[*] speed: 0.01
[*] gmt_modified: 2011-03-15 14:59:58
[*] gmt_created: 2011-03-15 14:50:25
[*] server_name: LoadTest
[*]gmt_modified_microsecond: 1300172398493
3、去重操作:distinct
[*]mysql> select distinctserver_name from HUMMOCK_BLACK_LIST limit 10;
[*]+-------------+
[*]| server_name |
[*]+-------------+
[*]| LoadTest |
[*]| localhost |
[*]| QA-TEST-2 |
[*]| DEV |
[*]| A-QA-TEST |
[*]| B-QA-TEST |
[*]| ????? |
[*]| online-test |
[*]+-------------+
[*]8 rows in set (2.30 sec)
页:
[1]