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

snaka72 id:snaka72

sqlã«é–¢ã™ã‚‹snaka72ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ãƒ“ã‚¸ãƒã‚¹ã§é‡å®ã—ãã†ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ã‚¨ãƒªãƒ¼å…±æœ‰ã‚·ã‚¹ãƒ†ãƒ Â·Oculus MOONGIFT
Oculusã¯ãƒ“ã‚¸ãƒã‚¹ç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ã‚¨ãƒªãƒ¼å…±æœ‰ã‚·ã‚¹ãƒ†ãƒ ã§ã™ã€‚ é–‹ç™ºè€…ã®æ‰€ã«ã¯ãŸã³ãŸã³ãƒ¦ãƒ¼ã‚¶ãŒè¨ªãã¦ãã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ä¸€å®šã®æ¡ä»¶ã§æŠœãå‡ºã—ãŸãƒ‡ãƒ¼ã‚¿ãŒæ¬²ã—ã„ã¨è¨€ã‚ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ãã‚“ãªã“ã¨ãŒç¹°ã‚Šè¿”ã—ã‚ã‚‹ã¨SQLã‚’ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã§æ®‹ã—ã¦ãŠã„ãŸã‚Šã™ã‚‹äººã‚‚å¤šã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãã“ã§ä½¿ã£ã¦ã¿ãŸã„ã®ãŒOculusã§ã™ã€‚ã‚¯ã‚¨ãƒªãƒ¼ã‚’å…±æœ‰ã—ãŸã‚Šã€ãƒ‡ãƒ¼ã‚¿ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãŒã§ãã¾ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯RubyGemsã§è¡Œã„ã¾ã™ã€‚ ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§ã™ã€‚ãƒ¦ãƒ¼ã‚¶åã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æŒ‡å®šã—ã¦å®Ÿè¡Œã—ã¾ã™ã€‚ èµ·å‹•ã—ã¾ã—ãŸã€‚ å®Ÿè¡Œã—ã¾ã—ãŸã€‚çµæžœãŒä¸‹ã«è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ä¸Šã«è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ ã“ã¡ã‚‰ã¯ã‚¯ã‚¨ãƒªãƒ¼ãƒã‚°ã§ã™ã€‚ ã‚¯ã‚¨ãƒªãƒ¼ã‚’ä¿å˜ã—ã¦ãŠã‘ã¾ã™ã€‚ãŠæ°—ã«å…¥ã‚Šç™»éŒ²ã‚‚å¯èƒ½ã§ã™ã€‚çµæžœã¯ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚‚ã§ãã¾ã™ã€‚ ãŠæ°—ã«å…¥ã‚Šã®ã‚¯ã‚¨ãƒªãƒ¼ä¸€è¦§ã§ã™ã€‚ Oculusã‚’å…±æœ‰ã—ã¦ä½¿ãˆã°ã€æœ€åˆã¯é–‹ç™ºè€…ãŒã‚¯ã‚¨ãƒªãƒ¼ã‚’ä½œæˆã—ã€å¾Œã¯
snaka72 2012/06/18
sql
ãƒªãƒ³ã‚¯
SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†â€•â€•å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
snaka72 2011/07/06
database

data-model

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ã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚
snaka72 2010/09/17
æ–°äººã¨ã‹ã«SQLæ•™ãˆã‚‹ã¨ãã«ä½¿ãˆãã†ã€‚ã¡ãªã¿ã«ã€ãƒ–ã‚¯ãƒžç”¨ç”»åƒã¯è‡ªåˆ†ã®å ´åˆ img ã‚¿ã‚°ã§ style="display:none" ã—ã¦éš ã—ãŸã‚Šã—ã¦ã¾ã™ãã€‚

sql

ãƒã‚¿
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
snaka72 2010/05/16
sql

tools

windows
ãƒªãƒ³ã‚¯
ã‚ªãƒ¬ã‚ªãƒ¬SQLã®ä½œã‚Šæ–¹ã€œMySQLç·¨ã€œ - ã‚ˆãã®ã¯ã¦ãª
ã‚ªãƒ¬ã‚ªãƒ¬è¨€èªžå…¨ç››æœŸã®ç‚Žæš‘ã®å€™ã€ã„ã‹ãŒãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ã€‚ ã‚ªãƒ¬ã‚ªãƒ¬SQLã®ä½œã‚Šæ–¹ã€œPostgreSQLç·¨ã€œã«ç¶šãã€ã‚ªãƒ¬ã‚ªãƒ¬SQLã®ä½œã‚Šæ–¹ã€œMySQLç·¨ã€œã¨ã„ã†äº‹ã§ MySQLã«ã€è‡ªä½œã®SQLé–¢æ•°(UDF)ã‚’çµ„ã¿è¾¼ã‚€ã‚„ã‚Šæ–¹ã‚’ç°¡å˜ã«ç´¹ä»‹ã—ã¾ã™ã€‚ MySQLã¯åã®é€šã‚Šã€ç§ã®SQLãªã®ã§ã‚ªãƒ¬ã‚ªãƒ¬SQLã«ã¯æŒã£ã¦ã“ã„ã§ã™ãã€‚ ç°¡å˜ã«è¨€ãˆã° select oreore(); select oreore(column1, column2) from table1; è‡ªåˆ†ã§å®šç¾©ã—ãŸCè¨€èªžã®oreoreé–¢æ•°ã‚’DBã«çµ„ã¿è¾¼ã‚“ã§ä½¿ãŠã†ã¨ã„ã†äº‹ã§ã™ã€‚ æœ€çµ‚ç›®æ¨™ã¯ã€SQLã®çµæžœã§JSONã‚’è¿”ãã†ã¨æ€ã„ã¾ã™ã€‚ select json(a, b) from c;ã®çµæžœã§ { "aaa" : 1, "bbb" : "abc" } å›ºå®šå€¤ã‚’è¿”ã™é–¢æ•° æ—©é€Ÿã€å›ºå®šã§999ã‚’è¿”ã™é–¢æ•°ã‚’ä½œã£ã¦ã¿ã¾ã™ã€‚ â€»ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯MySQL5.
snaka72 2008/08/08
ã‚ã¨ã§ã‚„ã£ã¦ã¿ã‚‹

MySQL

SQL
ãƒªãƒ³ã‚¯
1