[B! ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°] mziã®ãƒ

mizuguchi id:mzi

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹mziã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{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}}

PostgreSQL ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - Qiita
PostgreSQL Advent Calendar 2014 ã® 13æ—¥ç›®ã§ã™ã€‚ Advent Calendar ã‚’ä»Šå¹´ã‚‚ã‚„ã£ã¦ã¿ãŸã„ã¨æ€ã£ã¦ã€æž ãŒç©ºã„ã¦ã„ãŸã®ã§é£›ã³è¾¼ã‚“ã§ã¿ã¾ã—ãŸã€‚ æ˜¨æ—¥ã¯ osapon ã•ã‚“ã® libpqxx ã‚’ä½¿ã£ã¦ã¿ãŸã§ã—ãŸã€‚ æ¦‚è¦ PostgreSQL ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯å¤§ããä¸‹è¨˜ã«åˆ†ã‹ã‚Œã¾ã™ã€‚ ã‚·ã‚¹ãƒ†ãƒ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° SQL ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ã“ã“ã§ã¯ Linux ä¸Šã§å‹•ã‹ã—ã¦ã„ã‚‹ã“ã¨ã‚’å‰æã«ã€ãã‚Œãžã‚Œèª¬æ˜Žã—ã¾ã™ã€‚ ã‚·ã‚¹ãƒ†ãƒ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ã‚·ã‚¹ãƒ†ãƒ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®æ¦‚è¦ ã‚·ã‚¹ãƒ†ãƒ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã¯ã€OS ã¾ãŸã¯ PostgreSQL ã®è¨å®šã‚’å¤‰æ›´ã™ã‚‹ã“ã¨ã§ã™ã€‚ ãã‚Œãžã‚Œé †ã«èª¬æ˜Žã—ã¾ã™ã€‚ OS ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° PostgreSQL ã§ã¯ç‰¹ã«ãƒ¡ãƒ¢ãƒªé–¢é€£ã§OSãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’è¨å®šå¤‰æ›´ã™ã‚‹ã¨ã€é«˜é€ŸåŒ–åŠ¹æžœãŒå¾—ã‚‰ã‚Œã¾ã™ã€‚ ç‰¹ã«ä¸‹è¨˜ã®ã‚«ãƒ¼ãƒãƒ«ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«æ³¨æ„ã—ã¾ã™ã€‚ vm.dirt
mzi 2014/12/14
PostgreSQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

å®Ÿè£…
ãƒªãƒ³ã‚¯
MySQLã®è‡ªå‹•å¤‰æ›ã‚’ä¸é‡ã«ãŠæ–ã‚Šã™ã‚‹ãŸã‚ã®ãŸã£ãŸï¼‘ç¨®é¡žã®å‘ªæ–‡ - sakaikã®æ—¥ã€…é›‘æ„Ÿï½ž(T)ç·¨
å…ˆæ—¥ã®ã€Žã“ã‚Œã ã‘ã¯è¦šãˆã¦ãŠããŸã„!!MySQL ã®ï¼–ã¤ã®è‡ªå‹•å¤‰æ›ã€ http://d.hatena.ne.jp/sakaik/20100225/mysqlautochange ã«ã¯ãŸãã•ã‚“ã®åéŸ¿ã‚’ã„ãŸã ã„ãŸã€‚ æ™‚ã«ã“ã¡ã‚‰ã®æ„å›³ã¨é•ã£ã¡ã‚ƒã†ã“ã¨ã‚‚ã‚ã‚‹ã‘ã‚Œã©ã‚‚ã‚±ãƒŠã‚²ã«æ°—ã‚’ä½¿ã£ã¦ãã‚Œã‚‹ MySQL ãŒã€ã“ã‚Œã»ã©ã«çš†ã•ã‚“ã«ã‚‚æ„›ã•ã‚Œã¦ã„ã‚‹ã“ã¨ãŒåˆ¤ã‚Šã€MySQLãƒ•ã‚¡ãƒ³ã®ä¸€äººã¨ã—ã¦å¬‰ã—ã„é™ã‚Šã§ã‚ã‚‹ã€‚ ã•ã¦ã€ãã®ã‚¨ãƒ³ãƒˆãƒªã®æœ€å¾Œã«ã€ ãªãŠã€ã€ŒSQLãƒ¢ãƒ¼ãƒ‰ã€ã‚’æŒ‡å®šã™ã‚‹ã¨ã“ã‚Œã‚‰ã®å‹•ä½œã‚’å¤‰æ›´ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚SQLãƒ¢ãƒ¼ãƒ‰ã«ã¤ã„ã¦ã¯æ°—ãŒå‘ã„ãŸã‚‰ã„ã¤ã‹ç´¹ä»‹ã—ã¦ã¿ãŸã„ã€‚ ã¨æ›¸ã„ãŸã¨ã“ã‚ã€é€Ÿæ”»ã§ã‚ãƒ ãƒ©ãƒ‡ãƒ¼ãƒ“ãƒ¼ã®æœ¨æ‘æ˜Žæ²»æ°ãŒè£œè¶³ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’æ›¸ã„ã¦ãã ã•ã£ãŸã€‚ â—‹ã‚ãƒ ãƒ©ãƒ‡ãƒ¼ãƒ“ãƒ¼ãƒ–ãƒã‚° [å‹æ‰‹ã«è£œè¶³]ã“ã‚Œã ã‘ã¯è¦šãˆã¦ãŠããŸã„!!MySQL ã®ï¼–ã¤ã®è‡ªå‹•å¤‰æ› http://blog.kimuradb.com/?eid=83851
mzi 2010/03/04
å®Ÿè£…

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

mysql
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: MySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•
MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã¨è¨€ã£ãŸå ´åˆã«ã¯ã€ã‚µãƒ¼ãƒãƒ¼ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®èª¿æ•´ã‚„ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã—ãŸã‚¯ã‚¨ãƒªå®Ÿè¡Œè¨ˆç”»ã®æœ€é©åŒ–ãŒè©±é¡Œã«ä¸Šã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ã—ã‹ã—ã€ç™ºè¡Œã™ã‚‹å…¨ã¦ã® SQL ã«ã¤ã„ã¦ã€ã„ã¡ã„ã¡ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ã¦ç¢ºèªã—ã¦ã„ã¦ã¯ã€ã„ãã‚‰æ™‚é–“ãŒã‚ã£ã¦ã‚‚ãŸã‚Šã¾ã›ã‚“ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’åŠ¹çŽ‡çš„ã«é€²ã‚ã‚‹ã«ã¯ã€ã¾ãšã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã£ã¦ã„ã‚‹ SQL ã‚¯ã‚¨ãƒªã‚’ç‰¹å®šã—ã€æ¬¡ã«ãã®æœ€é©åŒ–ã‚’è¡Œã†ã¹ãã§ã™ã€‚ ã§ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’ç‰¹å®šã™ã‚‹ã®ã‹ã€‚MySQL Conference & Expo 2009 ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã«ãŠã„ã¦ Mark Callaghan æ°ã¯ã€Google ã§ã¯ SHOW PROCESSLIST ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ãŸçµ±è¨ˆçš„ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’ä½¿ã£ã¦ã„ã‚‹ã¨è¿°ã¹ã¦ã„ã‚‰ã£ã—ã‚ƒã„ã¾ã™ (å‚ç…§: MySQLConf 09: Mark Callaghan, "This is Not a
mzi 2009/07/24
å®Ÿè£…

ãƒ‡ãƒ¼ã‚¿å·¥å¦

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

èªã¿ç‰©

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ã‚„ã£ã¦ã¯ã„ã‘ãªã„!!MySQLã«æ‚²é³´ã‚’ã‚ã’ã•ã›ã‚‹10ã®æ–¹æ³•
ã„ã¤ã‚‚ã€ŒMySQLã‚’ä½¿ã†ã¨ãã¯ã“ã†ã™ã‚‹ã¹ãã€ã¨ã„ã†è¦³ç‚¹ã‹ã‚‰è¨˜äº‹ã‚’æ›¸ã„ã¦ã„ã‚‹ãŒã€ä»Šæ—¥ã¯é€†ã«çŠ¯ã—ã¦ã¯ã„ã‘ãªã„éŽã¡ã‚’ãƒªã‚¹ãƒˆã‚¢ãƒƒãƒ—ã—ã‚ˆã†ã¨æ€ã†ã€‚ 1. å…¨ã¦ã®ã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¤ã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆå¿ƒè€…ãŒã‚‚ã£ã¨ã‚‚ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãªé–“é•ã„ã¯ã‚³ãƒ¬ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã„ã„ã€‚æ¤œç´¢ãŒã¨ã¦ã‚‚é€Ÿããªã‚‹ã‹ã‚‰ã€‚ã—ã‹ã—ã€ãã‚Œã¨å¼•ãæ›¿ãˆã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æ›´æ–°ã™ã‚‹ã¨ãã«ã‚³ã‚¹ãƒˆãŒã‹ã‹ã‚‹ã—ã€ãã®åˆ†å¤šãã®ãƒ‡ã‚£ã‚¹ã‚¯ã‚¹ãƒšãƒ¼ã‚¹ã‚’æ¶ˆè²»ã™ã‚‹ã€‚ç‰¹ã«æ›´æ–°ã«ã‹ã‹ã‚‹ã‚³ã‚¹ãƒˆã¯æ™‚ã«ç”šå¤§ã§ã€è©²å½“ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãƒšãƒ¼ã‚¸ãŒã‚ãƒ£ãƒƒã‚·ãƒ¥ä¸Šã«ãªã„å ´åˆã¯ãƒ‡ã‚£ã‚¹ã‚¯ã‹ã‚‰ã„ã£ãŸã‚“ãã®ãƒšãƒ¼ã‚¸ã‚’èªã¿è¾¼ã¾ãªã‘ã‚Œã°ã„ã‘ãªã„ã€‚ãƒ‡ã‚£ã‚¹ã‚¯ã‚¢ã‚¯ã‚»ã‚¹ã¯å‹•ä½œã«ã¨ã¦ã‚‚æ™‚é–“ãŒã‹ã‹ã‚‹ã®ã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒå¤šæ•°ã€ä¾‹ãˆã°å…¨ã¦ã®ã‚«ãƒ©ãƒ ã«ä»˜ã„ã¦ã„ãŸã‚Šã™ã‚‹ã¨ã€Œã‚ã‚Œï¼Ÿå›ºã¾ã£ãŸã‹ï¼Ÿã€ã¨ã„ã†ã‚ˆã†ãªçŠ¶æ…‹ã«ãªã£ã¦ã—ã¾ã†ã“ã¨ãŒã‚ã‚‹ã ã‚ã†ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å¿…è¦ãªã‚«ãƒ©ãƒ ã«ã ã‘ã¤ã‘ã‚‹ã‚ˆã†ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¨è¨ˆã—ã‚ˆã†ã€‚
mzi 2009/04/08
å®Ÿè£…

ãƒ‡ãƒ¼ã‚¿å·¥å¦

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

tips
ãƒªãƒ³ã‚¯
Yahoo!ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã®MySQL å†—é•·åŒ–æŠ€è¡“
ãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10æœˆ1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ãƒ–ãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚LINEãƒ¤ãƒ•ãƒ¼ Tech Blog ã“ã‚“ã«ã¡ã¯ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ãƒ—ãƒ©ãƒƒãƒˆãƒ›ãƒ¼ãƒ æŠ€è¡“ã®ãƒãƒ£ãƒƒã‚¯ã§ã™ã€‚ ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯ä¸€éƒ¨ã‚µãƒ¼ãƒ“ã‚¹ã« RDBMS ã® MySQL ã‚’ä½¿ã£ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æä¾›ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯å¤šãã®ãŠå®¢æ§˜ã‚ˆã‚Šã‚¢ã‚¯ã‚»ã‚¹ã‚’é ‚ã„ã¦ãŠã‚Šã¾ã™ã®ã§ã€å¤§é‡ã®æ›´æ–°ã€å‚ç…§ã®å‡¦ç†é€Ÿåº¦ã«å„ªã‚ŒãŸ MySQL ã‚’é¸æŠžã—ã€ãŠå®¢æ§˜ã«ã‚¹ãƒˆãƒ¬ã‚¹ãªãã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ã‘ã‚‹ã‚ˆã† æ—¥ã€…æ¥å‹™ã«å–ã‚Šçµ„ã¾ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€ç²¾å¯†æ©Ÿå™¨ã«ã¯æ•…éšœãŒã¤ãã‚‚ã®ã§ã€ã‚µãƒ¼ãƒ“ã‚¹é‹ç”¨ã®è¦³ç‚¹ã‹ã‚‰ã¯ ã€Œæ©Ÿå™¨ãŒæ•…éšœã™ã‚‹ã®ã¯ã—ã‹ãŸãªã„ã€ã—ã‹ã—ãã‚Œã‚’ã„ã‹ã«æ—©ãå¾©æ—§ã•ã›ã‚‹ã‹ã€ ã¨ã„ã£ãŸã“ã¨ã‚’å¿µé ã«å…¥ã‚Œã¦ãŠã‚Šã¾ã™ã€‚ å®Ÿéš›ã«ã¯ã€éšœå®³ãŒèµ·ã“ã£ã¦ã‹ã‚‰å¾©æ—§ã•ã›ã‚‹ã®ã§ã¯ãªãã€éšœå®³ãŒç™ºç”Ÿã—ãŸå ´åˆã«
mzi 2009/03/29
å®Ÿè£…

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql
ãƒªãƒ³ã‚¯
ãªãœMySQLã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã¯é…ã„ã®ã‹ã€‚
ã‚ˆãMySQLã¯ã‚µãƒ–ã‚¯ã‚¨ãƒªãŒå¼±ã„ã¨è¨€ã‚ã‚Œã‚‹ãŒã€ã“ã‚Œã¯æœ¬å½“ã ã‚ã†ã‹ï¼ŸåŠåˆ†ã¯æœ¬å½“ã§åŠåˆ†ã¯å˜˜ã§ã‚ã‚‹ã€‚MySQLã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã ã£ã¦ãªã‚“ã§ã‚‚ã‹ã‚“ã§ã‚‚é…ã„ã‚ã‘ã§ã¯ãªã„ã€‚è½ã¨ã—ç©´ã‚’ã—ã£ã‹ã‚Šé¿ã‘ã€ä½¿ã„ã©ã“ã‚ã‚’é–“é•ãˆãªã‘ã‚Œã°ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚‚é«˜é€Ÿã«å®Ÿè¡Œã§ãã‚‹ã®ã§ã‚ã‚‹ã€‚ä»Šæ—¥ã¯MySQLãŒã©ã‚“ãªé¢¨ã«ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã€ã©ã®ã‚ˆã†ãªå ´åˆã«é…ã„ã®ã‹ã¨ã„ã†ã“ã¨ã«ã¤ã„ã¦èª¬æ˜Žã—ã‚ˆã†ã€‚ EXPLAINã§å®Ÿè¡Œè¨ˆç”»ã‚’èª¿ã¹ãŸéš›ã«ã€select_typeã«ã¯ã‚¯ã‚¨ãƒªã®ç¨®é¡žãŒè¡¨ç¤ºã•ã‚Œã‚‹ã®ã ãŒã€ä»£è¡¨çš„ãªã‚µãƒ–ã‚¯ã‚¨ãƒªã«ã¯æ¬¡ã®3ã¤ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚‹ã€‚ SUBQUERY DEPENDENT SUBQUERY DERIVED çµè«–ã‹ã‚‰è¨€ãŠã†ã€‚é…ã„ã®ã¯2ç•ªç›®ã€DEPENDENT SUBQUERYã§ã‚ã‚‹ã€‚DEPENDENT SUBQUERYã¨ã¯ã„ã‚ã‚†ã‚‹ç›¸é–¢ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ç›¸å½“ã™ã‚‹ã‚‚ã®ã§ã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ãŠã„ã¦å¤–éƒ¨ã‚¯ã‚¨ãƒªã®ã‚«ãƒ©ãƒ ã‚’å‚ç…§ã—ã¦ã„ã‚‹ã‚µãƒ–ã‚¯ã‚¨ãƒªã®ã“ã¨ã§ã‚ã‚‹ã€‚ãã—
mzi 2009/03/26
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

å®Ÿè£…

æƒ…å ±æ¤œç´¢
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
mzi 2009/03/20
å®Ÿè£…

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

SQL

DB
ãƒªãƒ³ã‚¯
1