[B! linux][UNIX] kukitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kukita id:kukita

linuxã¨UNIXã«é–¢ã™ã‚‹kukitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

joinã‚³ãƒžãƒ³ãƒ‰ãŒä¾¿åˆ©éŽãŽã¦ç”Ÿãã‚‹ã®ãŒè¾›ã„ - Y's note
Linuxã‚·ã‚¹ãƒ†ãƒ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° ä½œè€…: Robert Love,ãƒãƒãƒ¼ãƒˆãƒ©ãƒ–,åƒä½æ²»éƒŽå‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: ã‚ªãƒ©ã‚¤ãƒªãƒ¼ã‚¸ãƒ£ãƒ‘ãƒ³ç™ºå£²æ—¥: 2008/04/16ãƒ¡ãƒ‡ã‚£ã‚¢: å¤§åž‹æœ¬è³¼å…¥: 5äºº ã‚¯ãƒªãƒƒã‚¯: 181å›žã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (29ä»¶) ã‚’è¦‹ã‚‹ çµåˆ Unix/Linuxã®æ¨™æº–ã‚³ãƒžãƒ³ãƒ‰ã§2ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã®å…±é€škeyã§é€£çµã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚å…±é€škeyã§ã®çµåˆã«ã¯joinã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã—ã¾ã™ã€‚joinã«ã‚ˆã‚ŠSQLã®inner joinã«è¿‘ã„ã“ã¨ãŒã‚³ãƒžãƒ³ãƒ‰ã ã‘ã§å‡ºæ¥ã¦ã—ã¾ã„ã¾ã™ã€‚ä»Šã¾ã§ãƒ†ã‚ã‚¹ãƒˆå‡¦ç†ã‚’ã‚³ãƒžãƒ³ãƒ‰ã§è¡Œã†äº‹ãŒå°‘ãªã‹ã£ãŸã®ã§joinã®æ´»ç”¨æ–¹æ³•ã‚’çŸ¥ã‚Šã¾ã›ã‚“ã§ã—ãŸãŒã€ä»Šå›žèª¿ã¹ãŸå†…å®¹ã‚’è¨˜éŒ²ã—ã¾ã™ã€‚ä¼¼ãŸã‚³ãƒžãƒ³ãƒ‰ã¨ã—ã¦pasteã¨ã„ã†ã‚‚ã®ã‚‚ã‚ã‚Šã€ã“ã¡ã‚‰ã¯åŒã˜è¡Œæ•°ã®å†…å®¹ã‚’å˜ç´”ã«çµåˆã—ã¾ã™ã€‚ãã¡ã‚‰ã«ã¤ã„ã¦ã‚‚ç°¡å˜ã«ç´¹ä»‹ã—ã¾ã™ã€‚ join joinå‰ã«sort joinã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯2ã¤ã®ãƒ•ã‚¡
kukita 2012/09/08
ã‚³ãƒžãƒ³ãƒ‰

linux

UNIX

shell

join

sh

command

ã‚½ãƒ¼ãƒˆ
ãƒªãƒ³ã‚¯
ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡¦ç†ã™ã‚‹ã¨ãã®Unixã‚³ãƒžãƒ³ãƒ‰ã¾ã¨ã‚ - nokunoã®æ—¥è¨˜
å€‹äººçš„ã«ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡¦ç†ã™ã‚‹ã“ã¨ãŒå¤šã„ã®ã§ã™ãŒï¼Œç°¡å˜ãªå‡¦ç†ãªã‚‰Unixã®ã‚³ãƒžãƒ³ãƒ‰ã‚’ãƒ‘ã‚¤ãƒ—ã¨ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã§çµ„ã¿åˆã‚ã›ã¦ã§ãã‚‹ã“ã¨ãŒå¤šãã‚ã‚Šã¾ã™ï¼Žä»Šå›žã¯ãã‚“ãªãªã‹ã§ã‚‚ã¡ã‚‡ã£ã¨ãƒžãƒ‹ã‚¢ãƒƒã‚¯ãªTIPSã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸï¼Ž sortã‚³ãƒžãƒ³ãƒ‰ã§ã‚¿ãƒ–åŒºåˆ‡ã‚Šã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æŒ‡å®šã™ã‚‹æœ€è¿‘çŸ¥ã£ã¦é©šæ„•ã—ãŸã®ãŒã“ã‚Œï¼Žsortã‚³ãƒžãƒ³ãƒ‰ã§ã‚¿ãƒ–åŒºåˆ‡ã‚Šã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æŒ‡å®šã—ãŸã„ã¨ãã¯ï¼ŒCtrl+v Tabã§ã‚¿ãƒ–æ–‡å—ã‚’å…¥åŠ›ã—ã¦ã„ãŸã®ã§ã™ãŒï¼Œ$ sort -t $'\t' -k 2,2 ã®ã‚ˆã†ã«ã—ã¦ã‚¿ãƒ–åŒºåˆ‡ã‚Šã§2ç•ªç›®ã®ã‚ãƒ¼ã§ã‚½ãƒ¼ãƒˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ï¼Ž 1000è¡ŒãŠãã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚°ã™ã‚‹1000è¡ŒãŠãã«ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚°ã—ãŸã„ã¨ãã¨ã‹ã¯ï¼Œperlã§ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã‚’æ›¸ãã®ãŒé€Ÿã„ã‚ˆã†ã§ã™ï¼Ž$ perl -ne '$i++; print unless ($i % 1000)' æŸæ‰€ã®ã‚³ãƒ¼ãƒ‰ã‚´ãƒ«ãƒ•ã«ã‚ˆã‚‹ã¨ã“ã‚Œã ã‘çŸãã§ã
kukita 2012/01/23
ã¾ã¨ã‚

linux

UNIX

ã‚³ãƒžãƒ³ãƒ‰

perl

shell

ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (9)

linuxã¨UNIXã«é–¢ã™ã‚‹kukitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬4é€±ï¼‰

ã€Œã‚ã¨ã§èªã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èªã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (9)

linuxã¨UNIXã«é–¢ã™ã‚‹kukitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

joinã‚³ãƒžãƒ³ãƒ‰ãŒä¾¿åˆ©éŽãŽã¦ç”Ÿãã‚‹ã®ãŒè¾›ã„ - Y's note

ãƒ†ã‚­ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡¦ç†ã™ã‚‹ã¨ãã®Unixã‚³ãƒžãƒ³ãƒ‰ã¾ã¨ã‚ - nokunoã®æ—¥è¨˜

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬4é€±ï¼‰

ã€Œã‚ã¨ã§èª­ã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èª­ã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (9)

linuxã¨UNIXã«é–¢ã™ã‚‹kukitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

joinã‚³ãƒžãƒ³ãƒ‰ãŒä¾¿åˆ©éŽãŽã¦ç”Ÿãã‚‹ã®ãŒè¾›ã„ - Y's note

ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡¦ç†ã™ã‚‹ã¨ãã®Unixã‚³ãƒžãƒ³ãƒ‰ã¾ã¨ã‚ - nokunoã®æ—¥è¨˜

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬4é€±ï¼‰

ã€Œã‚ã¨ã§èªã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èªã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹