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

seikenn id:seikenn

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

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

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

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MongoDBã®æ§˜ãªNoSQLã«å‹¢ã„ãŒã‚ã‚‹ã®ã¯ä½•æ•…ã§ã™ã‹ï¼ŸSQLã¨æ¯”ã¹ã¦ã©ã‚“ãªåˆ©ç‚¹ã‚„æ¬ ç‚¹ãŒã‚ã‚Šã¾ã™ã‹ï¼Ÿ - Quora
å›žç” (3ä»¶ä¸ã®1ä»¶ç›®) ãƒã‚¤ãƒ—ã‚µã‚¤ã‚¯ãƒ«ã¨ã„ã†æ¦‚å¿µã‚’Gartnerã‚°ãƒ«ãƒ¼ãƒ—ãŒæå”±ã—ã¦ã¾ã—ã¦ã€æ§˜ã€…ãªæµè¡Œã‚Šã‚¹ã‚¿ãƒªã®ã‚µã‚¤ã‚¯ãƒ«ã‚’åˆ†æžã™ã‚‹æ¨™æº–çš„ãªæ–¹æ³•ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ãƒã‚¤ãƒ—ã¨ã¯éŽåº¦ãªæœŸå¾…ã‚„ç†±ç‹‚ã‚’æ„å‘³ã™ã‚‹è¨€è‘‰ã§ã™ã€‚ä¸€ç™ºå±‹èŠ¸äººã®äººæ°—ã®ã‚«ãƒ¼ãƒ–ã¿ãŸã„ãªã‚‚ã®ã§ã€ãƒ†ãƒ„andãƒˆãƒ¢ã¿ãŸã„ã«å®‰å®šã™ã‚‹å ´åˆã¨ã€æ¶ˆãˆã¦ã„ãã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚èŠ¸äººã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒDA PUMPã¯ä¸€èŒ¶ã®äººé–“æ€§ã‚‚ã‚ã‚Šã¾ã—ã¦ã€æ¬¡ã¯åŽ³ã—ã„ã‘ã©å®šç€ã™ã‚‹ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ãªã‚“ã ã‹ã®ãƒˆãƒªã‚¬ãƒ¼ã§è©•ä¾¡ãŒä¸ŠãŒã‚Šå§‹ã‚ã€ãƒ”ãƒ¼ã‚¯ã‚’è¿Žãˆã‚‹ã€‚ãã®å¾Œè©•ä¾¡ãŒä¸‹ãŒã£ã¦ã„ãã€åº•ã‚’æ‰“ã¤ã¨å°‘ã—ä¸ŠãŒã£ã¦å®šç€ã™ã‚‹ã¨ã„ã†çµŒéŽã‚’ãŸã©ã‚‹ã¨ã—ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¨åŒã˜ãƒ¢ãƒ‡ãƒ«ã§ã€æµè¡Œã‚Šã®ãƒã‚¤ãƒ†ã‚¯...
seikenn 2019/08/27
NoSQL

SQL

RDB
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
seikenn 2011/01/31
SQL
ãƒªãƒ³ã‚¯
ãƒ©ãƒ³ã‚ãƒ³ã‚°ã®ã¤ãã‚Šã‹ãŸ:Kenn's Clairvoyance
é…ã‚Œã°ã›ãªãŒã‚‰ã€ã‚ã‘ã¾ã—ã¦ãŠã‚ã§ã¨ã†ã”ã–ã„ã¾ã™ã€‚ å…ˆé€±ã«ã¯ã€ãƒ™ã‚¤ã‚¨ãƒªã‚¢ã®å‹äººãŸã¡ãŒã‚„ã£ã¦ã„ã‚‹EchofonãŒPostUpã«è²·åŽã•ã‚Œã‚‹ãªã©ã€å¹¸å…ˆã®ã‚ˆã„æ–°å¹´ã®ã‚¹ã‚¿ãƒ¼ãƒˆã¨ãªã‚Šã¾ã—ãŸã€‚ ã•ã¦ã€æœ€è¿‘ãƒ›ãƒƒãƒˆãªãƒžãƒ¼ã‚±ãƒƒãƒˆã¨ã„ãˆã°ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã§ã™ãŒã€ã‚²ãƒ¼ãƒ ã¨ã„ãˆã°ãƒªãƒ¼ãƒ€ãƒ¼ãƒœãƒ¼ãƒ‰ã€‚ãƒã‚¤ã‚¹ã‚³ã‚¢ã®ãƒ©ãƒ³ã‚ãƒ³ã‚°ã§å‹äººã‚„è¦‹çŸ¥ã‚‰ã¬äººãŸã¡ã¨ç«¶ã†ã®ã¯ã€ãƒ“ãƒ‡ã‚ªã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸ1970å¹´ä»£ã‹ã‚‰æ¬ ã‹ã›ãªã„è¦ç´ ã§ã—ãŸã€‚ ã¨ã“ã‚ãŒã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆçµŒç”±ã§100ä¸‡äººè¦æ¨¡ã®ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ãŒã¤ãªãŒã‚‹ã‚ˆã†ã«ãªã£ã¦ããŸç¾åœ¨ã€ãã®å…¨ä½“ã‚’ãƒ©ãƒ³ã‚ãƒ³ã‚°ã¥ã‘ã™ã‚‹ã®ã¯ã€æŠ€è¡“çš„ã«ã‚‚å¤§ããªãƒãƒ£ãƒ¬ãƒ³ã‚¸ã¨ãªã£ã¦ãã¾ã—ãŸã€‚ ä»Šå›žã¯ã€ãã®ãƒªãƒ¼ãƒ€ãƒ¼ãƒœãƒ¼ãƒ‰ã®ã¤ãã‚Šã‹ãŸã«ã¤ã„ã¦ã€ã¼ãã‚‰ã®ä½œã£ã¦ã„ã‚‹ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãƒ»ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ã‚ã‚‹Pankiaã®é‹ç”¨ã§å¾—ã‚‰ã‚ŒãŸçŸ¥è¦‹ã‚’å…±æœ‰ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ è‡ªåˆ†ã®é †ä½ã‚’çŸ¥ã‚‹æ–¹æ³• ãƒªãƒ¼ãƒ€ãƒ¼ãƒœãƒ¼ãƒ‰ã®åŸºæœ¬çš„ãªè€ƒãˆæ–¹ã¯ã‚·ãƒ³ãƒ—ãƒ«ã§ã€ãã‚Œã¯ã¤ã¾ã‚Šã€Œãƒ¦
seikenn 2011/01/16
ãƒ©ãƒ³ã‚ãƒ³ã‚°

SQL
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
seikenn 2011/01/09
SQL
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ä½•ã‹ï¼Ÿãã®æ£ä½“ã¨ã‚¯ãƒ©ãƒƒã‚ãƒ³ã‚°å¯¾ç–ã€‚
ä¸–é–“ã§ã¯ã€ä»ŠGumblarç¥ã‚ŠãŒå‹ƒç™ºä¸ã§ã‚ã‚Šã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ãŒãƒ‹ãƒ¥ãƒ¼ã‚¹ã«å‡ºã¦ãã‚‹ã“ã¨ã¯å°‘ãªããªã£ãŸãŒã€ã ã‹ã‚‰ã¨è¨€ã£ã¦SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„…å¨ãŒãªããªã£ãŸã‚ã‘ã§ã¯ãªã„ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¯Gumblarã‚’ä»•æŽ›ã‘ã‚‹æ‰‹æ®µã¨ã—ã¦ã‚‚åˆ©ç”¨ã•ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æä¾›ã™ã‚‹å…¨ã¦ã®äººã«ã¨ã£ã¦ã€å¯¾ç–ã‚’è¬›ã˜ãªã‘ã‚Œã°ã„ã‘ãªã„é©šç•°ã§ã‚ã‚‹ã“ã¨ã«å¤‰ã‚ã‚Šã¯ãªã„ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã„ã†æ”»æ’ƒæ‰‹æ³•ãŒèªè˜ã•ã‚Œã€å¤§ã„ã«æ‚ªç”¨ã•ã‚Œã¦ã„ã‚‹ã«ã‚‚ä¿‚ã‚ã‚‰ãšã€ãã®æœ¬è³ªã«è¿«ã£ã¦è§£èª¬ã—ã¦ã„ã‚‹è¨˜äº‹ã¯å°‘ãªã„ã‚ˆã†ã«æ€ã†ã€‚å¾“æ¥ã®Webå±‹ã ã‘ã§ãªãã€ä»Šã‚„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã®ä¸»æˆ¦å ´ã¯Webã§ã‚ã‚‹ã¨è¨€ã£ã¦ã‚‚éŽè¨€ã§ã¯ãªãã€ãã†ã„ã†æ„å‘³ã§ã¯SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ç†è§£ã™ã‚‹ã“ã¨ã¯ã€å…¨ã¦ã®ãƒ—ãƒã‚°ãƒ©ãƒžã«ã¨ã£ã¦ã®å—œã¿ã§ã‚ã‚‹ã¨è¨€ãˆã‚‹ã ã‚ã†ã€‚ ã¨ã„ã†ã‚ã‘ã§ã€ä»Šæ—¥ã¯æ”¹ã‚ã¦SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦èªžã£ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ SQLã‚¤ãƒ³
seikenn 2010/01/14
SQL

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

sqlã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
è„†å¼±æ€§ã‚’åˆ©ç”¨ã—ãŸæ”»æ’ƒæ‰‹æ³•ï¼ˆ4ï¼‰ --- SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³
ãƒã‚¤ãƒ³ãƒˆ â—SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ï¼ŒWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ä¸æ£ãªSQLæ–‡ã‚’å®Ÿè¡Œã•ã›ã‚‹ã“ã¨ã«ã‚ˆã‚Šï¼Œãƒ‡ãƒ¼ã‚¿ã‚’æ”¹ã–ã‚“ã—ãŸã‚Šç ´å£Šã™ã‚‹æ‰‹æ³•ã®ã“ã¨ã§ã‚ã‚‹ã€‚OSã‚³ãƒžãƒ³ãƒ‰ãƒ»ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚„ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãƒ»ãƒˆãƒ©ãƒãƒ¼ã‚µãƒ«ã¨åŒæ§˜ã«ï¼ŒWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ã‚’çªã„ãŸæ”»æ’ƒæ‰‹æ³•ã§ã‚ã‚‹ â—å …ç‰¢ãªWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹ç™ºã™ã‚‹ãŸã‚ã«ã¯ï¼Œã‚»ã‚ãƒ¥ã‚¢ãƒ»ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æŠ€æ³•ã‚’å¦ã¶ã“ã¨ã¯ã‚‚ã¡ã‚ã‚“ï¼Œã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¦ç´„ã®æ•´å‚™ã‚„ãƒ¬ãƒ“ãƒ¥ãƒ¼ã®å®Ÿæ–½ãªã©ï¼Œé–‹ç™ºä½“åˆ¶ã‚’æ•´ãˆã‚‹ã“ã¨ã‚‚é‡è¦ã§ã‚ã‚‹ å‰å›žã¯Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ã‚’åˆ©ç”¨ã™ã‚‹æ”»æ’ƒæ‰‹æ³•ã¨ã—ã¦ï¼Œã€Œãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãƒ»ãƒˆãƒ©ãƒãƒ¼ã‚µãƒ«ã€ã¨ã€ŒOSã‚³ãƒžãƒ³ãƒ‰ãƒ»ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã‚’å‹‰å¼·ã—ã¾ã—ãŸã€‚ä»Šå›žã¯ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã®æ‰‹æ³•ã‚’å¦ã³ã¾ã™ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚‚Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ï¼ˆï¼å…¥åŠ›ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã™ã‚‹è€ƒæ…®ä¸è¶³ï¼Œã‚ã‚‹ã„ã¯å‡¦ç†å¿˜ã‚Œï¼‰ã‚’çªã„ãŸæ”»æ’ƒæ‰‹æ³•ã§ã™ã€‚ SQLã¨ã¯ SQLï¼ˆst
seikenn 2009/12/08
SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
ï¼ ITï¼šWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«æ½œã‚€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ›ãƒ¼ãƒ«ï¼ˆ2ï¼‰- Page1
é¡§å®¢ãƒ‡ãƒ¼ã‚¿ãŒã™ã¹ã¦ç›—ã¾ã‚Œã‚‹ï¼Ÿï¼ï½žOSã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®æ”»æ’ƒï½žï¼šWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«æ½œã‚€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ›ãƒ¼ãƒ«ï¼ˆ2ï¼‰ï¼ˆ1/2 ãƒšãƒ¼ã‚¸ï¼‰ â€»ã”æ³¨æ„ ä»–ç¤¾ãŠã‚ˆã³ä»–çµ„ç¹”ã®Webã‚µã‚¤ãƒˆãªã©ã¸ã®ãƒãƒ¼ãƒˆã‚¹ã‚ãƒ£ãƒ³ãŠã‚ˆã³ãƒ‡ãƒ¼ã‚¿ã®å–å¾—ãªã©ã®è¡Œç‚ºã§å¾—ãŸæƒ…å ±ã‚’ä¾µå…¥ãªã©ã«æ‚ªç”¨ã™ã‚‹ã‹ã€ã¾ãŸã¯åŒã˜ç›®çš„ã‚’æŒã¤ç¬¬ä¸‰è€…ã«æä¾›ã—ãŸæ™‚ç‚¹ã§é•æ³•ã¨ãªã‚Šã¾ã™ã€‚ã”æ³¨æ„ãã ã•ã„ã€‚ æœ¬ç¨¿ã®å†…å®¹ã‚’æ¤œè¨¼ã™ã‚‹å ´åˆã¯ã€å¿…ãšå½±éŸ¿ã‚’åŠã¼ã•ãªã„é™ã‚‰ã‚ŒãŸç’°å¢ƒä¸‹ã§è¡Œã£ã¦ä¸‹ã•ã„ã€‚ ã¾ãŸã€æœ¬ç¨¿ã‚’åˆ©ç”¨ã—ãŸè¡Œç‚ºã«ã‚ˆã‚‹å•é¡Œã«é–¢ã—ã¾ã—ã¦ã¯ã€ç†è€…ãŠã‚ˆã³æ ªå¼ä¼šç¤¾ã‚¢ãƒƒãƒˆãƒžãƒ¼ã‚¯ãƒ»ã‚¢ã‚¤ãƒ†ã‚£ã¯ä¸€åˆ‡è²¬ä»»ã‚’è² ã„ã‹ãã¾ã™ã€‚ã”äº†æ‰¿ãã ã•ã„ã€‚ ã€Œç¬¬1å›ž ã‚µãƒ¼ãƒã®ãƒ•ã‚¡ã‚¤ãƒ«ãŒä¸¸è¦‹ãˆï¼Ÿï¼ã€ã§ã¯ã€ã€ŒForceful Browsingï¼ˆå¼·åˆ¶çš„ãƒ–ãƒ©ã‚¦ã‚ºï¼‰ã€ã‚„ã€ŒPath Traversalï¼ˆãƒ‘ã‚¹ã®ä¹—ã‚Šè¶Šãˆï¼‰ã€ã«ã‚ˆã£ã¦ã€ä»»æ„ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿å‡ºã•ã‚Œã¦ã—ã¾ã†å±é™ºæ€§ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã€‚ ä»Šå›žã¯ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§
seikenn 2009/12/08
SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ - Wikipedia
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ï¼ˆè‹±: SQL injectionï¼‰ã¨ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ä¸Šã®ä¸å‚™ã‚’æ„å›³çš„ã«åˆ©ç”¨ã—ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒæƒ³å®šã—ãªã„SQLæ–‡ã‚’å®Ÿè¡Œã•ã›ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã‚’ä¸æ£ã«æ“ä½œã™ã‚‹æ”»æ’ƒæ–¹æ³•ã®ã“ã¨ã€‚ã¾ãŸã€ãã®æ”»æ’ƒã‚’å¯èƒ½ã¨ã™ã‚‹è„†å¼±æ€§ã®ã“ã¨ã§ã‚ã‚‹ã€‚ SQLã«åˆ¥ã®SQLæ–‡ãŒã€Œæ³¨å…¥ (inject)ã€ã•ã‚Œã‚‹ã“ã¨ã‹ã‚‰ã€ã€Œãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆSQLã‚³ãƒžãƒ³ãƒ‰ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã‚‚ã—ãã¯ã€ŒSQLæ³¨å…¥ã€ã¨å‘¼ã°ã‚Œã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã€‚
seikenn 2009/12/08
SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
sqlã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ - Google æ¤œç´¢
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã¨ã¯ã€Webã‚µã‚¤ãƒˆã‚„Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ï¼ˆ=å¼±ç‚¹ï¼‰ã«ã¤ã‘ã“ã¿ã€ŒSQLï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ãŸã‚ã®è¨€èªžï¼‰ã€ã‚’ç”¨ã„ã¦ã€ä¸æ£ãªSQLæ–‡ã‚’ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã‚Šã€å€‹äººæƒ…å ±ã®çªƒå–ã‚„ãƒ‡ãƒ¼ã‚¿æ”¹ã–ã‚“ãªã©ã‚’è¡Œã†ã‚µã‚¤ãƒãƒ¼æ”»æ’ƒæ‰‹æ³•ã§ã™ã€‚
seikenn 2009/12/06
ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

SQL

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

æ¤œç´¢çµæžœ
ãƒªãƒ³ã‚¯
SQL -TECHSCORE-
ã“ã“ã§ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ãŸã‚ã«å¿…é ˆã¨ãªã‚‹ä¸–ç•Œæ¨™æº–è¨€èªž SQL ã«ã¤ã„ã¦ã€åŸºç¤Žã‹ã‚‰å¿œç”¨ã¾ã§è©³ã—ãèª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ ã¾ãŸã€SQL ã®ã¿ã«ã¨ã©ã¾ã‚‰ãšã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžãƒãƒ¼ã‚¸ãƒ¡ãƒ³ãƒˆã‚·ã‚¹ãƒ†ãƒ (RDBMS) ã®æŒã¤æ§˜ã€…ãªæ©Ÿèƒ½ã«ã¤ã„ã¦è©³ã—ãèª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ æœ€å¾Œã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆã«é–¢ã™ã‚‹éžå¸¸ã«é‡è¦ãªè€ƒãˆæ–¹ã«ã¤ã„ã¦ã‚‚è§¦ã‚Œã¦ã„ã¾ã™ã®ã§ã€ã“ã‚Œã‚‰ã‚’å…¨ã¦å¦ç¿’ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œã‹ã‚‰è¨è¨ˆã¾ã§å¹…åºƒã„çŸ¥è˜ã‚’èº«ã«ã¤ã‘ã‚‹ã“ã¨ãŒã§ãã‚‹ã§ã—ã‚‡ã†ã€‚ SQL INDEX 1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¦‚è¦ 1.1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ 1.2. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®ç‰¹å¾´ 1.3. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ•ã‚¡ã‚¤ãƒ«ã®é•ã„ 1.4. ä»£è¡¨çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« 1.5. ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 1.6. ã¾ã¨ã‚ 2. SQL 2.1. SQL ã®æ´å² 2.2. SQL ã¨ã¯ 2.3. SQL ã®æ©Ÿèƒ½ 2.
seikenn 2009/11/05
ã“ã‚Œã‚ã‹ã‚Šã‚„ã™ã„ãª

SQL
ãƒªãƒ³ã‚¯
1