[B! SQL] yocchi24ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yocchi24 id:yocchi24

SQLã«é–¢ã™ã‚‹yocchi24ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (20)

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

Rã‚’å¦ã¼ã†ï¼ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°è¬›åº§ï½œfreee å‚æœ¬ç™»å²æ–‡ã€åˆã‚ã®ç¬¬ä¸€æ©ç·¨ã€‘ | ã‚ãƒ£ãƒªã‚¢ãƒãƒƒã‚¯ï¼ˆCAREER HACKï¼‰
freeeã®ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã€å‚æœ¬ã•ã‚“ã«ã‚ˆã‚‹çµ±è¨ˆè§£æžãƒ„ãƒ¼ãƒ«Rã‚’ä½¿ã£ãŸã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°è¬›åº§å‰ç·¨ã€‚Rã§ä½•ãŒã§ãã‚‹ã®ã‹ï¼Ÿè¨å®šã‹ã‚‰SQLã¨ã®æŽ¥ç¶šã€ã‚°ãƒ©ãƒ•åŒ–ã¾ã§ä¸€é€£ã®æµã‚Œã‚’å¦ã³ã¾ã™ã€‚ ã¯ã˜ã‚ã¾ã—ã¦ã€‚freeeã®ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å‚æœ¬ç™»å²æ–‡ã§ã™ã€‚å…ˆæ—¥ã®ãƒãƒ¼ã‚¹ãƒãƒ©ãƒŸç¾è±¡ã®è¨˜äº‹ã¯ã„ã‹ãŒã§ã—ãŸã§ã—ã‚‡ã†ã‹ï¼Ÿç§ã¯ã€è¨˜äº‹å…¬é–‹å¾Œã‹ã‚‰ãŸãã•ã‚“ã®äººã«ç„¼è‚‰ã®ãŠèª˜ã„ã‚’é ‚ãã€éžå¸¸ã«å……å®Ÿã—ãŸå¤ã‚’é€ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸï¼ˆç¬‘ï¼‰ å…ˆæ—¥ã®è¨˜äº‹ã¯ã‚ãã¾ã§ã‚‚ãƒ‡ãƒ¼ã‚¿æ´»ç”¨ã®è€ƒãˆæ–¹ã®ç´¹ä»‹ã§ã€æ£ã—ã„æ„å‘³ã§ã®ãƒ‡ãƒ¼ã‚¿â€œãƒžã‚¤ãƒ‹ãƒ³ã‚°â€ã®ç´¹ä»‹ã¯ã§ãã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚ ãã“ã§ä»Šå›žã¯ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®çš†æ§˜å‘ã‘ã«ã€2å›žã«åˆ†ã‘ã¦ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ã®åˆã‚ã®ç¬¬ä¸€æ©ã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚å…ˆæ—¥ã®è¨˜äº‹ã§ã¯ç„¼è‚‰åº—ã®åº—é•·ãŒã§ã¦ããŸã‚ˆã†ã«ã€ä»Šå›žã®ãŠè©±ã§ã¯ã€WEBã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å±±ç”°å›ãŒç™»å ´ã—ã¾ã™ã€‚ å±±ç”°å›ã®æ°—æŒã¡ã«ãªã£ã¦ä¸€ç·’ã«ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ã‚’ä½“é¨“ã—ã¦ã‚‚
yocchi24 2014/09/26
ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°

SQL
ãƒªãƒ³ã‚¯
IPAã®ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ãŒå®‰å…¨ã«ãªã£ã¦ã„ãŸ
(Last Updated On: 2018å¹´8æœˆ4æ—¥)IPAã¯ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ï¼ˆPDFï¼‰ã‚’ä»¥ä¸‹ã®URLã‹ã‚‰å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ http://www.ipa.go.jp/security/vuln/websecurity.html ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã¯å±é™ºã§ã‚ã‚‹ã€ã¨ã™ã‚‹ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã“ã†ã‹ã¨æ€ã„ã€å†…å®¹ã‚’ç¢ºèªã™ã‚‹ã¨ãã†ã§ã‚‚ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ è¨‚æ£ï¼šãƒ„ã‚¤ãƒƒã‚¿ãƒ¼ã§å¾³ä¸¸æ°ã«ç¢ºèªã—ãŸã¨ã“ã‚ã€å¾³ä¸¸æ°ã‚‚ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã‚’å«ã‚ãŸSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ãŒå¿…è¦ã§ã‚ã‚‹ã¨è€ƒãˆã‚‰ã‚Œã¦ã„ãŸã€ã“ã¨ã‚’ç¢ºèªã—ã¾ã—ãŸã€‚å¾³ä¸¸æ°ã«ã¯ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å°‚é–€å®¶ã¨ã—ã¦å¤§å¤‰ä¸åèª‰ãªè¨˜è¿°ã§ã‚ã£ãŸäº‹ã‚’è¨‚æ£ã—ã€æ·±ããŠè©«ã³ã„ãŸã—ã¾ã™ã€‚å†…å®¹ã«ã¤ã„ã¦ã®ä¿®æ£ã¯ã€è˜åˆ¥åã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã«ã¤ã„ã¦ãƒ–ãƒã‚°ã«æ›¸ãã¨ã®äº‹ã§ã—ãŸã®ã§ãƒ–ãƒã‚°ã®å†…å®¹ã‚’ç¢ºèªã—ã¦ã‹ã‚‰ä¿®æ£ã—ã¾ã™ã€‚ åˆ¥å†Šã®ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã¯åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ã€Œæ£ç¢ºãªãƒ†ã‚ã‚¹ãƒˆã®çµ„ã¿ç«‹ã¦ã€ã«ã‚ˆã‚‹ã‚»
yocchi24 2013/12/05
SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

é–‹ç™º

DB
ãƒªãƒ³ã‚¯
A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®æ±Žç”¨SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«
A5:SQL Mk-2ã¯è¤‡é›‘åŒ–ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã‚’æ”¯æ´ã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ é«˜æ©Ÿèƒ½ã‹ã¤è»½é‡ã§ã€ä½¿ã„æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã“ã¨ã‚’ç›®æ¨™ã«é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç·¨é›†ã™ã‚‹ã»ã‹ã«ã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€ERå›³ã‚’ä½œæˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ç‰¹å¾´ãƒ»æ©Ÿèƒ½ OCIæŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãƒ»ADOã¾ãŸã¯ODBCã‚’ä»‹ã—ãŸDBã¸ã®æŽ¥ç¶š Oracle Databaseã¯OCIçµŒç”±ã®æŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ PostgreSQLã¨MySQLã¯ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Serverã¯ã€OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ IBM DB2ã¯ã€ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ ãã®ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ADOã¾ãŸã¯ODBCã‚’åˆ©ç”¨ã—ã¦æŽ¥ç¶šã—ã¾ã™ã€‚ Oracle, PostgreSQL, MySQLã¯ã€A5:SQL
yocchi24 2013/11/21
SQL

é–‹ç™º

ãƒ„ãƒ¼ãƒ«

windows

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã“ã“ã¾ã§ã‚„ã‚‹ã‹ã€‚SQLiteã‚’JavaScriptã«å¤‰æ›Â·SQL.js MOONGIFT
SQL.jsã¯SQLiteã‚’Emscriptenã‚’ä½¿ã£ã¦JavaScriptåŒ–ã—ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ SQL.jsã¯Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§ä½¿ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚Emscriptenã‚’ä½¿ã£ã¦SQLiteã‚’JavaScriptã«å¤‰æ›ã—ãŸé¢ç™½ã„ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ ãƒ‡ãƒ¢ã§ã™ã€‚ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒªã‚¢ã«æ›¸ã‹ã‚ŒãŸSQLã‚’å®Ÿè¡Œã§ãã¾ã™ã€‚ å®Ÿè¡Œã—ãŸçµæžœã§ã™ã€‚æœ€çµ‚çš„ãªçµæžœã ã‘ãŒå‡ºåŠ›ã•ã‚Œã¦ã„ã¾ã™ã€‚SELECTã®çµæžœã¯JSONãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦å–å¾—ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã‚‚ã¡ã‚ã‚“æ™®é€šã«SQLãŒä½¿ãˆã¾ã™ã€‚ æ—¥æœ¬èªžã¯å‡ºåŠ›æ™‚ã¯åŒ–ã‘ã¦ã—ã¾ã„ã¾ã—ãŸãŒãƒ‡ãƒ¼ã‚¿ä¸Šã¯å•é¡Œãªã„ã¨æ€ã‚ã‚Œã¾ã™ã€‚ SQL.jsã¯SQLiteãŒãã®ã¾ã¾JavaScriptã«ãªã£ã¦ã—ã¾ã£ãŸã‚ˆã†ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚æ…£ã‚ŒãŸä½¿ã„å‹æ‰‹ã§SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã§ãã¦ã—ã¾ã†ã®ã¯é¢ç™½ãã†ã§ã™ã€‚ãªãŠç¾çŠ¶Google Chromeã‚„Firefoxã«ã—ã‹æœ€é©åŒ–ã•ã‚Œã¦ã„ã¾ã›ã‚“ã€‚ SQL.jsã¯
yocchi24 2012/03/18
SQL

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

javascript
ãƒªãƒ³ã‚¯
ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã§Googleæ¤œç´¢ã—ã¦ä¸Šä½15è¨˜äº‹ã‚’æ¤œè¨¼ã—ãŸ - ockeghem's blog
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€ãƒãƒƒãƒˆä¸Šã§ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã§Googleæ¤œç´¢ã—ãŸçµæžœã®ä¸Šä½15ã‚¨ãƒ³ãƒˆãƒªã‚’æ¤œè¨¼ã—ãŸçµæžœã‚’å ±å‘Šã—ã¾ã™ã€‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ã®å¯¾ç–ã¯ã€æ—¢ã«ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã«ãƒ•ã‚¡ã‚¤ãƒŠãƒ«ã‚¢ãƒ³ã‚µãƒ¼ï¼ˆå¾Œè¿°ï¼‰ã‚’ç¤ºã—ã¦ã„ã¾ã™ãŒã€ã¾ã ã“ã®æ–‡æ›¸ã‚’çŸ¥ã‚‰ãªã„äººãŒå¤šã„ã ã‚ã†ã“ã¨ã¨ã€ã‚„ã‚„ä¸Šç´šè€…å‘ã‘ã®æ–‡æ›¸ã§ã‚ã‚‹ã“ã¨ã‹ã‚‰ã€ã¾ã ååˆ†ã«å®Ÿè·µã•ã‚Œã¦ã¯ã„ãªã„ã¨æ€ã„ã¾ã™ã€‚ ã“ã®çŠ¶æ³ã§ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ã“ã¨ã‚’ã‚ˆãçŸ¥ã‚‰ãªã„äººãŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã—ã‚ˆã†ã¨ã—ãŸå ´åˆã®è¡Œå‹•ã‚’äºˆæ¸¬ã—ã¦ã¿ã‚‹ã¨ã€ã‹ãªã‚Šã®å‰²åˆã®äººãŒGoogleç‰ã§æ¤œç´¢ã—ã¦å¯¾å‡¦æ–¹æ³•ã‚’èª¿ã¹ã‚‹ã¨æ€ã‚ã‚Œã¾ã™ã€‚ãã“ã§ã€ä»¥ä¸‹ã®URLã§SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–æ–¹æ³•ã‚’æ¤œç´¢ã—ãŸçµæžœã®ä¸Šä½ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ¤œè¨¼ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ç«‹ã¡ã¾ã—ãŸã€‚ http://www.google.co.jp/search?q=SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç– ã©ã“ã¾ã§èª¿ã¹ã‚‹ã‹ã§ã™ãŒã€ä»¥å‰NH
yocchi24 2011/11/09
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦å¿…èª

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

SQL

è„†å¼±æ€§
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯NoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸã€‚NewSQLã®ç™»å ´ã¨NoSQLã®çµ‚ã‚ã‚Šã€ã¨ã„ã†äºˆæƒ³
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯NoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸã€‚NewSQLã®ç™»å ´ã¨NoSQLã®çµ‚ã‚ã‚Šã€ã¨ã„ã†äºˆæƒ³ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨PostgreSQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã©ã®ã‚ˆã†ãªæ–°æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã‚‹ã®ã‹ã€æ˜¨æ—¥ã€ä¸€æ˜¨æ—¥ã®2æœ¬ã®è¨˜äº‹ã§ç´¹ä»‹ã—ã¾ã—ãŸã€‚ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯Memcached APIã‚’å‚™ãˆã‚‹ï¼ MySQL Conference & Expo 2011åŸºèª¿è¬›æ¼” PostgreSQLã®ç¾çŠ¶ã¨æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³9.1ã®æ–°æ©Ÿèƒ½ã€‚MySQL Conference & Expo 2011 ã“ã®2ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«å…±é€šã—ã¦ã„ã‚‹ã®ãŒã€NoSQLã®æ©Ÿèƒ½ã‚’å–ã‚Šè¾¼ã‚“ã§ã„ã‚‹ã“ã¨ã§ã™ã€‚NoSQLã«å¯¾ã™ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã‚‹åæ’ƒãŒå§‹ã¾ã£ã¦ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒNoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹MySQL 5.6ã«æè¼‰äºˆå®šã®æ–°æ©Ÿèƒ½ã®1
yocchi24 2011/09/15
ã€ŽMySQLï¼‹HandlerSocketã®æ–¹ãŒmemcachedã‚ˆã‚Šã‚‚é«˜é€Ÿã«ã‚¯ã‚¨ãƒªå‡¦ç†ã€ã€ŽMySQL 5.6ã®Memcached APIã§ã‚‚é«˜ã„æ€§èƒ½ã€PostgreSQL 9.1ã®ã€ŒUnlogged tablesã€ã‚‚é«˜é€Ÿã«ã€ŽNoSQLã®çµ‚ã‚Šã®å§‹ã¾ã‚Šã€ã£ã¦å¯¿å‘½çŸã‹ã£ãŸãªã€‚ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚‚NoSQLã«åŒ¹æ•µã§ãã‚‹ï¼Ÿ

NoSQL

MySQL

SQL

db

NewSQL
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
yocchi24 2010/11/15
DBè¨è¨ˆã®å‚è€ƒã«ã€‚

mysql

DB

SQL

è² è·åˆ†æ•£

è¨è¨ˆ
ãƒªãƒ³ã‚¯
åœ°ç„ã®ã‚ˆã†ã«ã‚ˆãã‚ã‹ã‚‹SQLãƒ†ãƒ¼ãƒ–ãƒ«çµåˆ - ã“ã›ãã®æŠ€è¡“æ—¥è¨˜
ãƒ†ãƒ¼ãƒ–ãƒ«ã®JOINãŒè‹¦æ‰‹ã§ã—ãŸãŒã€ã“ã®ä¾‹ã‚’æ€ã„ã¤ã„ã¦ã‹ã‚‰ã¯ã€ã™ã£ãã‚Šãã£ãã‚Šç†è§£ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã‚€ã—ã‚é ã‹ã‚‰é›¢ã‚Œã¾ã›ã‚“â€¦â€¦ã€‚ â€» INNERã€OUTERã¯é£¾ã‚Šã€‚çœç•¥ã§ãã‚‹ã€‚ INNER JOIN â†’ JOIN LEFT OUTER JOIN â†’ LEFT JOIN RIGHT OUTER JOIN â†’ RIGHT JOIN â€» ON ...=... ã‚’ã¾ã¨ã‚ã¦ USING(å±žæ€§) ã¨æ›¸ã‘ã‚‹ã€‚ â€» ä½•ã§çµåˆã™ã‚‹ã‹è¨€ã†ã¾ã§ã‚‚ãªã„æ™‚ã¯ã€NATURALã‚’æŒ‡å®šã™ã‚‹ã¨å‹æ‰‹ã«JOINã—ã¦ãã‚Œã‚‹ã€‚NATURALã«JOINã—ã¦â€¦â€¦ã€‚ â€» WHEREã¯çµåˆã—ãŸçµæžœã«ä½œç”¨ã™ã‚‹ã€‚ â€» ç¾å®Ÿã«ã¯ä¸Šå›³ã®ã‚ˆã†ã«1å¯¾1ã§çµåˆã—ã¾ã›ã‚“ã€‚ â€» ãŠã¾ã‘ã€‚CROSS JOINã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚
yocchi24 2010/09/16
åˆå¿ƒè€…ã«ã¯åˆ†ã‹ã‚Šã‚„ã™ãã†ã€‚

DB

SQL
ãƒªãƒ³ã‚¯
SQL Serverã¨Oracleã®ä¸€ç•ªå¤§ããªé•ã„ï¼šãƒ™ãƒ³ãƒãƒ£ãƒ¼ç¤¾é•·ã§æŠ€è¡“è€…ã§ï¼šã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ©ã‚¤ãƒ•
æ ªå¼ä¼šç¤¾ã‚¸ãƒ¼ãƒ¯ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã®ä»£è¡¨å–ç· å½¹ã€‚ æ–°ã—ã„ã‚‚ã®ã‚’ç”Ÿã¿å‡ºã—ã¦ä¸–ã®ä¸ã‚’ã‚ã£ã¨ã„ã‚ã›ãŸã„ã€‚ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã£ã¦ã‚„ã¤èµ·ã“ã›ãŸã‚‰ã„ã„ãªã€‚ ã¶ã£ã¡ã‚ƒã‘ã¦ã€SQL Serverã‚‚ã€Oracleã‚‚ã€ãƒ•ãƒªãƒ¼ã®PostgreSQLã‚‚ã€RDBMSã¨ã—ã¦ã®æœ¬è³ªçš„ãªæ€§èƒ½å·®ã¯æœ¬å½“ã«å°ã•ã„ã€‚ãã®ãŸã‚RDBMSã®ãƒ™ãƒ³ãƒ€ãƒ¼ã‚’é¸æŠžã™ã‚‹ã®ã¯ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ã‹ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‹ã€ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ãªã©ã®æ©Ÿèƒ½ã‚„é–¢é€£ãƒ„ãƒ¼ãƒ«ã®ã§ãã¨ã€IDEã¨ã®ç›¸æ€§ãªã©ã‚’æ¤œè¨Žã™ã‚‹ã®ãŒè‰¯ã„ã§ã—ã‚‡ã†ã€‚ ã—ã‹ã—ã€ä¸€èˆ¬çš„ã«ã‚ã¾ã‚Šæ¤œè¨Žã®å¯¾è±¡ã«ãªã£ã¦ãªã„éƒ¨åˆ†ãŒã€å®Ÿã¯ä¸€ç•ªå¤§ããªé•ã„ã ã£ãŸã‚Šã—ã¾ã™ã€‚ã‚ãŸã—ã¯ã€SQL Serverã¨Oracleã®å·®ã§ã€ã‚‚ã£ã¨ã‚‚å¤§ãã„ã®ã¯ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚°ãƒ©ãƒ ï¼ˆãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ãƒ»ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ï¼‰ã®æ›¸ãæ–¹ï¼ˆæ§‹æ–‡ï¼‰ã®é•ã„ã ã¨æ€ã„ã¾ã™ã€‚ å˜ç´”ãªãƒã‚¸ãƒƒã‚¯ã¯Oracleã®æ–¹ãŒæ›¸ãã‚„ã™ã„ã€‚SQL Serverã®Ifãªã©ã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆãƒ–ãƒãƒƒã‚¯ã«BEGIN
yocchi24 2010/05/11
SQLServer ã¨ Oracle ã®é•ã„ã«ã¤ã„ã¦SELECTç³»ã®ã‚¹ãƒˆã‚¢ãƒ‰ã«è¨€åŠã—ã¦ã„ã‚‹ã€‚PostgreSQLã‚‚çµæ§‹æ›¸ãã‚„ã™ã„ã¨æ€ã†ã€‚ã‚ã¨å¤§ããé•ã†ã®ã¯UPDATEæ–‡ã¨Limit/Offsetã®å¯¾å¿œã€‚Webç³»ã§ã¯Oracleã¯ä½¿ã„ã¥ã‚‰ã„äº‹ãŒå¤šã„ã€‚ #db #web

SQL
ãƒªãƒ³ã‚¯
MySQL ã‚’ä½¿ã£ãŸãŠæ‰‹è»½ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼å®Ÿè£… - ãƒ‰ãƒ¯ãƒ³ã‚´ ç ”ç©¶é–‹ç™ºãƒ–ãƒã‚°
ã¯ã˜ã‚ã« ã“ã®è¨˜äº‹ã§ã¯ã€MySQL ã‚’ä½¿ã£ã¦ç°¡å˜ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã‚’æ‰‹è»½ã«å®Ÿè£…ã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ã€‚ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¨ã¯ã€ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’ä¸€æ™‚çš„ã«æºœã‚ã¦ãŠãã€é †æ¬¡å‡¦ç†ã™ã‚‹ãŸã‚ã®ä»•çµ„ã¿ã§ã™ã€‚è¿…é€Ÿãªãƒ¬ã‚¹ãƒãƒ³ã‚¹ãŒå¿…è¦ãª Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦ã€æ™‚é–“ã®ã‹ã‹ã‚‹å‡¦ç†ã‚’éžåŒæœŸã«è¡Œã†ãŸã‚ã«ã€ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ã§é †æ¬¡å‡¦ç†ã—ã¦ã„ãã‚ˆã†ãªå ´åˆã«åˆ©ç”¨ã§ãã¾ã™ã€‚ ç°¡å˜ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¨è¨€ã£ã¦ã‚‚ã€å¤§è¦æ¨¡ãªé‹ç”¨ã«ã‚‚è€ãˆã‚‰ã‚Œã‚‹ç¨‹åº¦ã®é€Ÿåº¦ã¨å …ç‰¢æ€§ã‚’æŒã¡ã¾ã™ã€‚ ã¾ãŸã€ã“ã“ã§è§£èª¬ã—ã¦ã„ã‚‹æ–¹æ³•ã§ä½œã‚‰ã‚ŒãŸãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¯ã€å¼Šç¤¾ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ãƒ‹ã‚³ãƒ‹ã‚³å‹•ç”»ã«æœ€è¿‘è¿½åŠ ã•ã‚ŒãŸtwitteré€£æºæ©Ÿèƒ½ã§ã‚‚åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã‚’ä½œã‚‹ã«ã‚ãŸã£ã¦ ä»Šå›žå®Ÿè£…ã™ã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¯ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®è¿½åŠ (push)ã‚’é«˜é€Ÿã«è¡Œã†äº‹ãŒã§ãã‚‹ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®å–å¾—(pop)ã¯ã‚ã‚‹ç¨‹åº¦é«˜é€Ÿã«è¡Œã†äº‹ãŒã§ãã‚‹ å¤šãã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰åŒæ™‚ã« p
yocchi24 2010/01/26
SQL

é‹ç”¨
ãƒªãƒ³ã‚¯
ORACLEã€€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€€INDEXã‚’æœ‰åŠ¹ã«ä½¿ã†
ï½žã€€ã”æŒ¨æ‹¶ã€€ï½ž ã©ï½žã‚‚ï½žâ˜†é“å…ˆæ¡ˆå†…äººã®ã€Œãƒ¦ãƒ¼ã‚¹ã‚¯ãƒ»ã‚¢ãƒ³ã‚¿ãƒ€ãƒ¬ãƒ¤ã€ã§ã™ã€‚ ä»Šå›žã€è‡ªåˆ†ã®çµŒé¨“ã‚’å…ƒã«ç°¡å˜ã«ORACLEã®SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãŒè¡Œãªãˆã‚‹ã‚ˆï½žâ™ª çš„ãªè¦šæ›¸ã‚’æ®‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚ãã¾ã§å€‹äººçš„ãªè¦šæ›¸ãªæ„Ÿã˜ãªã®ã§ã€é–“é•ã£ã¦ã‚‹éƒ¨åˆ†ã‚„ç›´ã—ãŸã‘ã©æ—©ããªã‚‰ãªã„ãªã©ã€è‹¦æƒ…ãŒå‡ºã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒ ã‚ãã¾ã§è‡ªå·±è²¬ä»»ã§ã‚„ã£ã¦ãã ã•ã„ã€‚ ãŠã‚‰ã¯è²¬ä»»å–ã‚Šã¾ã›ã‚“ãžï¼ï¼ ã§ã¯ã€èª¬æ˜Žã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã®ã§ã€æœ€å¾Œã¾ã§ãŠä»˜ãåˆã„ãã ã•ã‚Œâ˜† â˜†Â ã‚‚ãã˜Â â˜† ï¼ï¼Žã‚½ãƒ¼ãƒˆå‡¦ç†ãŒç™ºç”Ÿã™ã‚‹SQLã‚’ãªã‚‹ã¹ãä½¿ã‚ãªã„ ï¼‘ï¼ŽINDEXã‚’æœ‰åŠ¹ã«ä½¿ã† ï¼’ï¼Žçµåˆã«æ³¨æ„ï¼ï¼ ï¼“ï¼Žãã®ä»– ï¼”ï¼Žã‚¤ãƒ³ãƒãƒ¼ãƒˆãƒ»ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ ï¼•ï¼Žã¡ã‚‡ã£ã¨ã—ãŸSQLé”ï¼ï¼ã§ã‚‚å¿˜ã‚Œã¡ã‚ƒã†ã€‚ã€‚ã€‚ ï¼–ï¼Žãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ï¼ˆè¡¨é ˜åŸŸã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³åŒ–ï¼‰ ï¼—ï¼Žãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ ï¼˜ï¼Žå„ç¨®ç¢ºèªã‚³ãƒžãƒ³ãƒ‰ ï¼ï¼Žã‚½ãƒ¼ãƒˆå‡¦ç†ãŒç™ºç”Ÿã™ã‚‹SQLã‚’ãªã‚‹ã¹ãä½¿ã‚ãªã„ SQLã‚’é…ãã™ã‚‹è¦
yocchi24 2009/10/30
SQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
20090107 Postgre Sqlãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼ˆSqlç·¨ï¼‰
3. å®Ÿè¡Œè¨ˆç”»ã¨ã¯ï¼Ÿ å®Ÿè¡Œè¨ˆç”»ã¯ã€PostgreSQLã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ãŒæœ€é©ã ã¨åˆ¤æ–ã—ãŸã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹å€‹ã€…ã®ã‚¹ãƒ†ãƒƒãƒ—ã‚’ç¤ºã—ãŸã‚‚ã®ã€‚ Explainã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã§ã€å‚ç…§å¯èƒ½ testdb=# explain select count(id) from master where valid = true; QUERY PLAN ---------------------------------------------------------------------------- Aggregate (cost=217107.05..217107.06 rows=1 width=0) -> Seq Scan on master (cost=0.00..213742.88 rows=1345668 width=0) Filter: valid 4. Explainã¨Explain analyz
yocchi24 2009/10/30
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

SQL
ãƒªãƒ³ã‚¯
Windowé–¢æ•° â€” Let's Postgres
ã¾ãŸã€CREATE FUNCTION æ–‡ã§ãƒ¦ãƒ¼ã‚¶å®šç¾©ã®Windowé–¢æ•°ã‚’è¿½åŠ ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ãŒã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 8.4 ã§ã¯Cè¨€èªžã§é–¢æ•°ã‚’è¨˜è¿°ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚SQLã‚„PL/pgSQLã¯ä½¿ãˆãªã„ã®ã§ã€æ•·å±…ã¯é«˜ã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ä¾‹ å…¸åž‹çš„ãªWindowé–¢æ•°ã®ä½¿ã„æ–¹ã‚’æŒ™ã’ã¾ã™ã€‚ã“ã®ä»–ã«ã‚‚ã€ã“ã‚Œã¾ã§è¤‡é›‘ãªSQLãŒå¿…è¦ã ã£ãŸã•ã¾ã–ã¾ãªã‚±ãƒ¼ã‚¹ã‚’åŠ¹çŽ‡åŒ–ã§ãã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã®ã§ã€SQLãƒ‘ã‚ºãƒ«ã ã¨æ€ã£ã¦è©¦ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ã€‚ é€£ç•ªä»˜ä¸Ž é€£ç•ªä»˜ä¸Žã‚’è¡Œã„ã¾ã™ã€‚ã‚½ãƒ¼ãƒˆã—ãŸå¾Œã€ç•ªå·ã‚’ãµã‚‹ã®ãŒãƒã‚¤ãƒ³ãƒˆã§ã™ã€‚ SELECT row_number() OVER (), * FROM (SELECT * FROM tbl ORDER BY sortkey) AS t; ãŸã ã—ã€çµæžœã®æœ€å¤§è¡Œæ•°ã‚’æŒ‡å®šã™ã‚‹ã«ã¯ã€row_number ã¨ã®å€¤ã®æ¯”è¼ƒã§ã¯ãªãã€ã“ã‚Œã¾ã§ã©ãŠã‚Š LIMIT å¥ã‚’ä½¿ã£ã¦ãã ã•ã„ã€‚row_number
yocchi24 2009/10/29
SQL
ãƒªãƒ³ã‚¯
PostgreSQLã®åˆ†æžé–¢æ•°ã®è¡æ’ƒ1ã€€ï¼ˆãƒ¢ãƒ¼ãƒ‰ã¨ãƒ¡ã‚¸ã‚¢ãƒ³ï¼‰ï¼šCodeZine
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
yocchi24 2009/10/29
SQL

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
OTN Japan - 404 Error
URLãŒä¸‹è¨˜ã®é€šã‚Šå¤‰æ›´ã«ãªã‚Šã¾ã—ãŸã€‚ ãŠæ‰‹æ•°ã§ã™ãŒãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ãªã©ã®å¤‰æ›´ã‚’ãŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚ 10ç§’å¾Œã€è‡ªå‹•çš„ã«ã‚¸ãƒ£ãƒ³ãƒ—ã—ã¾ã™ã®ã§ã—ã°ã‚‰ããŠå¾…ã¡ãã ã•ã„ã€‚ â€»ã‚¸ãƒ£ãƒ³ãƒ—ã—ãªã„å ´åˆã¯ã€ä¸‹è¨˜ã®URLã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ http://www.oracle.com/tech network/jp/index.html
yocchi24 2009/10/29
SQL
ãƒªãƒ³ã‚¯
2ã¤ã®å‰¯å•ã„åˆã‚ã›ã®é•ã„ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
2ã¤ã®å‰¯å•ã„åˆã‚ã›ã®é•ã„ IN æ¡ä»¶ã‹ EXISTS æ¡ä»¶ã‹ NOT IN (ã€œ) ã¨ NOT EXISTS (ã€œ) ã§ã¯å¤šãã®å ´åˆ NOT EXISTS ã®æ–¹ãŒãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã—ã¦é«˜é€Ÿã«ãªã‚‹ã®ã¯æœ‰åã§ã‚ã‚‹ã€‚ ã—ã‹ã—ã€IN ( <å‰¯å•ã„åˆã‚ã›> ) ã¨ EXISTS ( SELECT ã€œ) ã§ãŠäº’ã„ã«ç½®ãæ›ãˆå¯èƒ½ãªå ´åˆã€æžœãŸã—ã¦ã©ã¡ã‚‰ã‚’ä½¿ã†ã®ã‹? ã©ã¡ã‚‰ã§ã‚‚åŒã˜ãªã®ã‹? IN (<å‰¯å•ã„åˆã‚ã›>) ã®å ´åˆ ã€œ2ã¤ã®è¡¨ã® ãƒ•ã‚£ãƒ«ã‚¿å‡¦ç†ã€œ IN ( ã€œ ) ã¯å‰¯å•ã„åˆã‚ã›çµæžœã‚’è¦ªã®å•ã„åˆã‚ã›ã¸ã®ã€Œå…¥åŠ›ãƒ‡ãƒ¼ã‚¿ã€ã¨ã—ã¦çµ„ã¿è¾¼ã¾ã‚Œã¦å®Ÿè¡Œè¨ˆç”»ã•ã‚Œã‚‹ã€‚ å‰¯å•ã„åˆã‚ã›ã§ã®çµæžœã‚’è¦ªã®å•ã„åˆã‚ã›ã«å–ã‚Šè¾¼ã‚“ã§å‡¦ç†ã‚’ã™ã‚‹ã¨è€ƒãˆã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ã“ã®éŽç¨‹ãŒç†è§£ã§ãã‚‹ã¨ NOT IN ( <å‰¯å•ã„åˆã‚ã›> )ãŒã€ NOT EXISTS ã¨æ¯”ã¹ã¦ã€Œå…¥åŠ›ãƒ‡ãƒ¼ã‚¿ã€ãŒå·¨å¤§ã§ã€ã„ã‹ã«ã‚³ã‚¹ãƒˆãŒé«˜ã„å‡¦ç†ã‹æƒ³åƒã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ã—ã‹
yocchi24 2009/10/29
SQL

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

DB

SQL
ãƒªãƒ³ã‚¯
MySQLã§ã®ç´¯ç©é›†è¨ˆ
yocchi24 2009/03/16
ãƒ‡ãƒ¼ã‚¿ãŒå°‘ãªã„å ´åˆã®ç´¯ç©é›†è¨ˆ

SQL
ãƒªãƒ³ã‚¯
HAVINGå¥ã®åŠ›
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
yocchi24 2009/01/07
ä»–ã®ä¸€é€£ã®è¨˜äº‹ã‚‚åˆç´šè€…ï½žä¸ç´šè€…ã«ãŠã‚¹ã‚¹ãƒ¡

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

DB

SQL
ãƒªãƒ³ã‚¯
1