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

masakitk id:masakitk

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

åˆ†æžSQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ« - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
SQLã€æ›¸ã„ã¦ã¾ã™ã‹ï¼Ÿ ã“ã¨å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®åˆ†é‡Žã«ãŠã„ã¦ã¯SQLã¯ã‚‚ã¯ã‚„æ¨™æº–ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã§ã‚ã‚Šã€ åˆ†æžã‚„ã‚‰ãƒãƒƒãƒã‚„ã‚‰ã«é–¢ã‚ã£ã¦ã„ã‚‹çš†æ§˜ã¯æ—¥ã€…å¤§é‡ã®SQLã‚¯ã‚¨ãƒªãƒ¼ã‚’ç”Ÿç”£ã—ã¦ã„ã‚‹ã“ã¨ã¨æ€ã„ã¾ã™ã€‚ ãã“ã§ã¡ã‚‡ã£ã¨æ°—ã«ãªã‚‹ã®ãŒã€ SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ«ã£ã¦ã©ã†ã™ã‚‹ã®ãŒä¸€èˆ¬çš„ãªã‚“ã ã£ã‘â€¦â€¦ï¼Ÿ ã¨ã„ã†ç‚¹ã§ã™ã€‚ ã‚¤ãƒžãƒ‰ã‚ã¯SQLãªã‚“ã¦O/R mapperã«åã‹ã›ã‚‹ã“ã¨ãŒå¤šã„ã‹ã‚‰ãªã®ã‹ã€ ãã‚Œã¨ã‚‚ã‚³ãƒ¼ãƒ‰ã‚’åºƒã„ç¯„å›²ã§å…±æœ‰ã™ã‚‹ã“ã¨ãŒãã‚‚ãã‚‚ãªã„ã‹ã‚‰ã‹ã€ SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ«ã«ã¤ã„ã¦è¦‹èžãã™ã‚‹ã“ã¨ã¯ä»–ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã«æ¯”ã¹ã‚‹ã¨ã ã„ã¶å°‘ãªãã€ ã„ã¾ã„ã¡æ±ºå®šç‰ˆã¨è¨€ãˆã‚‹ã‚¹ã‚¿ã‚¤ãƒ«ãŒãªã„ãªã¨æ„Ÿã˜ã¦ã„ã¾ã™ã€‚ ãã‚“ãªã‚ã‘ã§æœ¬æ—¥ã¯ã€SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ«ã«ã¤ã„ã¦ã®æ„è˜ã‚’æ´»ç™ºåŒ–ã•ã›ã‚‹ã¹ãã€ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã‚ãŸã—ï¼ˆé’æœ¨ï¼‰ãŒä½¿ã£ã¦ã„ã‚‹ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ«ã‹ã‚‰ç‰¹å¾´çš„ãªç‚¹ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç‰¹ã«ã€åˆ†æž
masakitk 2016/11/09
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æ‹…å½“ï¼‰ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã¯ãƒ•ã‚©ãƒ«ãƒˆãƒˆãƒ¬ãƒ©ãƒ³ãƒˆã§ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ä¸è¦ã€ãƒ‘ãƒƒãƒã‚‚ç§ãŸã¡ãŒé©ç”¨ã—ã¦ãŠã‚Šã€åˆ©ç”¨è€…ã¯é‹ç”¨ã«ã¤ã„ã¦å¿ƒé…ã™ã‚‹å¿…è¦ãŒãªã„ã€ã¨ã„ã£ãŸãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„åœ°åŸŸåˆ†æ•£ã§ãƒ‡ãƒ¼ã‚¿ã‚‚ä¿å…¨ã•ã‚Œã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒ
masakitk 2012/07/22
NoSQL

sql

ã‚¯ãƒ©ã‚¦ãƒ‰
ãƒªãƒ³ã‚¯
SQL Server Compact Edition 3.5ã®ä½¿ã„æ–¹ - ã‚„ãã†ã‚‰ãŠãƒ–ãƒã‚°(ç§»è»¢ã—ã¾ã—ãŸ)
Windowsã‚¢ãƒ—ãƒªã§ã‚‚ã¡ã‚‡ã£ã¨ã—ãŸãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã®ãŸã‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ãˆã‚‹ã¨ä¾¿åˆ©ã§ã‚ã‚‹ã€‚å¾“æ¥ã¯ã€SQLiteãªã‚“ã‹ã‚’ä½¿ã£ã¦ã„ãŸã¨æ€ã†ã®ã ãŒã€SQL Server Compact Edition 3.5(ä»¥ä¸‹SQLSCe)ã¨ã„ã†ä¾¿åˆ©ãªã‚‚ã®ãŒã‚ã‚‹ã®ã§ã€ä»Šå›žã¯ã“ã‚Œã®ä½¿ã„æ–¹ã‚’è§£èª¬ã™ã‚‹ã€‚ ä¸»ãªåˆ©ç‚¹ã¯ ãƒ»LINQã§æ›¸ã‘ã‚‹ ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’VisualStudioã‹ã‚‰ç°¡å˜ã«ç·¨é›†ã§ãã‚‹ ãƒ»SQLiteã¨é•ã£ã¦åž‹ãŒã—ã£ã‹ã‚Šã—ã¦ã„ã‚‹ ãªã©ã€‚ å®Ÿè¡Œé€Ÿåº¦çš„ã«ã¯ã€SQLiteã¨ãã‚“ãªã«å¤‰ã‚ã‚‰ãªã„ã€‚ã‚‚ã®ã«ã‚ˆã£ã¦ã¯SQLiteã®ã»ã†ãŒé€Ÿã„ã—ã€ã‚‚ã®ã«ã‚ˆã£ã¦ã¯SQLSCeã®ã»ã†ãŒé€Ÿã„ã€‚ ä¸»ãªãƒ‡ãƒ¡ãƒªãƒƒãƒˆã¯ ãƒ»èª°ã‚‚ä½¿ã£ã¦ãªã„ã®ã§è³‡æ–™ã«ä¹ã—ã„ ãƒ»åˆ¶é™ãŒçµæ§‹ã‚ã‚‹ ãƒ»ä½œã‚Šè¾¼ã¿ãŒè¶³ã‚Šãªã„ ãªã©ã€‚ SQLSCeã¯å¤§å¤‰ä¾¿åˆ©ãªã‚·ãƒãƒ¢ãƒŽã§ã€Windowsã‚¢ãƒ—ãƒªé–‹ç™ºã«ãŠã„ã¦ã¯ä»Šå¾Œã‹ãªã‚Šé‡è¦ãªä½ç½®ã«æ¥ã‚‹ã‚‚ã®ã ã¨æ€ã†ã®ã ãŒã€ã ã¶ã‚“ã€å¤šãã®äººã¯ä½•ã‚’ã©ã†ã—
masakitk 2011/11/16
LINQ

sql

SQL Server Compact
ãƒªãƒ³ã‚¯
sqliteãŒãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®æ™‚ã®TracReportã‚’æ›¸ãtips â€” ã‚ã‚Šãˆã‚‹ãˆã‚Šã‚
sqliteãŒãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®æ™‚ã®TracReportã‚’æ›¸ãtips sqliteãŒãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®æ™‚ã®TracReportã®SQLã‚’æ›¸ãtipsã§ã™ã€‚ ä¸»ãªãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ (ticket) CREATE TABLE ticket ( id integer PRIMARY KEY, type text, time integer, changetime integer, component text, severity text, priority text, owner text, reporter text, cc text, version text, milestone text, status text, resolution text, summary text, description text, keywords text ); CREATE TABLE ticket_custom
masakitk 2011/06/03
ãƒ†ãƒ¼ãƒ–ãƒ«

trac

tips

sql
ãƒªãƒ³ã‚¯
neue cc - DbExecutor ver.2 - C#ã§ã®ç”ŸSQLæ›¸ãè£œåŠ©ãƒ©ã‚¤ãƒ–ãƒ©ãƒª
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç”¨ã®ã©ã“ã«ã§ã‚‚è»¢ãŒã£ã¦ã„ãã†ãªã‚·ãƒ³ãƒ—ãƒ«ãªãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã€Part2ã€‚å…¨é¢çš„ã«ã¤ãã‚Šç›´ã—ã¾ã—ãŸ(Part1ã‚‚ã‚ã‚Šã¾ã—ãŸã€ä¸€å¹´å‰ã«å…¬é–‹ã—ã¦ã¾ã™ã€ãŒã€æ£ç›´ã‚¤ãƒžã‚¤ãƒã ã£ãŸï¼)ã€‚ DbExecutor - Simple and Lightweight Database Executor NuGet - DbExecutor ä½•ã§ã“ã®æ™‚æœŸã«ï¼Ÿã¨ã„ã†ã¨ã€ç¨ã‚“ã§ã„ã‚‹ã®ã¯WP7ã«SQLCEãŒä¹—ã‚‹ã¨ã„ã†è©±ã€ã§ã™ã€‚ã¾ã‚ã€Linq to HogeãŒç©ã¾ã‚Œã‚‹ã‚ˆã†ãªã®ã§ã€ã‚¤ãƒ©ãƒãƒ¼ã ã‚ã¨ã„ã†è©±ã¯ã‚ã‚‹ã®ã§ã™ãŒï¼ã‚ã‚‹ã®ã§ã™ãŒã€ãã‚Œã§ã‚‚ç”ŸSQLã‚’ä½¿ã‚ã–ã‚‹ã‚’å¾—ãªã„ã‚·ãƒãƒ¥ã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ã¯å‡ºã¦ãã‚‹ã¯ãšã§ã€ãã®ãŸã‚ã«ã€ä»Šã®ã†ã¡ã«ä½œã£ã¦ãŠã/ä½œã‚ŠãªãŠã—ã¦ãŠã“ã†ã‹ã¨ã€‚ã¾ã WP7ã§ã©ã†ã„ã†å½¢ã§è¼‰ã‚‹ã®ã‹åˆ†ã‹ã‚‰ãªã„ã®ã§ã€ä»Šã¯æ™®é€šã«.NET 4 Client Profileç”¨ã§ã™ã€‚WP7ã¸ã¯SDKãŒå‡ºæ¬¡ç¬¬ã€ã™ãã«å¯¾å¿œã•ã›ã‚‹ã¤ã‚‚ã‚Šã€‚ ã•ã¦
masakitk 2011/05/01
.NET

sql
ãƒªãƒ³ã‚¯
ã€ŽPL/pgSQLã§ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸å‡ºåŠ›ã€
PostgreSQL ã§ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’ä½œã‚‹ã«ã¯ PL/pgSQL ã¨ã„ã†SQLæ‰‹ç¶šãè¨€èªžã‚’ä½¿ã„ã¾ã™ã€‚ Oracle ã§ã„ã†ã¨ã“ã‚ã® PL/SQL (ã ã£ãŸã£ã‘)ã€€ã«ã‚ãŸã‚‹ SQL æ‰‹ç¶šãè¨€èªžã§ã™ã€‚ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’ä½¿ã†ã¨æ•°å›ž SQL ã‚’å®Ÿè¡Œã—ã¦ãã®çµæžœã‚’ã”ã«ã‚‡ã”ã«ã‚‡ã¾ã¨ã‚ãŸã‚Šã—ãŸçµæžœã‚’1å›žã® select æ–‡ã§å–ã‚Šå‡ºã›ãŸã‚Šã™ã‚‹ã®ã§ä¾¿åˆ©ãªã®ã§ã™ãŒã€CGI ã®ã‚³ãƒ¼ãƒ‰ã ã‘è¦‹ã¦ã‚‚æŠŠæ¡ã§ããªã„ã®ãŒé›£ã§ã™ãã€‚ ã§ã€äººãŒä½œã£ãŸã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’ã¡ã‚‡ã£ã¨æ”¹é€ ã—ãªãã¦ã¯ã„ã‘ãªããªã£ã¦ã€function å®šç¾©ã‚’èªã‚“ã¡ã‚‡ã“ã¡ã‚‡ã“ã£ã¨æ‰‹ã‚’å…¥ã‚Œã¦ã¿ãŸã®ã§ã™ãŒæ€ã†ã‚ˆã†ã«å‹•ã‹ãªã„ã€‚ ç§ã¯ãƒ‡ãƒãƒƒã‚°ã™ã‚‹ã¨ãã«ã¯ãƒ‡ãƒãƒƒã‚¬ã¯ã»ã¨ã‚“ã©ä½¿ã£ã¦ã„ãªãã¦ã€ãƒ‡ãƒãƒƒã‚°ãƒ©ã‚¤ãƒˆã‚’å…¥ã‚Œã¾ãã£ã¦ã©ã®ã‚ˆã†ã«ã‚³ãƒ¼ãƒ‰ãŒå‹•ãã®ã‹æŠŠæ¡ã—ãªãŒã‚‰ç›´ã—ã¾ã™ã€‚ã€‚ã‚¢ãƒŠãƒã‚°ã™ãŽã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ã‚¹ã‚¯ãƒªãƒ—ãƒˆã¯ã“ã‚Œã§æ¡ˆå¤–äº‹è¶³ã‚Šã‚‹ã®ã§ã€‚ ãã‚“ãªã‚ã‘ã§ã€ä»Šå›ž
masakitk 2011/03/08
postgresql

sql
ãƒªãƒ³ã‚¯
404 Blog Not Found:æ›¸è©•x3 - SQLæœ¬ä¸‰å¤§å¯¾æ±º
2008å¹´02æœˆ03æ—¥04:00 ã‚«ãƒ†ã‚´ãƒªæ›¸è©•/ç”»è©•/å“è©•Lightweight Languages æ›¸è©•x3 - SQL æœ¬ä¸‰å¤§å¯¾æ±º 404 Blog Not Found:ã“ã®ç™ºæƒ³ã¯ãªã‹ã£ãŸ - æ›¸è©• - é€†ç®—å¼SQLæ•™ç§‘æ›¸ã‚’æ›¸ã„ãŸã‚‰ã€ã€Œã„ã‚„ã€ã†ã¡ã‚‚ã€ã¨ã°ã‹ã‚Šã«ã©ã£ã•ã‚ŠSQL æœ¬ãŒæ¥ãŸã€‚ ã¾ãšã‚ªãƒ©ã‚¤ãƒªãƒ¼ãƒ»ã‚¸ãƒ£ãƒ‘ãƒ³ã®çŸ¢é‡Žæ§˜ã‹ã‚‰ã¯ã€ã€ŒSTATISTICS HACKS(å’Œè¨³)ã€ã¨ä¸€ç·’ã«ã€ŒSQLã‚¯ãƒƒã‚¯ãƒ–ãƒƒã‚¯ã€ã¨ã€ŒSQL Hacks ã€ã‚’ã€ãã—ã¦C&Rç ”ç©¶æ‰€ã®å‰æˆæ§˜ã‹ã‚‰ã¯ã€ŒSQLå®Ÿè·µæ´»ç”¨å¤§äº‹å…¸ ã€ã‚’çŒ®æœ¬ã„ãŸã ã„ãŸã€‚ ã“ã‚Œã ã‘é ‚ãã¨ã€ã¾ã¨ã‚ãªã„ã‚ã‘ã«ã¯è¡Œã‹ãªã„ã ã‚ã†ã¨ã„ã†ã“ã¨ã§ã€ã¾ã¨ã‚ã¦ã¿ãŸã€‚ ã¾ãšã€ã€ŒSQLã‚¯ãƒƒã‚¯ãƒ–ãƒƒã‚¯ã€ã€‚ã“ã¡ã‚‰ã¯ç”³ã—è¨³ãªã„ã®ã ã‘ã©ã€ã‹ãªã‚ŠæœŸå¾…ã¯ãšã‚Œã€‚ç¢ºã‹ã«ã€Œé€†ç®—å¼SQLæ•™ç§‘æ›¸ã€ã‚ˆã‚Šã¯ç”¨ä¾‹ã‚‚å¤šã‹ã£ãŸã®ã ã‘ã©ã€Cookbookã‚’ç‰¹å¾´ã¥ã‘ã¦ã„ãŸç¶¿å¯†ãªDiscussionãŒã‚¹ã‚«ã‚¹ã‚«ã€‚ä»–ãªã‚‰ã¨
masakitk 2011/02/15
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

db

sql

æœ¬

é–‹ç™ºè³‡æ–™
ãƒªãƒ³ã‚¯
1