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 distinct server_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)