[B! ã‚³ãƒžãƒ³ãƒ‰] nekoaquaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nekoaqua id:nekoaqua

ã‚³ãƒžãƒ³ãƒ‰ã«é–¢ã™ã‚‹nekoaquaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{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ã¤ã®ãƒ•ã‚¡
nekoaqua 2012/09/15
joinã‚³ãƒžãƒ³ãƒ‰ãŒä¾¿åˆ©éŽãŽã¦ç”Ÿãã‚‹ã®ãŒè¾›ã„ - Yuta.Kikuchiã®æ—¥è¨˜

Linux

UNIX

ã‚³ãƒžãƒ³ãƒ‰
ãƒªãƒ³ã‚¯
è‹¥è€…ãŒçŸ¥ã‚‰ãªã„æœ€å¼·ã®Linuxã‚³ãƒžãƒ³ãƒ‰Tips - ã™ãŒãƒ–ãƒ
ã‚¿ã‚¤ãƒˆãƒ«ã¯é‡£ã‚Šã½ã‚ˆã€œ ä»Šæ—¥ã“ã“ã§æ›¸ãã®ã¯ã‚ã‚Šã‹ã—æœ€è¿‘çŸ¥ã£ãŸã“ã¨ã ã£ãŸã‚Šã™ã‚‹ã®ãŒå¤šã„ã‚“ã§ã™ãŒã€ã›ã£ã‹ããªã®ã§æ›¸ã„ã¦ãŠã“ã†ã‹ãªãã¨æ€ã£ãŸæ¬¡ç¬¬ã§ã™ã€‚Linuxã£ã¦æ›¸ã„ã¦ã‚‹ã‘ã©ã€æ™®é€šã«Macã§ã‚‚ä½¿ãˆã‚‹ãƒã‚ºã§ã™ã€‚ çŸ¥ã£ã¦ã‚‹äººã«ã¨ã£ã¦ã¯ã‚¢ã‚¿ãƒªãƒžã‚¨ã®ã“ã¨ã§ã™ã‘ã©ãâ€¦â€¦ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºã®æ¡ã§ã‹ã™ãŽã¦ãŒã‚ã‹ã‚‰ã‚“ ls ã¨ã‹ duã‚ãŸã‚Šã§ä½¿ãˆã‚‹è©±ã§ã™ãã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºãŒå¤§ãã™ãŽã¦ãƒ‘ãƒƒã¨è¦‹ã‚ã‹ã‚‰ãªã„ã‚ˆã£ã¦ã„ã†ã“ã¨ã£ã¦ã‚ã‚‹ã˜ã‚ƒãªã„ã§ã™ã‹ã€‚ã‚ã‚Šã¾ã™ã‚ˆãã€‚ã„ã‚„ã‚ã‚‹ã€‚ ãã‚“ãªæ™‚ã¯ -h ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä½¿ã„ã¾ã—ã‚‡ã†ã€‚ $ ls -l /var/log/nginx/access.log -rw-r--r-- 1 root root 1897381 8æœˆ 26 02:50 2012 /var/log/nginx/access.log $ ls -lh /var/log/nginx/access.log -rw-r--r--
nekoaqua 2012/08/30
è‹¥è€…ãŒçŸ¥ã‚‰ãªã„æœ€å¼·ã®Linuxã‚³ãƒžãƒ³ãƒ‰Tips - @sugamasao.blog.title # => â€ã‚³ãƒ¼ãƒ‰ã§ä¸–ç•Œã‚’å¤‰ãˆãŸã„â€

linux

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

TIPS
ãƒªãƒ³ã‚¯
ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡¦ç†ã™ã‚‹ã¨ãã®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)' æŸæ‰€ã®ã‚³ãƒ¼ãƒ‰ã‚´ãƒ«ãƒ•ã«ã‚ˆã‚‹ã¨ã“ã‚Œã ã‘çŸãã§ã
nekoaqua 2012/01/22
ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡¦ç†ã™ã‚‹ã¨ãã®Unixã‚³ãƒžãƒ³ãƒ‰ã¾ã¨ã‚ - nokunoã®æ—¥è¨˜

UNIX

linux

ã‚³ãƒžãƒ³ãƒ‰
ãƒªãƒ³ã‚¯
Mac OS Xã‚’ä½¿ã„ã‚„ã™ãã™ã‚‹ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‚³ãƒžãƒ³ãƒ‰ã¾ã¨ã‚ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
Make Tech Easier - Uncomplicating the complicated, making life easier Mac OS Xã®æä¾›ã™ã‚‹UIã¯æ´—ç·´ã•ã‚Œã¦ãŠã‚Šã€åˆå¿ƒè€…ã‹ã‚‰ä¸Šç´šè€…ã¾ã§æ‰±ã„ã‚„ã™ã„ä½œã‚Šã«ãªã£ã¦ã„ã‚‹ã€‚ã—ã‹ã—ãªãŒã‚‰ã€GUIã‹ã‚‰å¤‰æ›´ã§ãã‚‹è¨å®šã¯é™ã‚‰ã‚Œã¦ã„ã‚‹ã€‚é™ã‚Šãªãçœãƒ¡ãƒ¢ãƒªè¨å®šã«å¤‰æ›´ã—ãŸã‹ã£ãŸã‚Šã€é€†ã«æ¬²ã—ã„æ©Ÿèƒ½ãŒç„¡åŠ¹åŒ–ã•ã‚Œã¦ä½¿ã„ã«ãããªã£ãŸãŸã‚å…ƒã«æˆ»ã—ãŸã„ã¨ã„ã†å ´åˆã€GUIã‹ã‚‰ã¯è¨å®šã™ã‚‹ã“ã¨ãŒã§ããªã„ã¨ã„ã†çµŒé¨“ã‚’ã™ã‚‹ã“ã¨ãŒã‚ã‚‹ã€‚ å®Ÿã®ã¨ã“ã‚OS Xã®è¨å®šã¯ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‹ã‚‰ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ã§å¤‰æ›´ã§ãã‚‹ã€‚ä¸ä¸Šç´šè€…å‘ã‘ã®è¨å®šã¨ãªã‚‹ãŒã€æœ¬æ°—ã§ä½¿ã„ã“ãªã™ã«ã¯ã“ã‚Œã‚‰è¨å®šæ–¹æ³•ã‚’çŸ¥ã£ã¦ãŠã„ãŸæ–¹ãŒã„ã„ã“ã¨ã‚‚ã‚ã‚‹ã€‚Make Tech Easierã«ãŠã„ã¦ã€ãã†ã—ãŸå ´åˆã®å…¥é–€ã¨ã—ã¦æ‰±ãˆã‚‹å†…å®¹ãŒã€ŒUseful Terminal Commands & Tips For Mac O
nekoaqua 2011/10/29
Mac OS Xã‚’ä½¿ã„ã‚„ã™ãã™ã‚‹ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‚³ãƒžãƒ³ãƒ‰ã¾ã¨ã‚ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«

Mac

tips

ã‚³ãƒžãƒ³ãƒ‰
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

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

å…¬å¼Twitter

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

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

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

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

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

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

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

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

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

ã‚¿ã‚°

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

ã‚³ãƒžãƒ³ãƒ‰ã«é–¢ã™ã‚‹nekoaquaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

ãŠçŸ¥ã‚‰ã›

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

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

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

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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

ã‚¿ã‚°

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

ã‚³ãƒžãƒ³ãƒ‰ã«é–¢ã™ã‚‹nekoaquaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

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

è‹¥è€…ãŒçŸ¥ã‚‰ãªã„æœ€å¼·ã®Linuxã‚³ãƒžãƒ³ãƒ‰Tips - ã™ãŒãƒ–ãƒ­

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

Mac OS Xã‚’ä½¿ã„ã‚„ã™ãã™ã‚‹ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‚³ãƒžãƒ³ãƒ‰ã¾ã¨ã‚ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«

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

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

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

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

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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

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

ã‚³ãƒžãƒ³ãƒ‰ã«é–¢ã™ã‚‹nekoaquaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

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

è‹¥è€…ãŒçŸ¥ã‚‰ãªã„æœ€å¼·ã®Linuxã‚³ãƒžãƒ³ãƒ‰Tips - ã™ãŒãƒ–ãƒ

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

Mac OS Xã‚’ä½¿ã„ã‚„ã™ãã™ã‚‹ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‚³ãƒžãƒ³ãƒ‰ã¾ã¨ã‚ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«

ãŠçŸ¥ã‚‰ã›

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

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

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

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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