[B! sql] smotokezuruã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

smotokezuru id:smotokezuru

sqlã«é–¢ã™ã‚‹smotokezuruã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

RDBã¨NoSQLã«ã¿ã‚‹DBè¿‘ç¾ä»£å² ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç ´å£Šçš„ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã¯äºŒåº¦èµ·ãã‚‹ã‹ï¼Ÿ - ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢Hubï½œè‹¥æ‰‹Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ã‚ãƒ£ãƒªã‚¢ã‚’è€ƒãˆã‚‹ï¼
ã€Œãƒ¦ãƒ¼ã‚¶ãƒ¼ç›®ç·šã€ã®ã‚·ã‚¹ãƒ†ãƒ ã‚’ç›®æŒ‡ã—ã¦ RDBãŒå¾“æ¥ã®éšŽå±¤åž‹DBã«æ¯”ã¹ã¦å„ªã‚Œã¦ã„ãŸç‚¹ã¯ã„ãã¤ã‹æŒ™ã’ã‚‹ã“ã¨ãŒã§ãã¾ã™ãŒã€ã‚·ã‚§ã‚¢ã‚’ä¼¸ã°ã™ã†ãˆã§æœ€ã‚‚å¤§ããªå½±éŸ¿ã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒä½¿ã„ã‚„ã™ã„ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã¨ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«ã“ã ã‚ã£ãŸã“ã¨ã§ã™ã€‚ã™ãªã‚ã¡ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã€ã¨ã€ŒSQLã€ã®ç™ºæ˜Žã§ã™ã€‚ RDBã§ã¯ã€ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã€ã¨ã„ã†ãŸã ä¸€ã¤ã®ãƒ‡ãƒ¼ã‚¿å½¢å¼ã«ã‚ˆã£ã¦è¡¨ç¾ã—ã¾ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã€è¦‹ãŸç›®ãŒã€ŒäºŒæ¬¡å…ƒè¡¨ã€ã«ä¼¼ã¦ã„ã‚‹ãŸã‚*3ã€Microsoft Excelã‚„Google ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãªã©ã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’ä½¿ã„æ…£ã‚ŒãŸäººãŒè¦‹ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹æ–¹æ³•ãŒç›´è¦³çš„ã«ã‚¤ãƒ¡ãƒ¼ã‚¸ã—ã‚„ã™ã„ã¨ã„ã†åˆ©ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚å®Ÿéš›ã€ã“ã†ã—ãŸäºŒæ¬¡å…ƒè¡¨ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã¯ã€Excelãªã©ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒç™»å ´ã™ã‚‹å‰ã‹ã‚‰ä¸€èˆ¬çš„ãªæ–¹æ³•ã ã£ãŸãŸã‚ã€RDBãŒç™»å ´ã—ãŸå½“æ™‚ã®äººã€…ã«ã¨ã£ã¦ã‚‚å—ã‘å…¥ã‚Œã‚„ã™ã„ã‚‚ã®ã§ã—ãŸã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ãŒç”»æœŸçš„ã ã£ãŸç‚¹ã¯ã€ã‚‚ã†ä¸€ã¤ã‚ã‚Šã¾ã™ã€‚
smotokezuru 2017/11/23
sql
ãƒªãƒ³ã‚¯
æ–°è‘—ãŒå‡ºã¾ã™ï¼šã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQLã‚°ãƒ©ãƒ•åŽŸè«–ã€ - ãƒŸãƒƒã‚¯ã®ãƒ–ãƒã‚°
ä»Šæœˆä¸‹æ—¬ã«ã€J.ã‚»ãƒ«ã‚³ã®ã€ŽTrees and Hierarchies 2nd Editionã€ã®é‚¦è¨³ãŒåˆŠè¡Œã•ã‚Œã¾ã™ã€‚åŒè‘—è€…ã®ä»£è¡¨ä½œã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬4ç‰ˆã€ã®ã‚¹ãƒ”ãƒ³ã‚ªãƒ•ã®ä¸€ã¤ã§ã€RDB/SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ãŸã‚ã®æ–¹æ³•è«–ã«ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã—ãŸãªã‹ãªã‹ãƒžãƒ‹ã‚¢åº¦ã®é«˜ã„ä¸€å†Šã§ã™ã€‚ä¸»çœ¼ã¨ãªã‚‹ã€Œå…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«ã€ã«ã¤ã„ã¦ã¯ã€ç§ã‚‚ã‚ã¡ã“ã¡ã®è¨˜äº‹ã‚„æ›¸ç±ã§ç´¹ä»‹ã—ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã€ã”å˜ã˜ã®æ–¹ã‚‚ã„ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ã‚ˆã‚ŠåŒ…æ‹¬çš„ã‹ã¤ç†è«–é¢ã¾ã§ã‚«ãƒãƒ¼ã—ãŸæœ¬æ ¼æ´¾ã®å†…å®¹ã«ãªã£ã¦ã„ã¾ã™ã€‚ è¡¨ç´™ã®å¥³æ€§ã¯ãƒžãƒªã‚¢æ§˜ã§ã—ã‚‡ã†ã‹ã€‚æœ¬å®¶ã®æ–¹ãŒåˆŠè¡Œã•ã‚ŒãŸã¨ãã‚‚ã€Œã“ã®ãŠã£ã•ã‚“èª°ï¼Ÿã€ã¨ã„ã†è³ªå•ãŒç›¸æ¬¡ãŽã¾ã—ãŸãŒã€ã‚¬ãƒªãƒ¬ã‚ªã¨ã„ã†èª¬ãŒæœ‰åŠ›ãªã‚ˆã†ã§ã™ã€‚ãã†è¨€ã‚ã‚Œã¦ã¿ã‚‹ã¨æœ¬å®¶ã¯ã€Žæ˜Ÿç•Œã®å ±å‘Šã€ã®ã‚ˆã†ãªæ ¼èª¿ã‚’æ„Ÿã˜ã¾ã™ã€‚æœ¬æ›¸ã®æ–¹ã¯ã€é•·ã‚‰ãå®šèª¬ã¨ã•ã‚Œã¦ããŸãƒ¢ãƒ‡ãƒ«ã‚’ã²ã£ãã‚Šè¿”ãã†ã¨ã„ã†æ„å‘³ã§ã¯ã€Žå¤©ä½“ã®å›žè»¢ã«ã¤ã„ã¦ã€ã¿ãŸã„ãªæ€§æ ¼ã‚‚ã‚ã‚‹ã®ã§ã™ãŒã€å¤§åž‹æœ¬
smotokezuru 2016/08/16
sql
ãƒªãƒ³ã‚¯
ã€Œã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯åˆè¦‹ã®æ•µã«ã‚„ã‚‰ã‚Œã¦ã¯ã„ã‘ãªã„ã€DBã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒŸãƒƒã‚¯ã•ã‚“ãŒèªžã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨SQLã®å¦ã³æ–¹
ITæ¥ç•Œã«ãŠã„ã¦æ•°åå¹´ã‚‚ã®é–“ã€å¤§ããªä»•æ§˜å¤‰æ›´ãŒãªãä¸»æµã®æŠ€è¡“ã§ã‚ã‚Šç¶šã‘ã¦ã„ã‚‹ã®ãŒãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨SQLã§ã™ã€‚ã€ŽSQL ç¬¬2ç‰ˆ ã‚¼ãƒã‹ã‚‰ã¯ã˜ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œã€ã®è‘—è€…ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒŸãƒƒã‚¯ã•ã‚“ã¯ã€SQLã‚’å¦ã¹ã°é•·ãå½¹ç«‹ã¤ã‚‚ã®ã®ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é…åŠ›ã¯ãã‚Œè‡ªä½“ã®é¢ç™½ã•ã ã¨ãŠã£ã—ã‚ƒã„ã¾ã™ã€‚ä»Šå›žã€ãƒŸãƒƒã‚¯ã•ã‚“ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å½¹å‰²ã‚„é…åŠ›ã€ãã—ã¦SQLã®å¦ã³æ–¹ã«ã¤ã„ã¦ã†ã‹ãŒã„ã¾ã—ãŸã€‚ ã„ã‚ã„ã‚ãªã‚·ã‚¹ãƒ†ãƒ ã‚’è¦‹ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ãŒé¢ç™½ã„ â€•â€•ãƒŸãƒƒã‚¯ã•ã‚“ã¯ã€ŽSQL ç¬¬2ç‰ˆ ã‚¼ãƒã‹ã‚‰ã¯ã˜ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œã€ã®ã»ã‹ã«ã‚‚ã€ç¿”æ³³ç¤¾ã‹ã‚‰å¤šæ•°å‡ºç‰ˆã•ã‚Œã¦ã„ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨SQLã®æ›¸ç±ãŒä¸»ã§ã™ãŒã€æ™®æ®µã¯ã©ã†ã„ã£ãŸä»•äº‹ã‚’ã•ã‚Œã¦ã„ã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€‚ ãƒŸãƒƒã‚¯ï¼šç§ã¯SIerã«å‹¤ã‚ã¦ã„ã¦ã€ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã¨ã„ã†ã‚ˆã‚Šã¯ã€ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã§ãƒˆãƒ©ãƒ–ãƒ«ãŒèµ·ããŸã¨ãæ”¯æ´ã‚’è¡Œãªã†ãƒãƒ¼ãƒ ã«æ‰€å±žã—ã¦ã„ã¾ã™ã€‚ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’é«˜ã‚ã‚‹ã“ã¨ãŒ
smotokezuru 2016/06/28
sql

ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼
ãƒªãƒ³ã‚¯
DBã®è‡ªå‹•é€£ç•ªãŒãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã—ã¦ã‚‚æˆ»ã‚‰ãªã„ç†ç”± - C Sharpens you up
DBã®ä¸»ã‚ãƒ¼ã‚«ãƒ©ãƒ ã«è‡ªå‹•é€£ç•ªï¼ˆMySQLãªã‚‰AUTO_INCREMENTã€SQL Serverãªã‚‰IDENTITYã€Oracleã‚„PostgreSQLãªã‚‰ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ï¼‰ã‚’è¨å®šã—ã¦ã„ã‚‹ã¨ã€åŸºæœ¬çš„ã«ã¯é€£ç¶šã—ãŸæ•°å—ãŒä»˜ç•ªã•ã‚Œã¦ã„ãã®ã§ã™ãŒã€è¡Œå‰Šé™¤ã‚‚ã—ã¦ã„ãªã„ã®ã«æŠœã‘ç•ªãŒç™ºç”Ÿã™ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ INSERTãŒåˆ¶ç´„ã«ã²ã£ã‹ã‹ã£ã¦å¤±æ•—ã—ãŸ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã—ãŸ ãªã©ã®å ´åˆã§ã™ã€‚ ç‰¹ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã¯ã€DBå…¨ä½“ã®å¤‰æ›´ã‚’ãªã‹ã£ãŸã“ã¨ã«ã™ã‚‹ã¯ãšãªã®ã«é€£ç•ªã ã‘ã¯é€²ã‚“ã ã¾ã¾æˆ»ã‚‰ãªã„ã¨ã„ã†ã“ã¨ã§ã€çŸ¥ã‚‰ãªã„ã¨é•å’Œæ„ŸãŒã‚ã‚‹ã‚‚ã®ã§ã™ã€‚ é€£ç•ªãŒæˆ»ã‚‰ãªã„ç†ç”± PostgreSQLã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒã“ã†èª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ åŒä¸€ã®ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ã‹ã‚‰æ•°å€¤ã‚’å–å¾—ã™ã‚‹åŒæ™‚å®Ÿè¡Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åŒå£«ã®ãƒ–ãƒãƒƒã‚¯ã‚’é˜²æ¢ã™ã‚‹ãŸã‚ã€nextvalæ¼”ç®—ã¯æ±ºã—ã¦ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã•ã‚Œã¾ã›ã‚“ã€‚ http://www.postgresq
smotokezuru 2015/05/19
sql
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€Œå¥å¿˜ç—‡çš„ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã€ã®ææ¡ˆ - æ¥µåŒ—ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ ä½œè€…: Bill Karwin,å’Œç”°å“äºº,å’Œç”°çœäºŒ,å…å³¶ä¿®å‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: ã‚ªãƒ©ã‚¤ãƒªãƒ¼ã‚¸ãƒ£ãƒ‘ãƒ³ç™ºå£²æ—¥: 2013/01/26ãƒ¡ãƒ‡ã‚£ã‚¢: å¤§åž‹æœ¬è³¼å…¥: 9äºº ã‚¯ãƒªãƒƒã‚¯: 698å›žã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (46ä»¶) ã‚’è¦‹ã‚‹æœ¬æ›¸ã®è‘—è€…ã¯ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã«å¯¾ã—ã¦æ¶ˆæ¥µçš„ãªã®ã ã‹ã‚‰ã€ã€Œã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã®ä½¿ã„æ–¹ãŒãŠã‹ã—ã„ã€ã¨ã‹è¨€ã†ã®ã¯ãŠé–€é•ã„ãªã®ã‹ã‚‚ã—ã‚Œãªã„ãŒ... å¥å¿˜ç—‡çš„ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ ã€ŒSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ç¬¬3ç« ã®è¨˜è¿°ã‚’ç·åˆã™ã‚‹ã¨ã€è‘—è€…ã¯ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã«ã¤ã„ã¦ä»¥ä¸‹ã®ã‚ˆã†ã«è€ƒãˆã¦ã„ã‚‹ã¨æ€ã†ã€‚ è‡ªç„¶ã‚ãƒ¼ã®ä¸€æ„æ€§ãƒ»ä¸å¤‰æ€§ãŒå½“ã¦ã«ãªã‚‰ãªã„å ´åˆã«ã€Œè‡ªç„¶ã‚ãƒ¼ã®å¤‰æ›´ã®å½±éŸ¿ã‚’å—ã‘ãªã„ã‚ˆã†ã«ã™ã‚‹ã€ã¨ã„ã†ç›®çš„ã§ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã‚’å°Žå…¥ã™ã‚‹ã€‚ è‡ªç„¶ã‚ãƒ¼ã®é‡è¤‡ã‚’é˜²ããŸã‚ã«ã€è‡ªç„¶ã‚ãƒ¼ã«UNIQUEã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æŒ¯ã‚‹ã“ã¨ã‚’æŽ¨å¥¨ã™ã‚‹ã€‚ è‡ªç„¶ã‚ãƒ¼ã®ä»£ã‚ã‚Šã«ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã‚’å¤–éƒ¨ã‚ãƒ¼ã«ã™ã‚‹ã€‚è‡ªç„¶ã‚ãƒ¼ã¯ä»–ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«è»¢
smotokezuru 2013/03/29
sql
ãƒªãƒ³ã‚¯
1