MySQL总结-3

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 

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)