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

kitchy id:kitchy

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

${{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ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³• æ˜”Qiitaã§æ›¸ã„ãŸã‚‚ã®ã‚’zennã«ã†ã¤ã—ã¦ã€è‹¥å¹²ã®ä¿®æ£ã€è¿½åŠ ã‚’ã—ã¦ã¿ã¾ã—ãŸã€‚ ORACLEã§ã®çµŒé¨“ã‚’å…ƒã«æ›¸ã„ã¦ã„ã¾ã™ãŒã‚³ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ã¹ãƒ¼ã‚¹ãªã‚‰å¤§ä½“å…±é€šã®è€ƒãˆæ–¹ã ã¨æ€ã†ã®ã§ä»–ã«ã‚‚ä½¿ãˆã‚‹ã¨æ€ã„ã¾ã™ã€‚ SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã„ãˆã°æ¯”è¼ƒçš„å®¹æ˜“ã«æ¸ˆã‚€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¨ã‚Šã‚ãˆãšä½œæˆã™ã‚‹ã€‚ã¨ã„ã£ãŸå¯¾å¿œã‚’å–ã‚‰ã‚ŒãŒã¡ã§ã™ãŒã€æ•°ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ç¨‹åº¦ã§ã®ãƒ‡ãƒ¼ã‚¿é‡ã§ã¯ã‚ã¾ã‚ŠåŠ¹ãç›®ãŒãªãï¼ˆè‡ªåˆ†ã®çµŒé¨“å‰‡ï¼‰ã€ã©ã¡ã‚‰ã‹ã¨ã„ãˆã°ã€çµåˆé †ãŒå¤§å¹…ã«ç‹‚ã£ã¦ãŸã‚Šã™ã‚‹ã“ã¨ãŒåŽŸå› ã®ã“ã¨ãŒå¤šã‹ã£ãŸã‚Šã—ã¾ã™ã€‚ã‚ˆã£ã¦æœ¬å½“ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒãªã„ã“ã¨ãŒåŽŸå› ãªã®ã‹ï¼Ÿã‚’ç†Ÿè€ƒã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ï¼ˆä¾‹ãˆã°IDä»¥å¤–ã®ãƒ•ãƒ©ã‚°ã¨ã‹ã‚³ãƒ¼ãƒ‰ã«å˜é …ç›®indexã‚’è²¼ã£ã¦ã‚‹ã®ã‚‚ã¿ãŸã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚æ€–ã„ã‘ã©å®Ÿè©±ï¼‰ ã¾ãŸã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã‚Šã™ãŽã‚‹ã¨ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ãŒç‹‚ã„ã‚„ã™ããªã£ã¦ä»–ã®SQLã«ã‚‚æ‚ªå½±éŸ¿ã‚’åŠã¼ã—ãŸã‚Šã™ã‚‹ã®ã§çµæ§‹ç†Ÿæ…®ã—ã¦è¿½åŠ
kitchy 2021/06/30
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

sql
ãƒªãƒ³ã‚¯
PostgreSQL: ã€ŒORã€ã‚’é¿ã‘ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚ˆã†ï¼ˆç¿»è¨³ï¼‰ï½œTechRacho by BPSæ ªå¼ä¼šç¤¾
æ¦‚è¦ åŽŸè‘—è€…ã®è¨±è«¾ã‚’å¾—ã¦ç¿»è¨³ãƒ»å…¬é–‹ã„ãŸã—ã¾ã™ã€‚ è‹±èªžè¨˜äº‹: avoid OR for better PostgreSQL query performance - Cybertec åŽŸæ–‡å…¬é–‹æ—¥: 2018/05/07 è‘—è€…: Laurenz Albe ã‚µã‚¤ãƒˆ: CYBERTEC -- ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹åˆ†é‡Žã§ã®PostgreSQLã‚µãƒãƒ¼ãƒˆã‚„ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã‚’è¡Œã£ã¦ã„ã‚‹ä¼æ¥ã§ã™ â€»æŒ¿çµµã¯åŽŸè‘—è€…è‡ªã‚‰ã«ã‚ˆã‚‹ã‚‚ã®ã§ã™ã€‚ ç”Ÿãã‚‹ã¹ãã‹ã€ŽORã€æ»ã™ã¹ãã‹ã€ãã‚ŒãŒå•é¡Œã ã€ ã€Œå¸°ã‚Œï¼ã€ã€ŒéžåŠ¹çŽ‡ï¼ã€ã€ŒåŒç¾©åå¾©ï¼ã€ Â© Laurenz Albe 2018PostgreSQLã‚¯ã‚¨ãƒªã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯ç§ãŸã¡Cybertecã®æ—¥å¸¸çš„ãªæ¥å‹™ã§ã™ãŒã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ä¸ã«ã‚¯ã‚¨ãƒªã«ORã‚’1ã¤ã§ã‚‚è¦‹ã¤ã‘ãŸçž¬é–“ã€æã‚ã—ã•ã«èº«ã®æ¯›ã‚‚ã‚ˆã ã¤æ€ã„ãŒã—ã¾ã™ã€‚ãŸã„ã¦ã„ã®å ´åˆã€ORã¯ã‚¯ã‚¨ãƒªã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ä½Žä¸‹ã®åŽŸå› ã¨ãªã‚‹ã‹ã‚‰ã§ã™ã€‚ è¨€ã†ã¾ã§ã‚‚ãªã„ã“
kitchy 2020/06/18
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

sql
ãƒªãƒ³ã‚¯
SQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ãã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ–ãƒƒã‚¯
é–‹ç™ºè€…å‘ã‘ã®SQLã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è§£èª¬ã‚µã‚¤ãƒˆã€ç®¡ç†ã«ã¤ã„ã¦ã®é–“é•ã„ãªã„çŸ¥è˜ã‚’æä¾›ã—ã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯é–‹ç™ºæ™‚ã«ã¯å¿˜ã‚Œã‚‰ã‚ŒãŒã¡ã§ã‚ã‚‹ä¸€æ–¹ã§ã€éžå¸¸ã«åŠ¹æžœçš„ãªSQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³•ã§ã™ã€‚Use The Index, Lukeã§ã¯ã€Hibernateãªã©ã®ORMãƒ„ãƒ¼ãƒ«ã®è§£èª¬ã«ã¨ã©ã¾ã‚‰ãšã€SQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åŸºç¤Žã‹ã‚‰èª¬æ˜Žã—ã¾ã™ã€‚ Use The Index, Lukeã¯SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã®Webä¸Šã®ç„¡æ–™ç‰ˆã§ã™ã€‚ã‚µã‚¤ãƒˆã‚’æ°—ã«å…¥ã£ã¦é ‚ã‘ãŸã‚‰ã€ãœã²æ›¸ç±ã‚‚è³¼å…¥ã—ã¦ã¿ã¦ä¸‹ã•ã„ã€‚ã¾ãŸã€ã“ã®ã‚µã‚¤ãƒˆã®é‹å–¶ã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹æ§˜ã€…ãªã‚°ãƒƒã‚ºã‚‚è²©å£²ã—ã¦ã„ã¾ã™ã€‚ MySQLã€Oracleã€SQL Serverãªã©ã«ãŠã‘ã‚‹SQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹Use The Index, Lukeã§ã¯ã€ãƒ™ãƒ³ãƒ€ã«ã¨ã‚‰ã‚ã‚Œãªã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®èª¬æ˜Žã‚’å¿ƒãŒã‘ã¦ã„ã¾ã™ã€‚è£½å“ç‰¹æœ‰ã®äº‹æŸ„ã«ã¤ã„ã¦ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªè¡¨ç¤ºã‚’ã—ã¦ã„ã¾ã™ã€‚ Db2 (LUW)U
kitchy 2019/10/24
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

sql
ãƒªãƒ³ã‚¯
SQLã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ Â· SQL style guide by Simon Holywell
æ¦‚è¦ å…¨èˆ¬ æŽ¨å¥¨ éžæŽ¨å¥¨ å‘½åè¦å‰‡ é€šå‰‡ è¡¨ åˆ— åˆ¥åã€ç›¸é–¢å ã‚¹ãƒˆã‚¢ãƒ‰ãƒ»ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ çµ±ä¸€çš„æŽ¥å°¾è¾ž å•åˆã›æ–‡ äºˆç´„èªž ç©ºç™½é¡ž ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆ æœ›ã¾ã—ã„å½¢å¼ Createæ–‡ ãƒ‡ãƒ¼ã‚¿åž‹ã®é¸æŠž ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®æŒ‡å®š åˆ¶ç´„ã¨ã‚ãƒ¼ éžæŽ¨å¥¨è¨è¨ˆ ä»˜éŒ² äºˆç´„èªžãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ SQLã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ï¼ˆæ—¥æœ¬èªžè¨³ï¼‰ æ—¥æœ¬èªžè¨³ã«ã¤ã„ã¦ æ—¥æœ¬èªžè¨³ã¯èª¤è¨³ã‚„åŽŸæ–‡ã®æœ€æ–°ç‰ˆã«è¿½éšã—ã¦ã„ãªã„æã‚ŒãŒã‚ã‚Šã¾ã™ã€‚èª¤è¨³ã‚„æ”¹å–„ç‚¹ãŒã‚ã‚Œã°ã€GitHubã®issueã¾ãŸã¯pull requestã‚’ä½¿ç”¨ã™ã‚‹ã‹ã€Twitterã§ãŠçŸ¥ã‚‰ã›ãã ã•ã„ã€‚ ç¿»è¨³: ä¹…åˆ©å²ä¹‹ @nkuritw æ¦‚è¦ ã“ã®ã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã¯åˆ©ç”¨ã®ä»–ã€forkã—ãŸã‚Šã€è‡ªåˆ†è‡ªèº«ã®ã‚‚ã®ã«æ”¹å¤‰ã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã“ã§å¤§äº‹ãªã®ã¯ã‚¹ã‚¿ã‚¤ãƒ«ã‚’é¸æŠžã—ãã‚Œã‚’è¸è¥²ã™ã‚‹ã“ã¨ã§ã™ã€‚å¤‰æ›´ã®ææ¡ˆã‚„ãƒã‚°ã®ä¿®æ£ã«ã¯GitHubã®issueã¾ãŸã¯pull requestã‚’ä½¿ç”¨ã—ã¦ãã ã•ã„ã€‚ ã“ã®ã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³
kitchy 2019/07/17
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

sql
ãƒªãƒ³ã‚¯
SQLã®å®Ÿè¡Œçµæžœã‚’1ã‚«ãƒ©ãƒ 1è¡Œã§è¡¨ç¤ºã™ã‚‹æ–¹æ³• - ã“ã®ãƒ–ãƒã‚°ã¯URLãŒå¤‰æ›´ã«ãªã‚Šã¾ã—ãŸ
ä¾‹ãˆã°æ¬¡ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã£ã¦ã€ CREATE TABLE testtable ( id INTEGER NOT NULL, title VARCHAR(10) NOT NULL, body TEXT NOT NULL, created TIMESTAMP NOT NULL, PRIMARY KEY (id) ); æ™®é€šã«SELECTã™ã‚‹ã¨ã‚«ãƒ©ãƒ ãŒæ¨ªä¸¦ã³ã§å€¤ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ã“ã“ã§ã¯MySQLã®ä¾‹ã€‚ mysql> INSERT INTO testtable (id, title, body, created) VALUES (1, 'test', 'hello hello', CURRENT_TIMESTAMP); mysql> SELECT * FROM testtable WHERE id = 1; +----+-------+-------------+---------------
kitchy 2012/03/03
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

sql
ãƒªãƒ³ã‚¯
çª“ã®æœ - ã€REVIEWã€‘SQLæ–‡ã®å…¥åŠ›æ”¯æ´ã‚„ERå›³ä½œæˆã«å„ªã‚ŒãŸé«˜æ©Ÿèƒ½ãªSQLé–‹ç™ºç’°å¢ƒã€ŒA5:SQL Mk-2ã€
ã€ŒA5:SQL Mk-2ã€ã¯ã€SQLæ–‡ã®å…¥åŠ›æ”¯æ´ã‚„ERå›³ä½œæˆãªã©ã®æ©Ÿèƒ½ã‚’å‚™ãˆãŸé«˜æ©Ÿèƒ½ãªSQLé–‹ç™ºç’°å¢ƒã€‚Windows 98/2000/XP/Server 2003/Vista/Server 2008/Vista x64ã«å¯¾å¿œã™ã‚‹å¯„ä»˜æ“è¿Žã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã§ã€ä½œè€…ã®Webã‚µã‚¤ãƒˆã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ æœ¬ã‚½ãƒ•ãƒˆã¯ã€SQLæ–‡ã®ä½œæˆãƒ»å®Ÿè¡Œã‚’è¡Œãˆã‚‹æ±Žç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€‚ADOã‚„ODBCãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã‚’åˆ©ç”¨ã—ã¦å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šå¯èƒ½ã§ã€æœ¬ã‚½ãƒ•ãƒˆã§ä½œæˆã—ãŸSQLæ–‡ã‚’å®Ÿè¡Œã—ã€ãã®çµæžœã‚’è¡¨ç¤ºã§ãã‚‹ã€‚ã¾ãŸã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€å®Ÿè¡Œçµæžœã‚’ã€ŒExcelã€ã¸å‡ºåŠ›ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚ ç”»é¢ã¯ã‚µã‚¤ãƒ‰ãƒãƒ¼ã¨ç·¨é›†ç”»é¢ã®2ã¤ã«åˆ†å‰²ã•ã‚Œã¦ãŠã‚Šã€ã‚µã‚¤ãƒ‰ãƒãƒ¼ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŠã‚ˆã³é–¢é€£ã™ã‚‹ã‚¹ã‚ãƒ¼ãƒžãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»ãƒ“ãƒ¥ãƒ¼ã¨ã„ã£ãŸé …ç›®ãŒãƒ„ãƒªãƒ¼å½¢å¼ã§è¡¨ç¤ºã•ã‚Œã‚‹ã€‚ç·¨é›†ç”»é¢ã¯ã‚¿ãƒ–åˆ‡ã‚Šæ›¿ãˆå¼ã«ãªã£ã¦ãŠã‚Šã€SQLæ–‡ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ãªã©ã‚’è¤‡æ•°é–‹ã„ã¦
kitchy 2008/12/03
sql
ãƒªãƒ³ã‚¯
1