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

tarbo id:tarbo

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

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

trdsqlã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã‚’ä½œã£ãŸ - Qiita
trdsqlã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã‚’ä½œã‚Šã¾ã—ãŸã€‚ Goã§ä½œã£ã¦ã¾ã™ã€‚ githubã® trdsqlã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å‡ºæ¥ã¾ã™ã€‚ ã¾ãŸLinux/Windows/macOSã®ãƒã‚¤ãƒŠãƒªã‚‚ã‚ã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã¯ã€å¤ããªã£ã¦ã„ã‚‹å†…å®¹ã‚‚ã„ãã¤ã‹ã‚ã‚Šã¾ã™ã€‚ æœ€æ–°ç‰ˆã«å¯¾å¿œã—ãŸã€ã‚ˆã‚Šè©³ç´°ãªå†…å®¹ã¯ trdsql ç›®æ¬¡ | Noboru Saito's page ã‚’å‚ç…§ã—ã¦ä¸‹ã•ã„ã€‚ ã“ã‚Œã¯ä½•ï¼Ÿ ç°¡å˜ã«è¨€ãˆã°CSV(TSVå«ã‚€)ã‚„LTSVã«å¯¾ã—ã¦SQLã‚’å®Ÿè¡Œã§ãã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ åŒæ§˜ã®ãƒ„ãƒ¼ãƒ«ãŒ q ã‚„ textql ç‰ã„ãã¤ã‹ã‚ã‚Šã¾ã™ã€‚ trdsqlã¯PostgreSQLãƒ‰ãƒ©ã‚¤ãƒã¨MySQLãƒ‰ãƒ©ã‚¤ãƒã‚’å«ã‚“ã§ã„ã¦å®Ÿéš›ã«DBã«æŽ¥ç¶šã™ã‚‹ã“ã¨ã§SQLiteä»¥ä¸Šã®æ©Ÿèƒ½ã‚’ä½¿ç”¨ã§ãã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ PostgreSQLã‚„MySQLã®æ§‹æ–‡ãŒä½¿ãˆã‚‹ã ã‘ã§ã¯ãªãã€CSVãƒ•ã‚¡ã‚¤ãƒ«ã¨å®Ÿãƒ†ãƒ¼ãƒ–ãƒ«ã§JOINã—ãŸã‚Šã€CSVãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ãƒ†ãƒ¼ãƒ–
tarbo 2017/08/20
qiita

sql
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ å¹»ã®ç¬¬26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ 26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€ 2015/08/31 @ GMO Yours #ronsakucasual https://atnd.org/events/68902Read less
tarbo 2015/09/01
sql

slide
ãƒªãƒ³ã‚¯
æ–°è‘—ãŒå‡ºã¾ã™ï¼šã€ŽSQLå®Ÿè·µå…¥é–€ã€ - ãƒŸãƒƒã‚¯ã®ãƒ–ãƒã‚°
4æœˆä¸æ—¬ã“ã‚ã«ãªã‚Šã¾ã™ãŒã€æ–°è‘—ãŒå‡ºã¾ã™ã€‚SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ä¸»é¡Œã«ã—ãŸæœ¬ã§ã€å®Ÿè¡Œè¨ˆç”»ã‚’èªã‚€ã“ã¨ã§ã€ãªãœã“ã®SQLã¯é…ã„ã®ã‹ã€ã‚ã‚‹ã„ã¯é€Ÿã„ã®ã‹ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã¾ã§æŠŠæ¡ã—ã¦ç†è§£ã—ã‚ˆã†ã€ã¨ã„ã†è¶£æ—¨ã§ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†ã®ã¯ã€SQLã¨ã„ã†è‡ªç„¶è¨€èªžã‚’æ¨¡ã—ãŸã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«ã‚ˆã£ã¦ã€ä½Žæ¬¡ã®ãƒ¬ã‚¤ãƒ¤ãƒ¼ã‚’éš è”½ã™ã‚‹æ„å›³ã§ä½œã‚‰ã‚ŒãŸãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ãªã®ã§ã€æœ¬å½“ã¯å®Ÿè¡Œè¨ˆç”»ãªã©ã¨ã„ã†æ‰‹ç¶šãƒ¬ãƒ™ãƒ«ã®ä¸–ç•Œã‚’ãƒ¦ãƒ¼ã‚¶ãŒè¦—ãè¦‹ã‚‹ã®ã¯ã€æœ¬æœ«è»¢å€’ãªã¨ã“ã‚ã‚‚ã‚ã‚Šã¾ã™ã€‚ãŸã ãã†ã¯ã„ã£ã¦ã‚‚ã€ç¾å®Ÿã«SQLãŒé…ã‹ã£ãŸã‚‰åŽŸå› ã‚’è§£æžã›ã–ã‚‹ã‚’ãˆãªã„ã‚ã‘ã ã—ã€å¤§ä½“æœ¬å½“ã«ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã«ã—ãŸã„ãªã‚‰ã€ãªã‚“ã§ã©ã®DBMSã‚‚å®Ÿè¡Œè¨ˆç”»ã‚’è¦‹ã‚‰ã‚Œã‚‹æ‰‹æ®µãªã‚“ã‹ç”¨æ„ã—ã¦ã‚‹ã‚“ã§ã—ã‚‡ã†ãä¸æ€è°ã§ã™ãã€ã¨ã„ã†ç†æƒ³ã¨ç¾å®Ÿã®ç‹é–“ã§æ‚©ã‚€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã€…ã«å°‘ã—ã§ã‚‚ãƒ™ã‚¿ãƒ¼ãªè§£ã«è¾¿ã‚Šã¤ã‘ã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’æç¤ºã§ãã‚Œã°ã€ã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã¾ãˆãŒãã¨ç« ç«‹ã¦ã§ã™ã€‚
tarbo 2015/03/29
sql

book
ãƒªãƒ³ã‚¯
xRef - Database
$ sqlplus $ sqlplus myuser@myhost $ sqlplus myuser/xxxxx@myhost $ sqlplus myuser/xxxxx@myhost/xe
tarbo 2015/01/11
db

mysql

postgresql

sql
ãƒªãƒ³ã‚¯
é–‹ç™ºè€…ã®ãŸã‚ã®SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å…¨ã¦
å‰æ›¸ã - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆã¯ãªãœé–‹ç™ºè€…ã®ã‚¿ã‚¹ã‚¯ãªã®ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã® å†…éƒ¨æ§‹é€ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ä½•ã«ä¼¼ã¦ã„ã‚‹ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ - äºŒé‡é€£çµãƒªã‚¹ãƒˆ æ¤œç´¢ ãƒ„ãƒªãƒ¼(Bãƒ„ãƒªãƒ¼) - ãƒãƒ©ãƒ³ã‚¹æœ¨ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆI - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é…ãã™ã‚‹2ã¤ã®åŽŸå› where å¥ - æ¤œç´¢ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ãŸã‚ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆ ç‰ä¾¡ æ¼”ç®—å - ä¸€è‡´ã™ã‚‹ã‚ãƒ¼ã®æ¤œç´¢ ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ã„æ–¹ã‚’ç¢ºèª è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - è¤‡æ•°åˆ—ã«å¯¾ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆII - å‰ã®å•é¡Œç‚¹ãŒå†ã³ é–¢æ•° - whereå¥ã® ä¸ã§ã®é–¢æ•° å¤§æ–‡å—ãƒ»å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ æ¤œç´¢ - UPPERã¨ LOWER ãƒ¦ãƒ¼ã‚¶å®šç¾© é–¢æ•° - é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åˆ¶é™ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚ŠéŽãŽ - å†—é•·æ€§ã®æŽ’é™¤æ³• ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿åŒ– ã‚¯ã‚¨ãƒª - ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ãŸã‚ã« ç¯„å›² æ¤œ
tarbo 2014/10/19
db

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

security
ãƒªãƒ³ã‚¯
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ã¤ã®ãƒ•ã‚¡
tarbo 2012/09/08
linux

sql
ãƒªãƒ³ã‚¯
SQL vs NoSQLã€ã‚°ãƒ¼ã‚°ãƒ«ã«ãŠã‘ã‚‹æˆ¦ã„ï¼ˆå‰ç·¨ï¼‰ã€‚Google I/O 2012
SQLã¨NoSQLã§ã¯ã©ã¡ã‚‰ãŒå„ªã‚Œã¦ã„ã‚‹ã®ã‹ï¼Ÿ ã‚°ãƒ¼ã‚°ãƒ«ã®æ‹…å½“è€…ãŒãƒ‡ã‚£ãƒ™ãƒ¼ãƒˆï¼ˆã¨ã„ã†ã‚ˆã‚Šå°èŠå±…ï¼š-ï¼‰ã‚’è¡Œã£ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒGoogle I/O 2012 - SQL vs NoSQL: Battle of the Backends - YouTubeã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¯ã€å…ˆã€…é€±é–‹å‚¬ã•ã‚ŒãŸGoogle I/O 2012ã§è¡Œã‚ã‚ŒãŸã‚‚ã®ã€‚SQLã¨NoSQLã«ã¯æ©Ÿèƒ½çš„ã«ã©ã®ã‚ˆã†ãªé•ã„ãŒã‚ã‚Šã€ã©ã†ä½¿ã„åˆ†ã‘ã‚‹ã¹ããªã®ã‹ã€æ˜Žç¢ºãªèª¬æ˜ŽãŒå‚è€ƒã«ãªã‚Šã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ¡ãƒªãƒƒãƒˆ ã‚°ãƒ¼ã‚°ãƒ«ã®Alfred Fulleræ°ï¼ˆNoSQLæ‹…å½“ï¼‰ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã¯ãƒ•ã‚©ãƒ«ãƒˆãƒˆãƒ¬ãƒ©ãƒ³ãƒˆã§ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ä¸è¦ã€ãƒ‘ãƒƒãƒã‚‚ç§ãŸã¡ãŒé©ç”¨ã—ã¦ãŠã‚Šã€åˆ©ç”¨è€…ã¯é‹ç”¨ã«ã¤ã„ã¦å¿ƒé…ã™ã‚‹å¿…è¦ãŒãªã„ã€ã¨ã„ã£ãŸãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„åœ°åŸŸåˆ†æ•£ã§ãƒ‡ãƒ¼ã‚¿ã‚‚ä¿å…¨ã•ã‚Œã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒ
tarbo 2012/07/10
nosql

sql

*ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ç™ºæƒ³ã§ä½œã£ãŸOSS-DBã®æ•™ç§‘æ›¸ã‚’ç„¡å„Ÿå…¬é–‹ ï¼ ï¼ IT
2011/10/05 ã‚¨ãƒ«ãƒ”ãƒ¼ã‚¢ã‚¤ã‚¸ãƒ£ãƒ‘ãƒ³ï¼ˆLPI-Japanï¼‰ã¯10æœˆ5æ—¥ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆå¿ƒè€…å‘ã‘ã®æ•™ç§‘æ›¸ã€Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¨™æº–æ•™ç§‘æ›¸ã€€-PostgreSQL-ã€(Ver1.0.0ï¼‰ã‚’Webä¸Šã§ç„¡å„Ÿå…¬é–‹ã—ãŸã€‚ã‚¢ãƒ³ã‚±ãƒ¼ãƒˆã«ç”ãˆã‚‹ã¨ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ãƒ‡ãƒ¼ã‚¿ã¯PDFç‰ˆã¨EPUBç‰ˆã®2ç¨®é¡žãŒã‚ã‚‹ã€‚ ç‰¹å®šæŠ€è¡“ã«ã—ã°ã‚‰ã‚Œãªã„ã€æ±Žç”¨æ€§ãŒé«˜ã„SQLã®çŸ¥è˜ã‚’ æœ¬æ•™ç§‘æ›¸ã¯ã€ã€Œã“ã‚Œã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ã³å§‹ã‚ã‚‹åˆå¿ƒè€…ã€ã‚’å¯¾è±¡ã«ã€ã€ŒSQLè¨€èªžã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã¨ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆã‚„ç®¡ç†ã€ã‚’â€œã§ãã‚‹ã ã‘åˆ†ã‹ã‚Šã‚„ã™ãâ€è§£èª¬ã™ã‚‹ã“ã¨ã‚’ç›®çš„ã¨ã—ã¦ã„ã‚‹ã€‚ ãƒ™ãƒ¼ã‚¹ã¨ãªã‚‹æŠ€è¡“ã¯PostgreSQLã ãŒã€PostgreSQLã«ç‰¹åŒ–ã—ãŸå†…å®¹ã§ã¯ãªãã€æ±Žç”¨çš„ãªSQLã®åŸºç¤ŽçŸ¥è˜ã‚’è§£èª¬ã™ã‚‹ã“ã¨ã«ä¸»è»¸ã‚’ç½®ã„ã¦ã„ã‚‹ã€‚PostgreSQLç‹¬è‡ªã®æŠ€è¡“ã«ã¤ã„ã¦ã¯ã€å¾ŒåŠéƒ¨åˆ†ã§ã‚ˆã†ã‚„ãç™»å ´ã™ã‚‹ã¨ã„ã£ãŸæ§‹æˆã ã€‚ æ•™ç§‘æ›¸ã ã£ã¦ã‚ªãƒ¼ãƒ—ãƒ³ã‚½
tarbo 2012/06/18
db

postgresql

sql
ãƒªãƒ³ã‚¯
NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³•
NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³•.markdown #NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³• åŽŸæ–‡ï¼šNoSQL Data Modeling Techniques Â« Highly Scala ble Blog I translated this article for study. contact matope[dot]ono[gmail] if any probl em. NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã€ä¸€è²«æ€§ã¨ã„ã£ãŸæ§˜ã€…ãªéžæ©Ÿèƒ½è¦ä»¶ã‹ã‚‰æ¯”è¼ƒã•ã‚Œã‚‹ã€‚NoSQLã®ã“ã®å´é¢ã¯å®Ÿè·µã¨ç†è«–ã®ä¸¡é¢ã‹ã‚‰ã‚ˆãç ”ç©¶ã•ã‚Œã¦ã„ã‚‹ã€‚ã‚ã‚‹ç¨®ã®éžæ©Ÿèƒ½ç‰¹æ€§ã¯NoSQLã‚’åˆ©ç”¨ã™ã‚‹ä¸»ãªå‹•æ©Ÿã§ã‚ã‚Šã€NoSQLã‚·ã‚¹ãƒ†ãƒ ã«ã‚ˆãé©ç”¨ã•ã‚Œã‚‹CAPå®šç†ãŒãã†ã§ã‚ã‚‹ã‚ˆã†ã«åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã®åŸºæœ¬çš„åŽŸå‰‡ã ã‹ã‚‰ã ã€‚ä¸€æ–¹ã§ã€NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã¯ã‚ã¾ã‚Šç ”ç©¶ã•ã‚Œã¦ãŠã‚‰ãšã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«è¦‹ã‚‰ã‚Œã‚‹ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒžãƒ†ã‚£ãƒƒã‚¯
tarbo 2012/04/16
nosql

sql

db

*ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
SQLè„³ã«å„ªã—ã„MongoDBã‚¯ã‚¨ãƒªãƒ¼å…¥é–€ - taka512's blog
mongoã‚³ãƒžãƒ³ãƒ‰ã‹ã‚‰æŽ¥ç¶šã—ãŸéš›ã«ã‚ªãƒ¼ãƒ«ãƒ‰ã‚¿ã‚¤ãƒ—(SQLè„³)ãŸã‚‹æˆ‘ã€…äººé¡žã«ã‚‚ èª¿ã¹ã‚„ã™ã„å½¢ã§insertã€selectã€updateã‚’è¡Œã†æ–¹æ³•ã‚’èª¿ã¹ã¾ã—ãŸã€‚ å®šç¾©å‚ç…§ // use [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å] use [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å] // show databases show dbs // show tables show collectionså‚ç…§ç³» // select * from [ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å] db.[ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å].find() // select * from [ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å] where x=4 db.[ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å].find({x:4}) // select j from [ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å] where x=4 db.[ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å].find({x:4}, {j:1}) // select * from [ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å] limit 1 db.[ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³
tarbo 2012/03/28
mongodb

sql

db
ãƒªãƒ³ã‚¯
HAVINGå¥ã®åŠ›
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
tarbo 2011/12/30
sql

mysql
ãƒªãƒ³ã‚¯
è¤‡æ•°è¡Œè¿”ã£ã¦ãã‚‹ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’æ–‡å—åˆ—ã«é€£çµã—ã¦å–å¾—ã™ã‚‹SQLã¾ã¨ã‚ - hikky nikky
SELECT name FROM TABLE_NAME WHERE id IN(1, 2, 3)ã¿ãŸã„ãªè¤‡æ•°è¡Œã®çµæžœã‚»ãƒƒãƒˆãŒè¿”ã£ã¦ãã‚‹ã‚¯ã‚¨ãƒªã‚’ã€ è¤‡æ•°è¡Œã‚’çµåˆã—ãŸæ–‡å—åˆ—ã«ã—ã¤ã¤ã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã¨ã—ã¦æ‰±ã£ã¦ã€ SELECT column1, column2, (SELECT name FROM TABLE_NAME WHERE id IN(1, 2, 3)) AS names FROM ...ã¿ãŸã„ã«ã‚¹ãƒãƒƒã¨æ›¸ããŸã„ã¿ãŸã„ãªã“ã¨ãŒã€ãŸã¾ã«ã‚ã‚Šã¾ã™ã€‚ æ–‡å—åˆ—ã¸ã®çµåˆã‚’ãƒ—ãƒã‚°ãƒ©ãƒ å´ã§ã‚„ã‚‰ãªãã¦æ¸ˆã‚€ã¨å¬‰ã—ã„ã‚±ãƒ¼ã‚¹ã‚‚ã‚ã‚‹ã—ã€‚ ãŸã ã—ã€ã“ã‚Œã¯RDBMSã«ã‚ˆã£ã¦ã€æ›¸ãæ–¹ãŒçµæ§‹ç•°ãªã‚Šã¾ã™ã€‚ ãªã‚“ã§ã€ã‚¢ãƒ¬ã£ã¡ã‚ƒã‚¢ãƒ¬ãªã‚“ã§ã™ãŒã€ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ å¯¾è±¡RDBMSã¯PostgreSQLã€MySQLã€Oracleã€‚ï¼ˆã¨ã„ã†ã‹ä»–ã¯çŸ¥ã‚‰ãªã„ã€‚ã€‚ã€‚ï¼‰ å‰æ SELECT name FROM TABLE_NAME WHERE
tarbo 2011/11/08
sql
ãƒªãƒ³ã‚¯
CASEå¼ã®ã‚¹ã‚¹ãƒ¡ / ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
tarbo 2011/11/08
sql
ãƒªãƒ³ã‚¯
ã€ŒGoogle Cloud SQLã€ç™ºè¡¨ã€Google App Engineã§SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ©ç”¨å¯èƒ½ã«ã€€
tarbo 2011/10/08
sql

google
ãƒªãƒ³ã‚¯
ç¬¬2å›žã€€å†—é•·æ€§ç—‡å€™ç¾¤ï½žæ¡ä»¶åˆ†å²ã‚’UNIONã§è¡¨ç¾ã™ã‚‹ãªã‹ã‚Œ | gihyo.jp
ã“ã“ã¯ã¨ã‚ã‚‹è¡—ã®ç·åˆç—…é™¢ã€‚ ã“ã“ã«ã¯é€šå¸¸ã®è¨ºç™‚ç§‘ã®ã»ã‹ã«ã€ä¸€é¢¨å¤‰ã‚ã£ãŸè¨ºç™‚ç§‘ãŒå˜åœ¨ã™ã‚‹ã€‚ ä½•è»’ã‚‚ã®ç—…é™¢ã‚’ãŸã‚‰ã„ã¾ã‚ã—ã«ã•ã‚ŒãŸã€æ‰‹ã®æ–½ã—ã‚ˆã†ã®ãªã„SQLã‚„ã€ä»Šã™ãã«æ”¹å–„ãŒå¿…è¦ãªSQLãŒæ‹…ãŽè¾¼ã¾ã‚Œã‚‹æ•‘å‘½å®¤ã§ã‚ã‚‹ã€‚ ãã‚ŒãŒSQLç·Šæ€¥æ•‘å‘½å®¤ã€ç•¥ã—ã¦SERï¼ˆSQL Emergency Roomâ ï¼‰â ã€‚ ãã†ã€ã“ã“ã¯å›½å†…ã§ã‚‚å”¯ä¸€ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å°‚é–€å¤–æ¥ã§ã‚ã‚‹ã€‚ ãƒãƒãƒ¼ãƒˆæ•‘å‘½å®¤éƒ¨é•·ã€‚è…•ã®ç«‹ã¤ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã ãŒã€å£ãŒæ‚ªãæ€§æ ¼ã¯ã‚‚ã£ã¨æ‚ªã„å››åã‚ªãƒ¤ã‚¸ã€‚ ï¼ˆAM10:00 ä¼‘æ†©å®¤ã€‚ãƒ¯ã‚¤ãƒªãƒ¼ãŒæœºã«å‘ã‹ã£ã¦ä¸€äººã§ä½•ã‹ã—ã¦ã„ã‚‹ï¼‰ ã©ã£ã¦ãƒã‚ãƒ¼ã‚“ã©ã£ã¦ãƒã‚ãƒ¼ã‚“ã€ã½ã½ã½ã‚“ã½ãƒ¼ã‚“ã€ã©ã£ã¦ãƒã‚ãƒ¼ã‚“â€¦
tarbo 2011/10/03
sql
ãƒªãƒ³ã‚¯
NoSQLã¯RDBMSã«å–ã£ã¦ä»£ã‚ã‚‹ã‚‚ã®ãªã®ã‹ï¼Ÿ
æ³¨ç›®ã‚’é›†ã‚ã‚‹NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ æ•°å¹´ã»ã©å‰ã‹ã‚‰ã€åˆ†æ•£KVSï¼ˆKey-Value Storeï¼‰ã‚„åˆ—æŒ‡å‘ï¼ˆColumn-Orientedï¼‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆæŒ‡å‘ï¼ˆDocument-Orientedï¼‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãªã©ã®æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“ãŒæ³¨ç›®ã‚’é›†ã‚ã¦ã„ã¾ã™ã€‚ã“ã‚Œã‚‰ã®æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã¨ã¯ç•°ãªã‚‹è€ƒãˆã«åŸºã¥ã„ã¦ã„ã‚‹ã®ã§ã€ã‚ˆãã€ŒNoSQLã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆæ³¨1ï¼‰ã¨ç·ç§°ã•ã‚Œã¦ã„ã¾ã™ã€‚ æ³¨1ï¼šã€ŒNoSQLã€ã¨ã„ã†è¨€è‘‰ã¯ã‚‚ã¨ã‚‚ã¨ã€Œè¿‘å¹´ç™»å ´ã—ã¦ã„ã‚‹ã€RDBMSä»¥å¤–ã®ï¼ˆã¤ã¾ã‚ŠSQLã‚’ä½¿ã‚ãªã„ï¼‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã‚’ç·ç§°ã€è¡¨ç¾ã—ãŸã‚‚ã®ã§ã‚ã‚Šã€ãã®å¾Œã‹ã‚‰ã€ŒSQLã¯ä¸è¦ã ã€ã¨ã„ã†ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’æŒã¤ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã®ã‚ˆã†ã«ãªã£ã¦ãã¾ã—ãŸã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºè€…ã®ä¸ã«ã¯ã€ã“ã®ã‚ˆã†ãªRDBMSã«å¯¾ã™ã‚‹ãƒã‚¬ãƒ†ã‚£ãƒ–ãªã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’å¥½ã¾ãšã€NoSQLã‚’ã€ŒNot Only SQLï¼ˆ
tarbo 2011/06/28
*ã‚ã¨ã§èªã‚€

nosql

sql
ãƒªãƒ³ã‚¯
MySQLã§ã‚¯ã‚¨ãƒªãƒ¼ã‚’å®Ÿè¡Œã—ã¦è¤‡æ•°ã®çµæžœãŒæŠ½å‡ºã•ã‚Œã‚‹ã¨ã—ã¾ã™ã€‚â€¦
MySQLã§ã‚¯ã‚¨ãƒªãƒ¼ã‚’å®Ÿè¡Œã—ã¦è¤‡æ•°ã®çµæžœãŒæŠ½å‡ºã•ã‚Œã‚‹ã¨ã—ã¾ã™ã€‚ SELECT A FROM TABLE1 WHERE B=C; çµæžœ t1,t2,t3......... ã“ã®çµæžœã‚’ç”¨ã„ã¦å¼•ãç¶šãSQLã‚’å®Ÿè¡Œã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ SELECT x FROM TABLE2 WHERE (y = t1) OR (y = t2) OR (y = t3).......... ; ç¾åœ¨ã¯ä¸Šã®çµæžœã‚’é…åˆ—ã«å…¥ã‚Œã¦functionã®ä¸ã§ã‚¯ã‚¨ãƒªãƒ¼æ–‡ã‚’ä½œã£ã¦ã„ã¾ã™ãŒã€ãã†ã—ãªã„ã§ã€SQLã ã‘ã§è¡Œã†ã‚¹ãƒžãƒ¼ãƒˆãªæ–¹æ³•ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ INã€€ã‚’ä½¿ã£ãŸã‚‰ã‚¨ãƒ©ãƒ¼ã«ãªã‚Šã€ã†ã¾ãã„ãã¾ã›ã‚“ã§ã—ãŸã€‚ã¾ãŸã€å‰¯ã‚¯ã‚¨ãƒªãƒ¼ã¨ã„ã†ã®ã‚’å°‘ã—èª¿ã¹ã¦ã¿ã¾ã—ãŸãŒã€ï¼‘ç•ªç›®ã®ã‚¯ã‚¨ãƒªãƒ¼çµæžœãŒï¼‘è¡Œã ã‘ã§ãªã„ã¨ã‚¨ãƒ©ãƒ¼ã«ãªã‚‹ã®ã ãã†ã§ã™ã€‚ è‰¯ã„æ–¹æ³•ã‚’ã”å˜ã˜ã®æ–¹ã€ã©ã†ã‹ã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚
tarbo 2011/03/23
sql
ãƒªãƒ³ã‚¯
ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ - Wikipedia
ã“ã®è¨˜äº‹ã¯æ¤œè¨¼å¯èƒ½ãªå‚è€ƒæ–‡çŒ®ã‚„å‡ºå…¸ãŒå…¨ãç¤ºã•ã‚Œã¦ã„ãªã„ã‹ã€ä¸ååˆ†ã§ã™ã€‚ å‡ºå…¸ã‚’è¿½åŠ ã—ã¦è¨˜äº‹ã®ä¿¡é ¼æ€§å‘ä¸Šã«ã”å”åŠ›ãã ã•ã„ã€‚ï¼ˆã“ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã®ä½¿ã„æ–¹ï¼‰ å‡ºå…¸æ¤œç´¢?:Â "ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£"Â â€“Â ãƒ‹ãƒ¥ãƒ¼ã‚¹Â Â· æ›¸ç±Â Â· ã‚¹ã‚«ãƒ©ãƒ¼Â Â· CiNiiÂ Â· J-STAGEÂ Â· NDLÂ Â· dlib.jpÂ Â· ã‚¸ãƒ£ãƒ‘ãƒ³ã‚µãƒ¼ãƒÂ Â· TWL (2017å¹´9æœˆ) ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ï¼ˆè‹±: Stored Procedureï¼‰ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§åˆ©ç”¨ã§ãã‚‹ã‚µãƒ–ãƒ«ãƒ¼ãƒãƒ³ã§ã‚ã‚‹ã€‚ã“ã®ã‚ˆã†ãªãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿è¾žæ›¸ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ã€‚ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ç”¨é€”ã¨ã—ã¦ã¯ã€ãƒ‡ãƒ¼ã‚¿ã®æ¤œè¨¼ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®çµ±åˆï¼‰ã‚„ã‚¢ã‚¯ã‚»ã‚¹åˆ¶å¾¡ã®ä»•çµ„ã¿ãªã©ãŒã‚ã‚‹ã€‚ã•ã‚‰ã«ã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¯ã€ã‚‚ã¨ã‚‚ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å®Ÿè£…ã•ã‚Œã¦ã„ãŸãƒã‚¸ãƒƒã‚¯ã‚’çµ±åˆã—ã€ä¸€å…ƒåŒ–
tarbo 2011/03/21
sql

wikipedia

storedprocedure
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
tarbo 2009/02/18
*ã‚ã¨ã§èªã‚€

sql

db

mysql
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸