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

yatta47 id:yatta47

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

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

ãªã‘ã‚Œã° INSERTã€ã‚ã‚Œã° UPDATE
é–“é•ã£ã¦ä¸»ã‚ãƒ¼ã¨åŒã˜å€¤ã‚’å«ã‚€è¡Œã‚’æŒ¿å…¥ã—ã‚ˆã†ã¨ã—ãŸã‚‰ã‚¨ãƒ©ãƒ¼ã‚’å‡ºã—ã¦æ•™ãˆã¦ã»ã—ã„ã¨ã INSERT INTO test VALUES(1,100); ã¨ã™ã‚‹ã¨ã€ERROR 1062 (23000): Duplicate entry '1' for key 1 ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãŒå‡ºã‚‹ã€‚ é–“é•ã£ã¦ä¸»ã‚ãƒ¼ã¨åŒã˜å€¤ã‚’å«ã‚€è¡Œã‚’æŒ¿å…¥ã—ã‚ˆã†ã¨ã—ã¦ã‚‚ç„¡è¦–ã—ã¦å‡¦ç†ã‚’ç¶šè¡Œã—ã¦ã»ã—ã„ã¨ã INSERT IGNORE INTO test VALUES(1,100); ã¨ã™ã‚‹ã¨ã€Query OK, 0 rows affected (0.00 sec) ã¨è¡¨ç¤ºã•ã‚Œã‚‹ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã¯å¤‰æ›´ã•ã‚Œã¦ã„ãªã„ã€‚ ä¸»ã‚ãƒ¼ã¨åŒã˜å€¤ã‚’å«ã‚€è¡ŒãŒãªã„ãªã‚‰æ–°ã—ãæŒ¿å…¥ã—ã€ã‚ã‚‹ãªã‚‰ãã®è¡Œã‚’æ›´æ–°ã—ã¦ã»ã—ã„ã¨ã REPLACE INTO test VALUES(1,500); ã¨ã™ã‚‹ã¨ã€Query OK, 2 rows affected (0.00 sec)
yatta47 2013/12/09
SQL

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

*è¨˜äº‹ãƒã‚¿ãƒ»è©¦ã™

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

*php
ãƒªãƒ³ã‚¯
InfluxDB | Real-time insights at any scale | InfluxData
Real-Time Analytics Collect, analyze, and predict in real time
yatta47 2013/11/06
*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

database

SQL
ãƒªãƒ³ã‚¯
SQLã¨JSONã‚’Node.jsä¸Šã§çµ„ã¿åˆã‚ã›ãŸæ–°è¨€èªžã€Œql.ioã€ã‚’eBayãŒå…¬é–‹
eBayãŒã€JavaScriptã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰SQLæ–‡ã®ã‚ˆã†ãªå½¢å¼ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®å•ã„åˆã‚ã›ã‚’è¨˜è¿°ã§ãã‚‹DSLï¼ˆãƒ‰ãƒ¡ã‚¤ãƒ³å›ºæœ‰è¨€èªžï¼‰ã®ql.ioã‚’ç™ºè¡¨ã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦å…¬é–‹ã—ã¾ã—ãŸã€‚ ç¾åœ¨ã€å¤šãã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã¨ã®ãƒ‡ãƒ¼ã‚¿ã®ã‚„ã‚Šã¨ã‚Šã«HTTPã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸAPIã‚’ç”¨ã„ã¦ã„ã¾ã™ã€‚ã—ã‹ã—ã€Webãƒ™ãƒ¼ã‚¹ã®APIã«ã‚ˆã£ã¦ãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šå‡ºã™ã®ã¯ã€ãƒ—ãƒã‚°ãƒ©ãƒžã«ã¨ã£ã¦å®Ÿã¯æ‰‹é–“ã®ã‹ã‹ã‚‹ã“ã¨ã§ã™ã€‚ ä¾‹ãˆã°ã€ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã‚’å…¥åŠ›ã™ã‚‹ã¨é–¢é€£ã™ã‚‹å•†å“ã®åå‰ã€è©³ç´°ã€è³¼å…¥è€…ã®è©•ä¾¡ã‚’ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«è¡¨ç¤ºã™ã‚‹ã€ã¨ã„ã†Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯ã€ã¾ãšã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ¤œç´¢ã—ã¦å•†å“IDã‚’å–å¾—ã—ã€ä»Šåº¦ã¯ãã®å•†å“IDã‚’ã‚ãƒ¼ã«ã—ã¦åå‰ã‚„æ¦‚è¦ã€è©•ä¾¡ã®æƒ…å ±ã‚’å–å¾—ã™ã‚‹ã€ã¨ã„ã£ãŸã‚ˆã†ã«ã€APIã‚’ç¹°ã‚Šè¿”ã—å‘¼ã³å‡ºã™å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ql.ioã¯ã“ã†ã—ãŸå†…å®¹ã‚’SQLã®ã‚ˆã†ã«åˆ†ã‹ã‚Šã‚„ã™ã„è¨˜è¿°ã§å®Ÿç¾ã™ã‚‹ã ã‘ã§ãªãã€è¤‡æ•°ã®
yatta47 2012/04/14
node.js

SQL

*Webé–¢é€£

*é–‹ç™ºé–¢é€£
ãƒªãƒ³ã‚¯
ã‚„ã¯ã‚ŠSELECTæ–‡ã¯æ°¸é ã®ãƒ†ãƒ¼ãƒžã§ã™
ä»Šå›žã‹ã‚‰ã€Database Expertãƒ•ã‚©ãƒ¼ãƒ©ãƒ ã§ã¯ã€Œå…ˆæœˆã®äººæ°—è¨˜äº‹ãƒ©ãƒ³ã‚ãƒ³ã‚°ã€ã‚’æŠ«éœ²ã•ã›ã¦ã„ãŸã ãã“ã¨ã«ã—ã¾ã—ãŸã€‚å®‰å®šã—ãŸäººæ°—ã‚’èª‡ã‚‹å®šç•ªã®è¨˜äº‹ã«å¯¾ã—ã¦ã€æ–°ã—ã„è¨˜äº‹ãŒã©ã‚Œã ã‘é£Ÿã„è¾¼ã‚“ã§ã„ã‚‹ã®ã‹ã€ã©ã†ãžã”è¦§ãã ã•ã„ï¼ˆç·¨é›†éƒ¨ï¼‰ æ–°å¹´ã‚’æ©Ÿã«å§‹ã‚ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸ å‰ç½®ãã§èª¬æ˜Žã•ã›ã¦ã„ãŸã ã„ãŸé€šã‚Šã€2012å¹´ã‹ã‚‰ã€Database Expertãƒ•ã‚©ãƒ¼ãƒ©ãƒ ã§ã¯ã€æœˆã€…ã®äººæ°—è¨˜äº‹ãƒ©ãƒ³ã‚ãƒ³ã‚°ã‚’ä½œã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚æ˜¨å¹´ã¾ã§ã‚‚ã€ç·¨é›†è€…ãŒå†…ã€…ã§ãƒ©ãƒ³ã‚ãƒ³ã‚°ã‚’ä½œã£ã¦ã€æ•°ã‚«æœˆã«ä¸€åº¦ã€ãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ã€Œå…ˆé€±ã®äººæ°—è¨˜äº‹ã€ã§ã”ç´¹ä»‹ã—ã¦ã„ã¾ã—ãŸã€‚ã”å˜ã˜ã®æ–¹ã‚‚å¤šã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ãƒ©ãƒ³ã‚ãƒ³ã‚°ã®ä½œã‚Šæ–¹ã¯ã„ã‚ã„ã‚ã‚ã‚Šã¾ã™ã€‚ä¾‹ãˆã°ã€ã€Œå…ˆæœˆå…¬é–‹ã®è¨˜äº‹ã ã‘ã‚’å¯¾è±¡ã«ã™ã‚‹ã€ã¨ã„ã†æ–¹æ³•ã‚‚ã‚ã‚Šã¾ã™ãŒã€Database Expertãƒ•ã‚©ãƒ¼ãƒ©ãƒ ã¯ã€çš†æ§˜ã«ã”æ„›é¡§ã„ãŸã ã„ã¦ã„ã‚‹å®šç•ªã®è¨˜äº‹ãŒå¤§ããªäººæ°—ã‚’é›†ã‚ã¦ã„ã¾ã™ã€‚ä»Šå›žä½œæˆã—ãŸãƒ©ãƒ³ã‚ãƒ³ã‚°ã§ã¯ã€å…¬é–‹æ™‚æœŸ
yatta47 2012/02/21
*é–‹ç™ºé–¢é€£

SQL
ãƒªãƒ³ã‚¯
1