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

naney id:naney

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

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

ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: RDBã§éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ã«ã¯ï¼Ÿ
yukiã§ã™ã€‚ãƒ€ã‚¤ã‚¨ãƒƒãƒˆã‚’å§‹ã‚ã¦3kgæ¸›ã£ãŸã¨æ€ã£ãŸã‚‰ã€é¢¨é‚ªã‚’å¼•ã„ã¦è¦‹äº‹ã«1kgå¢—é‡ã€‚ é‹å‹•ã—ãªã„ã¨é§„ç›®ã§ã™ãã€‚ã‚ã¨æ®‹ã‚Š20kgã€é“ã®ã‚Šã¯é ã„ã§ã™ã€‚ ã•ã¦ä»Šå›žã¯ã€ã€ŒRDBã§éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ã«ã¯ï¼Ÿã€ã§ã™ã€‚ ã‚ã‚‹ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ä¸ã«éšŽå±¤æ§‹é€ ã‚’ã‚‚ã£ãŸã‚«ãƒ†ã‚´ãƒªæ§‹é€ ã«ã™ã‚‹ã“ã¨ã«ãªã‚Šã€ã©ã®ã‚ˆã†ã«DBã§æ‰±ã†ã‹æ‚©ã¿ã¾ã—ãŸã€‚ DBã¯MySQLã‚’æŽ¡ç”¨ã—ã¦ã„ãŸã®ã§ã€ã“ã®æ™‚ç‚¹ã§ã±ã£ã¨é ã«æµ®ã‹ã‚“ã é¸æŠžè‚¢ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã§ã—ãŸã€‚ XML-DBã‚’åˆ©ç”¨ã™ã‚‹ è¦ªã‚«ãƒ†ã‚´ãƒªãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªIDã‚’åã‚«ãƒ†ã‚´ãƒªãƒ¬ã‚³ãƒ¼ãƒ‰ã«æŒãŸã›ã‚‹ è¦ªã‚’å«ã‚ãŸã€Žçµ¶å¯¾ãƒ‘ã‚¹ã€ã‚’åç§°ã¨ã—ã¦æ‰±ã„ã€å–ã‚Šå‡ºã—ãŸå¾Œã«ãƒ‘ãƒ¼ã‚¹ ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã«åŒæ§˜ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã‚’ä½œã‚Šã€æ¯Žå›žãƒ‘ãƒ¼ã‚¹ã™ã‚‹ (1)ã®XMLDBã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®eXistã‚„Xindiceã€Yggdrasillãªã©æ§˜ã€…ãªé¸æŠžè‚¢ãŒã‚ã‚Šã¾ã—ãŸãŒã€ã‚«ãƒ†ã‚´ãƒªã®ã¿ã®åˆ©ç”¨ãªå‰²ã«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚³ã‚¹ãƒˆãŒé«˜ã™ãŽã‚‹ã®ã§è¦‹é€ã‚Šã¾
naney 2009/06/25
RDBMS

SQL

ãƒ‡ãƒ¼ã‚¿æ§‹é€
ãƒªãƒ³ã‚¯
ãªã‘ã‚Œã° 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)
naney 2008/05/14
SQL
ãƒªãƒ³ã‚¯
SELECT * fromã«ã¤ã„ã¦ã®è©±
æ°—è»½ã«æ›¸ã„ã¦ãŸã‘ã©ã€ã“ã‚Œã¡ã‚ƒã‚“ã¨æ›¸ã„ã¦ãŠã‹ãªã„ã¨ãƒžã‚ºã‚¤ã‹ã€‚ F's Garageï¼šã©ã®ãƒ¬ãƒ™ãƒ«ã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ãŒä¸€ç•ªè‰¯ã„ã®ã‹ã€‚ ã«æ›¸ã„ãŸä»¥ä¸‹ã®éƒ¨åˆ†ã€‚ ç¢ºã‹ã«JavaBeansã¯é¢å€’ã ã‘ã©ã€ãƒãƒƒã‚·ãƒ¥ã§å–ã‚Šå›žã™åž‹ã®ãªã„è¨€èªžã¯ã€DBã®ã‚¹ã‚ãƒ¼ãƒžã®å¤‰æ›´ã¯å¼·ã„ã—ã€‚ï¼ˆãˆã€select * from ã‚’ä½¿ã†ãªã£ã¦ï¼Ÿï¼‰ select * ã‚’æŽ¨å¥¨ã›ãšã€ã‚«ãƒ©ãƒ åã‚’æŒ‡å®šã™ã¹ãã¨ã„ã†è©±ã«ã¤ã„ã¦ã®è€ƒå¯ŸãŒã‚ã‚Šã¾ã—ãŸã€‚ çœ ã‚‹é–‹ç™ºå±‹blog Â» SELECTæ–‡ã§ã‚¢ã‚¹ã‚¿ãƒªã‚¹ã‚¯ã‚’ä½¿ã†ãªè«–ã€ã¨ã‹ åˆ—åæŒ‡å®šã®ã»ã†ãŒå¿…è¦ãªåˆ†ã ã‘ãƒ‡ãƒ¼ã‚¿ã‚’é€ã‚‰ãšè»¢é€é‡ãŒæ¸›ã‚‹ã®ã§ã€ã¾ãŸã¯è§£æžã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒä¸ŠãŒã‚‹ã®ã§ã‚ˆã„ã€ã¿ãŸã„ãªè©±ãŒã‚ã‚‹ãŒã€ãã‚“ãªã«å¤‰ã‚ã‚‹ã®ï¼Ÿ ã„ã‚„ã€çµŒé¨“çš„ã«ã¯ã‚ã‚“ã¾ã‚Šå¤‰ã‚ã‚‰ã‚“æ°—ãŒã€‚ ã£ã¦ã‹ã€ã‚‚ã—MySQLã§ã‚ã‚Œã°ã€ã‚¯ã‚¨ãƒªãƒ¼ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒã‚ã‚‹ã®ã§ã€ãªã‚‹ã¹ãåŒã˜è¨˜è¿°ã®SQLæ–‡ã‚’ç™ºè¡Œã—ãŸã»ã†ãŒã„ã„ã€‚ ãã‚‚ãã‚‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚ãƒ£ãƒƒã‚·ãƒ¥ä½¿ãˆã‚ˆï¼ã¨
naney 2008/05/04
SQL
ãƒªãƒ³ã‚¯
é€†å¼•ãSQLæ¯”è¼ƒ
Works > é€†å¼•ãSQLæ¯”è¼ƒ é€†å¼•ãSQLæ¯”è¼ƒ [Â å…±é€šäº‹é …Â ]Â [Â ORACLEÂ ]Â [Â MSSQLÂ ]Â [Â SSAÂ ]Â [Â PostgresÂ ]Â [Â MySQLÂ ]Â [Â JetÂ ]Â Last Updated. 14-May-2006 Since 08-May-2001 â– ã¯ã˜ã‚ã« è¤‡æ•°ã® RDBMS ã‚’ä½¿ã£ãŸçµŒé¨“ãŒã‚ã‚‹äººãªã‚‰ã€ãŠã‚ã‹ã‚Šã‹ã¨æ€ã„ã¾ã™ãŒã€SQL ã¯ RDBMS ã«ã‚ˆã£ã¦ç•°ãªã‚‹éƒ¨åˆ†ãŒçµæ§‹ã‚ã‚Šã¾ã™ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã¯å„ RDBMS ã«ãŠã‘ã‚‹ åŸºæœ¬çš„ãªæ©Ÿèƒ½ï¼ˆä¸»ã«SQLã«ã¤ã„ã¦ï¼‰ã®æ¦‚è¦ã‚’ã€é€†å¼•ãã§ã€ã‹ã¤å¹³æ˜“ãªè¨€è‘‰ã§é–²è¦§ ã™ã‚‹äº‹ã‚’ç›®çš„ã«ä½œã£ãŸãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§ã™ã€‚ ç‰¹å®šã® RDBMS ã‚’æŒã¡ä¸Šã’ãŸã‚Šã€è²¶ã‚ãŸã‚Šã™ã‚‹ã®ãŒç›®çš„ã§ã¯ãªã„ã®ã§èª¤è§£ãªãã‚ˆã†ã€‚ ã¾ãŸã€é–“é•ã„ã«ã¤ã„ã¦ã®ã”æŒ‡æ‘˜ã‚„ã€Žã“ã†ã—ãŸæ–¹ãŒåŠ¹çŽ‡çš„ã ã€ãªã©ã®ã”æ„è¦‹ã‚‚å¤§æ“è¿Žã§ã™ã€‚ å¯¾è±¡ã¨ã—ã¦ã„ã‚‹ã®ã¯ä»¥ä¸‹ã® RDBMSã§
naney 2007/11/20
DB

SQL

MySQL

PostgreSQL
ãƒªãƒ³ã‚¯
GitHub - ondras/wwwsqldesigner: WWW SQL Designer, your online SQL diagramming tool
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
naney 2007/11/06
SQL
ãƒªãƒ³ã‚¯
é«˜æœ¨æµ©å…‰ï¼ è‡ªå®…ã®æ—¥è¨˜ - é§„ç›®ãªæŠ€è¡“æ–‡æ›¸ã®è¦‹åˆ†ã‘æ–¹ ãã®1
â– é§„ç›®ãªæŠ€è¡“æ–‡æ›¸ã®è¦‹åˆ†ã‘æ–¹ ãã®1 ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã®ãƒ›ãƒƒãƒ†ãƒ³ãƒˆãƒªã‚’è¦‹ã¦ã„ãŸã¨ã“ã‚ã€300ã‚’è¶…ãˆã‚‹ãƒ¦ãƒ¼ã‚¶ã«ç™»éŒ²ã•ã‚ŒãŸä»¥ä¸‹ã®è¨˜äº‹ãŒã‚ã£ãŸã€‚ ä»Šå¤œåˆ†ã‹ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–, ä¸Šé‡Žå®£, @IT, 2006å¹´11æœˆ2æ—¥ ã¾ãŸä¸Šé‡Žå®£ã‹ã€‚é¡”è¦‹çŸ¥ã‚Šãªã®ã§ã‚ºãƒãƒªã„ãã“ã¨ã«ã™ã‚‹ã€‚ ã—ã‹ã—ã€ãã®å¯¾ç–ã¯ã¾ã æœ¬å½“ã«ç†è§£ã•ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ€ãˆã‚‹ã€‚ ã¸ãˆã€‚ çµ‚ã‚ã‚Šã®æ–¹ã‚’è¦‹ã¦ã¿ã‚‹ã¨ã€ Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¯¾ç– å…¥åŠ›å€¤ã®SQLã®ç‰¹æ®Šæ–‡å—ã‚’é©åˆ‡ã«ã‚¨ã‚¹ã‚±ãƒ¼ãƒ— å…¥åŠ›å€¤ï¼ãƒ—ãƒã‚°ãƒ©ãƒ ï¼ˆãƒ—ãƒã‚»ã‚¹ï¼‰ã«å¤–éƒ¨ã‹ã‚‰å…¥ã£ã¦ãã‚‹ã‚‚ã® ã‚·ãƒ•ãƒˆJISã®å ´åˆã«ã¯1ãƒã‚¤ãƒˆæ–‡å—ã‚’æ•´ç† SQLã®è¨˜è¿°ã‚’ãªãã™ãŸã‚ã«O/Rï¼ˆObject/Relationalï¼‰ãƒžãƒƒãƒ”ãƒ³ã‚°ã‚’æ´»ç”¨ æ”»æ’ƒè€…ã«å½¹ç«‹ã¤æƒ…å ±ã‚’ä¸Žãˆãªã„ãŸã‚ã«ã€ä¸è¦ãªã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå‡ºåŠ›ã™ã‚‹ã‚¨ãƒ©ãƒ¼ãªã©ï¼‰ã®è¡¨ç¤ºã‚’æŠ‘æ¢ å¯¾ç–ã«ã€Œæº–å‚™ã•ã‚ŒãŸæ–‡ã€(prepared statement)
naney 2006/11/07
SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
1ã¤ã®SQLæ–‡ã§è¤‡æ•°ã®è¡¨ã«INSERTã™ã‚‹çµ¶å“ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ï¼ˆ1/2ï¼‰ â€• ï¼ IT
æœ¬é€£è¼‰ã¯SQLã®å¿œç”¨åŠ›ã‚’èº«ã«ä»˜ã‘ãŸã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€ã•ã¾ã–ã¾ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã™ã‚‹ã€‚SQLã®åŸºæœ¬æ§‹æ–‡ã¯å¹³æ˜“ãªã‚‚ã®ã ãŒã€å®Ÿå‹™ã§æ´»ç”¨ã™ã‚‹ã«ã¯æ•™ç§‘æ›¸çš„ãªè¨˜è¿°ã‚’ç†è§£ã™ã‚‹ã ã‘ã§ã¯ä¸ååˆ†ã ã€‚æœ¬é€£è¼‰ã¯ã€è‘—åãªãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ã€ŒãŠã‚‰ï¼ã‚ªãƒ©ï¼ Oracle - ã©ã£ã·ã‚Šæ¤œè¨¼ç”Ÿæ´»ã€ã‚’ç™ºè¡Œã™ã‚‹ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã®ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã‚’åŸ·ç†é™£ã«è¿Žãˆã€SQLã®ã‚»ãƒ³ã‚¹å‘ä¸Šã«å½¹ç«‹ã¤å¤§æŠ€å°æŠ€ã‚’ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ FOR...LOOPæ–‡ã‚’ä½¿ã£ã¦ã€ã„ãã¤ã‚‚ã®SQLæ–‡ã§ãƒ‡ãƒ¼ã‚¿ã‚’INSERTã—ã¦ã„ã‚‹PL/SQLãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚„ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ã‚ˆãè¦‹æŽ›ã‘ã¾ã™ãŒã€å®Ÿã¯1åº¦ã«ãƒ‡ãƒ¼ã‚¿ã‚’INSERTã™ã‚‹æ–¹æ³•ã‚‚ã‚ã‚‹ã‚“ã§ã™ã€‚ãƒžãƒ«ãƒãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»ã‚¤ãƒ³ã‚µãƒ¼ãƒˆï¼ˆMultitable Insertï¼‰ã¨ã¯ãã®åã®ã¨ãŠã‚Šã€1ã¤ã®SQLæ–‡ã§è¤‡æ•°ã®è¡¨ã«INSERTãŒå¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ã“ã®æœ€å¤§ã®ãƒ¡ãƒªãƒƒãƒˆã¯ã€ã‚„ã¯ã‚Šãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã§ã™ã€‚ã§ã¯æ—©é€Ÿã”ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒžãƒ«ãƒãƒ†ãƒ¼ãƒ–
naney 2006/02/28
DB

SQL
ãƒªãƒ³ã‚¯
1