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

rudo108 id:rudo108

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

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

SQLite ã‚’å†å®Ÿè£…ã™ã‚‹æ™‚ã«å½¹ã«ãŸã¤ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ - kawasin73ã®ãƒ–ãƒã‚°
å›°ã£ãŸæ™‚ã¯ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã€ã©ã†ã‚‚ã‹ã‚ã—ã‚“ã§ã™ã€‚æœ€è¿‘ã€è«¸äº‹æƒ…ã§ SQLite ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’èªã‚“ã§ã„ã¾ã™ã€‚ å‰å›žã®è¨˜äº‹ ã§ç´¹ä»‹ã—ãŸé€šã‚Š SQLite ã‚’ Rust ã§å†å®Ÿè£…ã—ã¦ã„ã¾ã™ã€‚ãŠã‹ã’ã•ã¾ã§ 300 ã‚’è¶…ãˆã‚‹ Github Star ã‚‚ã„ãŸã ãå¬‰ã—ã„ã§ã™ã€‚ github.com SQLite ã¯å…¨ã¦ã®ä»•æ§˜ãŒ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ ã«ã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã®ã§ã€ãã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¨æœ¬å®¶ã®å®Ÿè£…ã‚’èªã¿æ¯”ã¹ãªãŒã‚‰å®Ÿè£…ã—ã¦ã„ã¾ã™ã€‚ SQLite ã‚’å†å®Ÿè£…ã™ã‚‹ä¸Šã§ç‰¹ã«ä»¥ä¸‹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯å½¹ã«ãŸã¡ã¾ã™ã€‚ã“ã‚Œã‚‰ã ã‘ã§æœ€å°é™ã® SQLite ã®å®Ÿè£…ã¯ä½œã‚Œã‚‹ã¨æ€ã„ã¾ã™ã€‚ Overview Documents > About SQLite ã„ã‹ã« SQLite ãŒã™ã”ã„ã‹ã‚’è‡ªæ…¢ã—ã¦ã„ã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã€‚ä½¿ãŠã†ã¨ã—ã¦ã„ã‚‹äººã«ã¯å®‰å¿ƒã‚’ã€å†å®Ÿè£…ã—ã‚ˆã†ã¨ã™ã‚‹äººã«ã¯çµ¶æœ›ã‚’ä¸Žãˆã¦ãã‚Œã¾ã™ã€‚ Programming Interfaces >
rudo108 2023/09/03
sql

sqlite
ãƒªãƒ³ã‚¯
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯å†åˆ©ç”¨ã®æ•µã§ã‚ã‚‹
é‡£ã‚Šã£ã½ã„ã‚¿ã‚¤ãƒˆãƒ«ã€‚ã€ŒRDBã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒçµ¡ã‚€ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã®ãƒ—ãƒã‚°ãƒ©ãƒ ãŒæ›¸ãã«ãããªã‚‹ã€ã¨ã„ã†è©±ã§ã™ã€‚ ã‚‚ã¡ã‚ã‚“ã§ã™ãŒã€RDBã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯å‰å¤§ã§ã‚ã‚Šã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚‚æ„è˜ã—ã¦ä½¿ã‚ãªã‘ã‚Œã°ãªã‚‰ãšã€ã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãªã‚“ã¦ä½¿ã†ãªã€ã¨è¨€ã„ãŸã„ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ åˆæˆã§ããªã„é–¢æ•° PHPã§ç´ ã®PDOã‹ã‚‰è€ƒãˆã¾ã™ã€‚ãŸã¨ãˆã°ã€ä»¥ä¸‹ã®é–¢æ•°ã«å•é¡Œã¯ã‚ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿ <?php /* * å¤ã„ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ãƒ†ãƒ¼ãƒ–ãƒ«ã«ç§»ã™é–¢æ•°ã®ã‚¤ãƒ¡ãƒ¼ã‚¸ */ function moveDataToArchive(PDO $db) { $db->beginTransaction(); try { $db->exec(' INSERT INTO archives SELECT * FROM data WHERE published < CURRENT_DATE '); $db->exec
rudo108 2016/05/19
db

sql
ãƒªãƒ³ã‚¯
æ—¥ä»˜ã€æ™‚åˆ»ã®å–å¾—ã€ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆå¤‰æ›´(MySQLã€PostgreSQLã€ORACLE)
SQLã§ã®æ—¥ä»˜ã€æ™‚åˆ»ã€æ›œæ—¥ã®å–å¾—æ–¹æ³•ã€ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã®å¤‰æ›´æ–¹æ³•ã§ã™ã€‚ å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ¼ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã£ã¦å–å¾—æ–¹æ³•ã«é•ã„ãŒã‚ã‚Šã¾ã™ã®ã§æ³¨æ„ã—ã¦ãã ã•ã„ã€‚ [toc heading_levels="2,3"] â– MySQLæ—¥ä»˜ã€æ™‚åˆ»ã€æ›œæ—¥ãªã©ãã®ä»–è‰²ã€…ãªå–å¾—ä¾‹ æ™‚é–“ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã§ã™ã€‚ ä½¿ç”¨ä¾‹ mysql> select current_time; +--------------+ | current_time | +--------------+ | 06:43:15 | +--------------+ æ—¥ä»˜ã®å–å¾— æ—¥ä»˜ã‚’å–å¾—ã™ã‚‹ä½¿ç”¨ä¾‹ã§ã™ã€‚ mysql> select current_date; +--------------+ | current_date | +--------------+ | 2006-09-13 | +--------------+ æ—¥ä»˜ã€æ™‚åˆ»ã‚’å–å¾—ã™ã‚‹ä½¿ç”¨ä¾‹ã§ã™ã€‚ my
rudo108 2016/01/07
sql
ãƒªãƒ³ã‚¯
http://blog.tofu-kun.org/070620123532.php
rudo108 2015/11/30
sql
ãƒªãƒ³ã‚¯
SELECTæ–‡ã®ç·ä»•ä¸Šã’ã¯ã‚µãƒ–ã‚¯ã‚¨ãƒªï¼ˆ1/2ï¼‰ â€• ï¼ IT
åˆå›žã‹ã‚‰7å›žã«ã‚ãŸã£ã¦SELECTæ–‡ã®åˆ©ç”¨æ³•ã‚’å–ã‚Šä¸Šã’ã¦ãã¾ã—ãŸãŒã€ãã‚Œã‚‚ä»Šå›žã§ã¨ã†ã¨ã†æœ€å¾Œã¨ãªã‚Šã¾ã™ã€‚ä»Šå›žå–ã‚Šä¸Šã’ã‚‹ã®ã¯ã€SQLæ–‡ã®ä¸ã«SELECTå¥ã‚’å…¥ã‚Œåã«ã—ã¦åŸ‹ã‚è¾¼ã‚€ã€Œã‚µãƒ–ã‚¯ã‚¨ãƒªã€ã§ã™ã€‚ ã‚µãƒ–ã‚¯ã‚¨ãƒªã¨ã¯ ã‚µãƒ–ã‚¯ã‚¨ãƒªã¯ã€Œå‰¯å•ã„åˆã‚ã›ã€ã¨ã‚‚å‘¼ã°ã‚Œã€SQLæ–‡ã®ä¸ã«SELECTæ–‡ã‚’åŸ‹ã‚è¾¼ã¿ã€æŠ½å‡ºæ¡ä»¶ã¨ã—ã¦åˆ©ç”¨ã™ã‚‹ã“ã¨ã‚’å¯èƒ½ã¨ã—ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¾ã§ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã™ã‚‹ãŸã‚ã«WHEREå¥ã«ã‚ˆã‚‹çµžã‚Šè¾¼ã¿ã‚„JOINå¥ã«ã‚ˆã‚‹çµåˆã‚’åˆ©ç”¨ã—ã¦ãã¾ã—ãŸãŒã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã¯ãã®å¿œç”¨ã¨ã„ãˆã‚‹å˜åœ¨ã§ã™ã€‚ ã§ã¯ã€æ¬¡ã®ã‚ˆã†ãªä¾‹ã‚’è¦‹ã¦ã¿ã¾ã—ã‚‡ã†ã€‚
rudo108 2015/10/21
sql
ãƒªãƒ³ã‚¯
ã‚«ãƒ©ãƒ ã®å€¤ãŒé‡è¤‡ã—ã¦ã„ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æŠ½å‡ºã™ã‚‹SQL - ãŠã¯ã‚ˆã†ãƒãƒƒãƒ•ã‚¡ãƒãƒ¼
å€¤ãŒé‡è¤‡ã—ãŸãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æŠ½å‡ºã™ã‚‹SQLã‚’çµæ§‹é »ç¹ã«ä½¿ã†ã®ã§ãƒ¡ãƒ¢ SELECT å•†å“ID FROM å•†å“ãƒžã‚¹ã‚¿ GROUP BY å•†å“ID HAVING COUNT(å•†å“ID)<>1 HAVINGã£ã¦ã“ã®æ™‚ãã‚‰ã„ã—ã‹ä½¿ã£ãŸäº‹ãªã„ã‚“ã ã‘ã©ã€ ã€Œé›†è¨ˆé–¢æ•°ã®çµæžœã‚’æ¡ä»¶ã¨ã—ãŸçµžè¾¼ã¿ã€ã£ã¦äº‹ã‚‰ã—ã„ã€‚ å£²ä¸ŠãŒ1000ä»¥ä¸Šã®å•†å“IDã‚’æŠ½å‡ºã™ã‚‹ãªã‚“ã¦ã®ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ã«ã‚„ã‚‹ã‚ˆã†ã§ã™ã€‚ SELECT å•†å“ID, SUM(å€¤æ®µ) FROM å•†å“ãƒžã‚¹ã‚¿ GROUP BY å•†å“ID HAVING SUM(å€¤æ®µ)>1000
rudo108 2015/10/19
sql
ãƒªãƒ³ã‚¯
SQLå®Ÿè·µå…¥é–€â”€â”€é«˜é€Ÿã§ã‚ã‹ã‚Šã‚„ã™ã„ã‚¯ã‚¨ãƒªã®æ›¸ãæ–¹ - kagamihogeã®æ—¥è¨˜
ä¿ºã¯å®Ÿå‹™çµŒé¨“ã‚’ã‚ã‚‹ç¨‹åº¦ã“ãªã—ãŸã‚ã¨ã€RDBã®çŸ¥è˜ä¸è¶³ã‚’èªè˜ã—ãŸã‚¯ãƒã§ã‚ã‚‹ã€‚æ”¹ã‚ã¦RDBã‚’å‹‰å¼·ã—å§‹ã‚ã¦å›°ã£ãŸã“ã¨ã®ä¸€ã¤ã¯ã€å®Ÿè¡Œè¨ˆç”»ã®èªã¿æ–¹ãŒã‚ˆãã‚ã‹ã‚‰ãªã„ã“ã¨ã ã£ãŸã€‚ã‚‚ã¡ã‚ã‚“ã€ããã‚Œã°NESTED LOOP JOINãŒä½•ã‹ã¨ã‹ã¯å‡ºã¦ãã‚‹ã—ã€å…¬å¼ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚‚å‚è€ƒã«ãªã‚‹ã€‚ãŸã ã€webã®æ–‡çŒ®ã¯ä½“ç³»ã ã£ã¦è§£èª¬ãŒã‚ã‚‹ã¨ã¯é™ã‚‰ãªã„ã—ã€å€‹äººã®ãƒ–ãƒã‚°ãªã©ã¯ç²’åº¦ãŒãƒãƒ©ãƒãƒ©ã§ã€ã¾ã¨ã¾ã£ãŸé‡ã®çŸ¥è˜ã‚’å¾—ã‚‹ã«ã¯å‘ã„ã¦ã„ãªã„ã€‚ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚‚è†¨å¤§ãªé‡ãŒã‚ã‚‹ã®ã§æ…£ã‚Œã¦ã„ãªã„ã¨ç›®çš„ã®æ–‡æ›¸ãŒæ›¸ã„ã¦ã‚ã‚‹ã‹ã©ã†ã‹ã™ã‚‰åˆ†ã‹ã‚‰ãªã„ã—ã€ã‚ã£ãŸã¨ã—ã¦ã‚‚å¿…è¦ãªãƒ¬ãƒ™ãƒ«ã®è§£èª¬ãŒã‚ã‚‹ã‹ã©ã†ã¯åˆ†ã‹ã‚‰ãªã„ã€‚ ãã“ã§æœ¬æ›¸ã®å‡ºç•ªã§ã‚ã‚‹ã€‚æ—¢å˜ã®æ›¸ç±ã«ã‚‚SQLã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è«–ã˜ãŸã‚‚ã®ã¯ã‚ã‚‹ã«ã¯ã‚ã‚‹ã®ã ãŒã€ãã‚Œã«ç‰¹åŒ–ã—ãŸæœ¬ã®å˜åœ¨ã¯ã€å°‘ãªãã¨ã‚‚ä¿ºã¯çŸ¥ã‚‰ãªã„ã€‚ä¸€å†Šã ã‘ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¢ãƒƒãƒ—ã®æ•™ç§‘æ›¸ åŸºæœ¬åŽŸç†ç·¨ - kagamihogeã®æ—¥è¨˜ã¨ã„ã†æ¥µ
rudo108 2015/05/27
sql
ãƒªãƒ³ã‚¯
é»’çŒ«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å·¥æˆ¿ - é»’çŒ« SQL Studio (æ±Žç”¨SQLé–‹ç™ºç’°å¢ƒ/é–‹ç™ºãƒ„ãƒ¼ãƒ«/ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ)
â– é»’çŒ« SQL Studio Next é»’çŒ« SQL Studio Next ã¯ã€ã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šå¯èƒ½ãªæ±Žç”¨SQLé–‹ç™ºç’°å¢ƒã§ã™ã€‚ é»’çŒ« SQL Studio Next ã«ã¯ã€SQLã‚’æ‰‹æ—©ãä½œã‚‹ãŸã‚ã®å€™è£œè¡¨ç¤ºæ©Ÿèƒ½ã‚„ã€ SQLã‚’è¦–è¦šçš„ã« ãƒ‡ã‚¶ã‚¤ãƒ³ã™ã‚‹ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ«ã‚¯ã‚¨ãƒªãƒ¼ãªã©ã€SQLé–‹ç™ºè€…ã«ä¾¿åˆ©ãªæ©Ÿèƒ½ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ é»’çŒ« SQL Studio Next ã¯ãƒ•ãƒªãƒ¼ã‚¦ã‚§ã‚¢ã§ã™ã€‚å€‹äººä½¿ç”¨ã€æ¥å‹™ä½¿ç”¨ã«é–¢ã‚ã‚‰ãšè‡ªç”±ã«ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ é»’çŒ« SQL Studio Next ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ â– ã‚¯ã‚¤ãƒƒã‚¯ãƒ„ã‚¢ãƒ¼ ã¾ãŸã¯ã“ã¡ã‚‰ â‡’ é»’çŒ« SQL Studio Next ã‚¯ã‚¤ãƒƒã‚¯ãƒ„ã‚¢ãƒ¼ â– ç‰¹å¾´ é»’çŒ« SQL Studio Next ã¯ã€é–‹ç™ºç¾å ´ã§ã®ä½¿ã„å‹æ‰‹ã®è‰¯ã•ã‚’è¿½æ±‚ã—ã¦ã„ã¾ã™ã€‚ 1. ã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶š ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã«ADOã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ãŸã‚ã€OLE DB ãƒ—ãƒãƒã‚¤ãƒ€(ã‚ã‚‹ã„ã¯OD
rudo108 2015/01/19
software

db

sql
ãƒªãƒ³ã‚¯
Apache Hive
Apache Hive The Apache Hive â„¢ is a distributed, fault-tolerant data warehouse system that enables analytics at a massive scale and facilitates reading, writing, and managing petabytes of data residing in distributed storage using SQL. Github Mail Docker Community Apache Hive is a distributed, fault-tolerant data warehouse system that enables analytics at a massive scale. Hive Metastore(HMS) provid
rudo108 2013/10/25
hive

sql

doc

todo

hadoop
ãƒªãƒ³ã‚¯
(Perl) DBIã§SQLiteã‚’ä½¿ã†å ´åˆã®æ–‡å—ã‚¨ã‚¹ã‚±ãƒ¼ãƒ— (r271-635)
Perlã§SQLã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹å ´åˆã€å®Ÿéš›ã«ã¡ã‚ƒã‚“ã¨ç‰¹æ®Šæ–‡å—ãŒã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ï¼ˆã‚¯ã‚ªãƒ¼ãƒˆï¼‰ã•ã‚Œã¦ã„ã‚‹ã‹å¿ƒé…ã«ãªã£ã¦ã€èª¿ã¹ã¦ã¿ãŸã€‚ Perlã®ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ #!/usr/bin/perl use strict; # å¤‰æ•°ã®å®£è¨€ã‚’å¼·åˆ¶ã™ã‚‹ use DBI; # DBI ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹ my $dbh = undef; my $sth = undef; my $strQuery = ""; my $strTmp = ""; eval{ # DBã«æŽ¥ç¶š $dbh = DBI->connect($strDsn, "", "", {PrintError => 1, AutoCommit => 1}); if(!$dbh) { die();} $dbh->trace(2,"./dbi_trace.txt"); # ãƒ‡ãƒãƒƒã‚°ãƒˆãƒ¬ãƒ¼ã‚¹ã‚’ãƒ•ã‚¡ã‚¤ãƒ«å‡ºåŠ› print("input new data string
rudo108 2012/12/12
perl

sql
ãƒªãƒ³ã‚¯
SQLiteã§å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œã®åŸºç¤Ž - Perlå…¥é–€ã‚¼ãƒŸ
Perl â€º ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ â€º here Perlã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯åˆç´šè€…ãŒå¦ã¶ã«ã¯ä»Šã¾ã§ã¯å°‘ã—æ•·å±…ã®é«˜ã„ã‚‚ã®ã§ã—ãŸã€‚ã¾ãšSQLã®å®Ÿè¡Œç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã™ãã«å‹‰å¼·ã—ãŸã„ã¨ã„ã†éœ€è¦ã‚’æº€ãŸã™ã“ã¨ã¯ã§ãã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚ ã§ã™ãŒç¾åœ¨ã¯ã“ã®çŠ¶æ³ã¯å¤‰ã‚ã‚Šã¾ã—ãŸã€‚ç¾åœ¨ã§ã¯ActivePerlã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã¨DBD::SQLiteã¨å‘¼ã°ã‚Œã‚‹SQLiteã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒ³ã‚°ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã¾ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ãŸã‚ã®ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰è¦‹ãŸã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹éƒ¨åˆ†ã«ã‚ãŸã‚‹DBIã¨ã„ã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚‚ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒ³ã‚°ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã§ã™ã®ã§ActivePerlã®æœ€æ–°ç‰ˆã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã ã‘ã§ä½•ã®ç’°å¢ƒæ§‹ç¯‰ã‚‚è¡Œã‚ãªã„ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ç¿’ã—å§‹ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ DBD::SQLiteã¨DBIãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’ç¢ºèªã™ã‚‹ ã¾ãšDBD::SQLiteã¨DBIãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã‹ã©
rudo108 2012/12/12
perl

sql
ãƒªãƒ³ã‚¯
[é›‘è¨˜] LINQ to SQL å®Ÿè·µç·¨
ã§ã¯ã€Visual Studio ã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆæ‰‹é †ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã¾ãšã€Visual Studio ã® [ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©] ã§ã€LinqToSqlTest ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’å³ã‚¯ãƒªãƒƒã‚¯ã—ã¦ã€ [è¿½åŠ ] â†’ [æ–°ã—ã„é …ç›®] ã‚’é¸ã³ã¾ã™ã€‚ ãƒ€ã‚¤ã‚¢ãƒã‚°ãŒé–‹ã„ãŸã‚‰ã€[ã‚«ãƒ†ã‚´ãƒª] ã‹ã‚‰ [ãƒ‡ãƒ¼ã‚¿] â†’ [ã‚µãƒ¼ãƒ“ã‚¹ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] ã‚’é¸ã‚“ã§ã€ é©å½“ãªåå‰ã‚’ã¤ã‘ã¦ï¼ˆã“ã“ã§ã¯ ComicDatabase.mdf ã¨ã—ã¾ã™ï¼‰ [è¿½åŠ ] ãƒœã‚¿ãƒ³ã‚’æŠ¼ã—ã¾ã™ã€‚ ã§ããŸ mdf ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©ä¸Šã§ãƒ€ãƒ–ãƒ«ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨ã€ [ã‚µãƒ¼ãƒãƒ¼ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©] ãŒé–‹ãã®ã§ã€ ã‚µãƒ¼ãƒãƒ¼ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©ä¸ã® [ãƒ†ãƒ¼ãƒ–ãƒ«] ã®ã¨ã“ã‚ã‚’å³ã‚¯ãƒªãƒƒã‚¯ã—ã¦ [æ–°ã—ã„ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¿½åŠ ] ã‚’è¡Œã„ã¾ã™ã€‚ ä¸Šè¨˜ã®è¡¨1ï½ž4ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’è¡Œã£ã¦ãã ã•ã„ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«åã¯ã€å³ä¸‹ã«å‡ºã¦ã„ã‚‹ [ãƒ—ãƒ
rudo108 2011/08/26
ãªã‚‹ã»ã©ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã¤ãªãéƒ¨åˆ†ãŒå¿…è¦ã ã£ãŸã®ã‹ã€‚

linq

sql

c#
ãƒªãƒ³ã‚¯
C# ã«ã‚ˆã‚‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ [ãƒ‡ãƒ¼ã‚¿å‡¦ç†] LINQ
æ¦‚è¦ Ver. 3.0 C# 3.0ï¼ˆãã—ã¦ã€åŒæ™‚ã«ç™ºè¡¨ã•ã‚ŒãŸ VB 9.0ï¼‰ã®ç›®çŽ‰ã¨ãªã‚‹æ–°æ©Ÿèƒ½ã¯ã€ Language Integrated Queryã€ç•¥ã—ã¦ LINQ ã¨å‘¼ã°ã‚Œã‚‹ã‚‚ã®ã§ã€ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ XML ã«å¯¾ã™ã‚‹æ“ä½œã‚’ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã«çµ±åˆã™ã‚‹ã‚‚ã®ã§ã™ã€‚ LINQ ã‚’ç”¨ã„ã‚‹ã“ã¨ã§ã€æ§˜ã€…ãªã‚¿ã‚¤ãƒ—ã®ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹æ¤œç´¢ã‚„æ“ä½œã‚’ã€ å…±é€šã®æ§‹æ–‡ã§è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ IEnumeable ã‚’å®Ÿè£…ã™ã‚‹ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã‚¯ãƒ©ã‚¹ã«å¯¾ã™ã‚‹ã‚‚ã®ï¼ˆLINQ to Objectï¼‰ã‚„ã€ XML ã«å¯¾ã™ã‚‹ã‚‚ã®ï¼ˆLINQ to XMLï¼‰ã€ ãã‚Œã«ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã«å¯¾ã™ã‚‹ SQL ã‚¯ã‚¨ãƒªã‚’ç”Ÿæˆã™ã‚‹ã‚‚ã®ï¼ˆLINQ to SQLï¼‰ãªã©ãŒã‚ã‚Šã¾ã™ã€‚ LINQ ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªåˆ©ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘è¨€èªžã‚‰ã—ã„æ›¸ãæ–¹ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®å•ã„åˆã‚ã›ãŒã§ãã¾ã™ã€‚ in-memor
rudo108 2011/08/25
èªã‚ã‚‹ï¼ç§ã«ã‚‚èªã‚ã‚‹ï¼ï¼ï¼

C#

sql

linq
ãƒªãƒ³ã‚¯
SQLã®åŸºç¤Ž ã€ŒSELECTã€æ–‡ã‚’è¦šãˆã‚ˆã†
æœ¬è¨˜äº‹ã®ãŠã‚‚ãªå†…å®¹ ã„ã‚ã„ã‚ã‚ã‚‹SQLã®è¦æ ¼ ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã—ã¦ã¿ã‚‹ SELECTæ–‡ã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ WHEREå¥ã®ä½¿ã„æ–¹ æ¡ä»¶ã®æŒ‡å®šæ–¹æ³• ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã‚‚ã€ä»Šã‚„ã€ã‚·ã‚¹ãƒ†ãƒ ã®æ§‹ç¯‰ã«ã¯ä¸å¯æ¬ ãªã‚‚ã®ã¨ãªã‚Šã¾ã—ãŸã€‚çš†ã•ã‚“ãŒç›®ã«ã—ã¦ã„ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã‚„ã€ç®¡ç†ã—ã¦ã„ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã§ã‚‚ã€RDBMSãŒä½¿ã‚ã‚Œã¦ã„ãªã„ã‚·ã‚¹ãƒ†ãƒ ã‚’æŽ¢ã™ã»ã†ãŒå¤§å¤‰ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚RDBMSã®æ™®åŠã«ã¨ã‚‚ãªã„ã€RDBMSã¸ã®ã‚¢ã‚¯ã‚»ã‚¹æ‰‹æ®µã§ã‚ã‚‹SQLã‚‚ã€æ—¥å¸¸çš„ã«ã‚ˆãè¦‹ã‹ã‘ã‚‹ã‚‚ã®ã¨ãªã‚Šã¾ã—ãŸã€‚ ã“ã®SQLå®Ÿè·µè¬›åº§ã§ã¯ã€SQLã®åŠ¹çŽ‡çš„ãªä½¿ã„æ–¹ã‚’ã‚¨ãƒƒã‚»ãƒ³ã‚¹ã«ã—ã¦ãŠä¼ãˆã—ã¦ã„ã“ã†ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚SQLã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’æ“ä½œã™ã‚‹ãŸã‚ã«éžå¸¸ã«ç°¡å˜ãªæ§‹æ–‡ã§æ§‹æˆã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã«è¦‹ãˆã¾ã™ã€‚ã¨ã“ã‚ãŒã€å®Ÿéš›ã«ä½¿ã„è¾¼ã‚“ã§ã„ãã¨ã€ä¸€è¦‹ç°¡å˜ã«å–å¾—ã§ãã‚‹ã‚ˆã†ã«è¦‹ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãŒå–å¾—ã§ããªã„å ´é¢ã«ã¶ã¡å½“ãŸã‚‹ã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ã¾ãŸé€†ã«
rudo108 2011/08/25
sql

MySQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
1