{"id":682,"date":"2016-10-09T16:39:17","date_gmt":"2016-10-09T16:39:17","guid":{"rendered":"https:\/\/peloo.net\/?p=682"},"modified":"2018-07-01T13:36:13","modified_gmt":"2018-07-01T13:36:13","slug":"682","status":"publish","type":"post","link":"https:\/\/peloo.net\/?p=682","title":{"rendered":"AWK\u9ad8\u7ea7\u7528\u6cd5\u4e4b\u6253\u5370\u5339\u914d\u884c\u7684\u4e0a\u4e00\u884c"},"content":{"rendered":"

\n\t\"\"<\/a><\/span><\/span>\n<\/p>\n

\n\t \n<\/p>\n

\n\t \n<\/p>\n

\n\t\u6700\u8fd1\u5bf9\u6570\u636e\u5904\u7406\u5f88\u611f\u5174\u8da3\uff0c\u4e00\u76f4\u5728\u7814\u7a76Linux\u4e09\u5251\u5ba2\uff1agrep AWK sed \uff0c\u4e0b\u9762\u4e3e\u4e2a\u5b9e\u9645\u5de5\u4f5c\u4e2d\u9047\u5230\u7684\u4e00\u4e2a\u5c0f\u5b9e\u4f8b\uff0c\u8054\u7528\u4e09\u5927\u6587\u672c\u5904\u7406\u5251\u5ba2\u3002<\/span><\/span>\n<\/p>\n

\n\t \n<\/p>\n

\n\t\u5df2\u77e5table.txt\u6587\u4ef6\uff0ccat\u67e5\u770b\u6587\u4ef6\u5185\u5bb9\u5982\u4e0b\uff0c\u5176\u5b9e\u4e5f\u5c31\u662f\u6211\u67e5\u8be2\u6570\u636e\u5e93\u4e2d\u90e8\u5206\u8868\u7684\u72b6\u6001\u3002<\/span><\/span>\n<\/p>\n

\n\t \n<\/p>\n

\n\t[pc@glusterfs-srv-01 ~]$ cat table.txt  
\n\t*************************** 15. row ***************************
\n\t           Name: procs_priv
\n\t         Engine: MyISAM
\n\t        Version: 10
\n\t     Row_format: Fixed
\n\t           Rows: 0
\n\t Avg_row_length: 0
\n\t    Data_length: 0
\n\tMax_data_length: 239253730204057599
\n\t   Index_length: 4096
\n\t      Data_free: 0
\n\t Auto_increment: NULL
\n\t    Create_time: 2016-09-19 01:38:11
\n\t    Update_time: 2016-09-19 01:38:11
\n\t     Check_time: NULL
\n\t      Collation: utf8_bin
\n\t       Checksum: NULL
\n\t Create_options:
\n\t        Comment: Procedure privileges
\n\t*************************** 16. row ***************************
\n\t           Name: proxies_priv
\n\t         Engine: MyISAM
\n\t        Version: 10
\n\t     Row_format: Fixed
\n\t           Rows: 2
\n\t Avg_row_length: 693
\n\t    Data_length: 1386
\n\tMax_data_length: 195062158860484607
\n\t   Index_length: 5120
\n\t      Data_free: 0
\n\t Auto_increment: NULL
\n\t    Create_time: 2016-09-19 01:38:11
\n\t    Update_time: 2016-09-19 01:38:11
\n\t     Check_time: 2016-09-19 01:38:11
\n\t      Collation: utf8_bin
\n\t       Checksum: NULL
\n\t Create_options:
\n\t        Comment: User proxy privileges
\n\t*************************** 17. row ***************************
\n\t           Name: servers
\n\t         Engine: MyISAM
\n\t        Version: 10
\n\t     Row_format: Fixed
\n\t           Rows: 0
\n\t Avg_row_length: 0
\n\t    Data_length: 0
\n\tMax_data_length: 433752939111120895
\n\t   Index_length: 1024
\n\t      Data_free: 0
\n\t Auto_increment: NULL
\n\t    Create_time: 2016-10-19 01:38:11
\n\t    Update_time: 2016-09-19 01:38:11
\n\t     Check_time: NULL
\n\t      Collation: utf8_general_ci
\n\t       Checksum: NULL
\n\t Create_options:
\n\t        Comment: MySQL Foreign Servers table
\n\t*************************** 18. row ***************************
\n\t           Name: slave_master_info
\n\t         Engine: InnoDB
\n\t        Version: 10
\n\t     Row_format: Compact
\n\t           Rows: 0
\n\t Avg_row_length: 0
\n\t    Data_length: 16384
\n\tMax_data_length: 0
\n\t   Index_length: 0
\n\t      Data_free: 0
\n\t Auto_increment: NULL
\n\t    Create_time: 2016-03-19 01:38:15
\n\t    Update_time: NULL
\n\t     Check_time: NULL
\n\t      Collation: utf8_general_ci
\n\t       Checksum: NULL
\n\t Create_options: stats_persistent=0
\n\t        Comment: Master Information
\n\t*************************** 19. row ***************************
\n\t           Name: slave_relay_log_info
\n\t         Engine: InnoDB
\n\t        Version: 10
\n\t     Row_format: Compact
\n\t           Rows: 0
\n\t Avg_row_length: 0
\n\t    Data_length: 16384
\n\tMax_data_length: 0
\n\t   Index_length: 0
\n\t      Data_free: 0
\n\t Auto_increment: NULL
\n\t    Create_time: 2016-04-19 01:38:15
\n\t    Update_time: NULL
\n\t     Check_time: NULL
\n\t      Collation: utf8_general_ci
\n\t       Checksum: NULL
\n\t Create_options: stats_persistent=0
\n\t        Comment: Relay Log Information<\/span><\/span>
\n\t \n<\/p>\n

\n\t \n<\/p>\n

\n\t\u8981\u6c42\uff1a \u6253\u5370\u51fa\u57282016\u5e748\u6708\u4efd\u4e4b\u540e\u521b\u5efa\u7684\u6570\u636e\u5e93\u8868\u540d<\/strong><\/span><\/span>\n<\/p>\n

\n\t \n<\/p>\n

\n\t\u7b54\u6848\uff1a cat table.txt  | awk 'NF' | grep -iE 'name|create_time' | awk -F':' '{ print $2}' | sed  -e 's\/^[[:space:]]\/\/’ | awk -F- ‘\/^[[:alpha:]]\/ {a=$0;next} {if ($2>7) print a}'<\/span><\/strong><\/span><\/span>
\n\t \n<\/p>\n

\n\tshell\u4e0b\u8fd0\u884c\u7ed3\u679c\u5982\u4e0b\uff0c<\/span><\/span>\n<\/p>\n

\n\t\"\"<\/span><\/span>\n<\/p>\n

\n\t \n<\/p>\n

\n\t\u4e0a\u9762\u7684\u547d\u4ee4\u4ee5“|”\u7b26\u53f7\u4e3a\u5206\u5272\uff0c\u6ce8\u89e3\u5982\u4e0b\uff1a<\/span><\/span>\n<\/p>\n

\n\t1  \u67e5\u770btable.txt\u5185\u5bb9<\/span><\/span>\n<\/p>\n

\n\t2  \u53bb\u9664\u7a7a\u884c\uff0c\u8fd9\u4e2a\u4e5f\u662fAWK\u7684\u4e00\u5c0f\u6280\u5de7<\/span><\/span>\n<\/p>\n

\n\t3  \u641c\u7d22\u51fa\u5305\u542bname\u6216create_time\u5b57\u6bb5\u7684\u884c<\/span><\/span>\n<\/p>\n

\n\t4  \u4ee5\u7b26\u53f7“:”\u4e3a\u5206\u9694\u7b26\uff0c\u6253\u5370\u7b2c\u4e8c\u4e2a\u5b57\u6bb5<\/span><\/span>\n<\/p>\n

\n\t5  \u53bb\u9664\u6bcf\u884c\u5f00\u5934\u7684\u7a7a\u683c<\/span><\/span>\n<\/p>\n

\n\t6  \u8fd9\u90e8\u5206\u4e5f\u662f\u6700\u5173\u952e\u7684\u547d\u4ee4\uff0c\u610f\u601d\u662f\u641c\u7d22\u5230\u4ee5\u5b57\u6bcd\u5f00\u5934\u7684\u884c\u540e\uff0c\u628a\u6574\u884c\u5185\u5bb9\u8d4b\u503c\u4fdd\u5b58\u5230\u53d8\u91cfa\u4e2d\uff0c\u5e76\u4e14\u4ee5\u5b57\u7b26“-”\u4e3a\u5206\u5272\uff0c\u8df3\u5230\u4e0b\u4e00\u884c\u5904\u7406\uff0c\u5982\u679c\u8fd9\u884c\u7684\u7b2c\u4e8c\u4e2a\u5b57\u6bb5\u503c\u5927\u4e8e7\uff0c\u5219\u6253\u5370\u53d8\u91cfa\u7684\u5185\u5bb9\uff0c\u5373\u662f\u4e0a\u4e00\u884c\u7684\u5185\u5bb9\u3002<\/span><\/span>\n<\/p>\n

\n\t \n<\/p>\n

\n\t <\/p>\n","protected":false},"excerpt":{"rendered":"

    \u6700\u8fd1\u5bf9\u6570\u636e\u5904\u7406\u5f88\u611f\u5174\u8da3\uff0c\u4e00\u76f4\u5728\u7814\u7a76Linux\u4e09\u5251\u5ba2\uff1agrep AWK sed \uff0c\u4e0b\u9762\u4e3e\u4e2a\u5b9e\u9645\u5de5\u4f5c\u4e2d\u9047\u5230\u7684\u4e00\u4e2a\u5c0f\u5b9e\u4f8b\uff0c\u8054\u7528\u4e09\u5927\u6587\u672c\u5904\u7406\u5251\u5ba2\u3002   \u5df2\u77e5table.txt\u6587\u4ef6\uff0ccat\u67e5\u770b\u6587\u4ef6\u5185\u5bb9\u5982\u4e0b\uff0c\u5176\u5b9e\u4e5f\u5c31\u662f\u6211\u67e5\u8be2\u6570\u636e\u5e93\u4e2d\u90e8\u5206\u8868\u7684\u72b6\u6001\u3002   [pc@glusterfs-srv-01 ~]$ cat table.txt   *************************** 15. row ***************************            Name: procs_priv          Engine: MyISAM         Version: 10      Row_format: Fixed            Rows: 0  Avg_row_length: 0     Data_length: 0 Max_data_length: 239253730204057599    Index_length: 4096       Data_free: 0  Auto_increment: NULL     Create_time: 2016-09-19 01:38:11     Update_time: 2016-09-19…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/peloo.net\/index.php?rest_route=\/wp\/v2\/posts\/682"}],"collection":[{"href":"https:\/\/peloo.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/peloo.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/peloo.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/peloo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=682"}],"version-history":[{"count":5,"href":"https:\/\/peloo.net\/index.php?rest_route=\/wp\/v2\/posts\/682\/revisions"}],"predecessor-version":[{"id":1346,"href":"https:\/\/peloo.net\/index.php?rest_route=\/wp\/v2\/posts\/682\/revisions\/1346"}],"wp:attachment":[{"href":"https:\/\/peloo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/peloo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/peloo.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}