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

tune id:tune

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

${{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ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰åž‹å®‰å…¨ãªã‚³ãƒ¼ãƒ‰ã‚’ç”Ÿæˆã™ã‚‹sqlc | ãƒ•ãƒ¥ãƒ¼ãƒãƒ£ãƒ¼æŠ€è¡“ãƒ–ãƒã‚°
TIGã®è¾»ã§ã™ã€‚Goã®ORãƒžãƒƒãƒ‘ãƒ¼é€£è¼‰8æ—¥ç›®ã§ã™ã€‚æœ¬è¨˜äº‹ã§ã¯ sqlc ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚æ—©é€Ÿã§ã™ãŒã€çµè«–ã‹ã‚‰è¡Œãã¾ã—ã‚‡ã†ã€‚ sqlc ã¾ã¨ã‚ SQLãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹åž‹å®‰å…¨ãªGoã®ã‚³ãƒ¼ãƒ‰ã‚’ç”Ÿæˆã™ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒª æ§‹é€ ä½“ã®ãƒ¢ãƒ‡ãƒ«ã®æ‰‹æ›¸ãå®Ÿè£…ä¸è¦ è¤‡æ•°ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’JOINã—ãŸã¨ãã®ãƒžãƒƒãƒ‘ãƒ¼å®Ÿè£…ä¸è¦ ç”Ÿæˆã•ã‚Œã‚‹ã‚³ãƒ¼ãƒ‰ã¯ä¸è¦ãªãƒªãƒ•ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ãªã— SQLã‚’ãŒã‚“ãŒã‚“æ›¸ããŸã„ã€ã§ã‚‚é¢å€’ãªãƒžãƒƒãƒ‘ãƒ¼æ§‹é€ ä½“ã¯æ›¸ããŸããªã„ã€ã¨ã„ã†é–‹ç™ºè€…ã«ã¨ã£ã¦ã¯å¤§ããªå‘³æ–¹ã«ãªã‚Šã¾ã™ã€‚ sqlc ã®ç´¹ä»‹ sqlc ã¯SQLãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰Goã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚³ãƒ¼ãƒ‰ã‚’ç”Ÿæˆã™ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚2020/2ã« v1.0.0 ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã€ç€ã€…ã¨ã‚¹ã‚¿ãƒ¼ã‚’ä¼¸ã°ã—ã¦ã„ã¾ã™ã€‚2021/08ç¾åœ¨ã¯ v1.8.0 ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¦ã„ã¾ã™ã€‚æœ¬è³‡æ–™ã§ç”Ÿæˆã—ã¦ã„ã‚‹ã‚³ãƒ¼ãƒ‰ã‚‚ v1.8.0 ã‚’ç”¨ã„ã¦ã„ã¾ã™ã€‚ https://star-histor
tune 2021/11/12
ã©ã“ã‹ã§å®Ÿè·µæŠ•å…¥ã—ã¦ã¿ãŸã„ã€‚ORMã®æ°—æŒã¡ã«ãªã‚‹æ©Ÿä¼šãŒå¢—ãˆã¦ãã‚‹ã¨ã“ã£ã¡ã®ã‚¢ãƒ—ãƒãƒ¼ãƒãŒè‰¯ã„ã‚ˆãã¨ã„ã†æºã‚Šæˆ»ã—ãŒã‚ã£ã¦è‡ªç„¶ãªæ°—ãŒã™ã‚‹ã€‚

go

sql
ãƒªãƒ³ã‚¯
ãƒ¢ãƒ‡ãƒ«ä¸ã®SQLã‚’ç¶ºéº—ã«æ›¸ã
ãã£ã‹ã‘ ActiveRecord æœ€é«˜ã§ã™ã‚ˆãã€‚ã»ã¨ã‚“ã©ã®äº‹ãŒ SQL ã‚’è¨˜è¿°ã—ãªã„ã§å®Ÿç¾ã§ãã‚‹ã“ã¨ã¯ã‚‚ã¡ã‚ã‚“ã€ãƒ¡ã‚½ãƒƒãƒ‰ãƒã‚§ãƒ¼ãƒ³ã‚’ä½¿ã£ã¦ã‚„ã‚ŠãŸã„äº‹ã‚’éžå¸¸ã«ç°¡æ½”ã«è¨˜è¿°ã§ãã¾ã™ã€‚ ã¾ãŸã€å°‘ã—æ°—ã‚’ä»˜ã‘ã¦å®Ÿè£…ã™ã‚‹ã ã‘ã§ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡ŒãŒç™ºç”Ÿã™ã‚‹ã“ã¨ã‚‚å°‘ãªã„ã§ã™ã€‚ ã§ã™ãŒã€ã‚„ã¯ã‚Šä¾‹å¤–ã¯ã‚ã‚‹ã‚‚ã®ã§ã€ã©ã†ã—ã¦ã‚‚ SQL ã‚’è¨˜è¿°ã—ãªã„ã¨ã„ã‘ãªã„å ´é¢ã‚‚ã‚ã‚Šã¾ã™ã€‚ãã®æ™‚ã€ã©ã‚“ãªã«ç¶ºéº—ã« Ruby ã®ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã‚‚ã€å…¨ãåˆ¥ã®è¨€èªžã§ã‚ã‚‹ SQL ãŒã‚³ãƒ¼ãƒ‰ã«å…¥ã£ã¦ãã‚‹ã¨ã€å¯èªæ€§ãŒè½ã¡ã¾ã™ã€‚ ãã‚Œã‚’ä½•ã¨ã‹ã§ããªã„ã‹ã€ã¨è€ƒãˆã¾ã—ãŸã€‚ ãƒ’ã‚¢ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ ã¾ãšã€è€ƒãˆã‚‹ã®ãŒãƒ’ã‚¢ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’åˆ©ç”¨ã™ã‚‹æ–¹æ³•ã§ã™ã€‚ ï¼ˆSQL ã¯ã‚ãã¾ã§ä¾‹ã§ã™ã€‚ã“ã‚“ãªç”Ÿ SQL ã‚’æ›¸ã„ã¦ã¯ ActiveRecord ã«å¤±ç¤¼ã§ã™ãã€‚ï¼‰ class User < ActiveRecord::Base class << self def crea
tune 2015/12/06
sql

ActiveRecord

Ruby
ãƒªãƒ³ã‚¯
å·¨å¤§ãªãƒãƒƒãƒã‚’åˆ†å‰²ã—ã¦æ§‹æˆã™ã‚‹ ã€œSQLãƒãƒƒãƒãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯Bricolageã€œ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ãƒˆãƒ¬ãƒ³ãƒ‰èª¿æŸ»ãƒ©ãƒœã®é’æœ¨å³°éƒŽï¼ˆid:mineroaokiï¼‰ã§ã™ã€‚ å¥½ããªRubyã®ãƒ¡ã‚½ãƒƒãƒ‰ã¯10å¹´å‰ã‹ã‚‰String#slice(re, nth)ã§ã™ãŒã€ æœ€è¿‘ã¯Rubyã‚ˆã‚ŠCoffeeScriptã¨SQLã®ã»ã†ãŒæ›¸ãé‡ãŒå¤šãã¦æ‚©ã‚“ã§ã„ã¾ã™ã€‚ ä»Šæ—¥ã¯ã‚ãŸã—ãŒé–‹ç™ºã—ã¦ã„ã‚‹ã€ŒãŸã¹ã¿ã‚‹ã€ã®èƒŒå¾Œã§åƒã„ã¦ã„ã‚‹ å·¨å¤§ãƒãƒƒãƒã®æ§‹æˆã«ã¤ã„ã¦è©±ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãŸã¹ã¿ã‚‹ã®ãƒãƒƒãƒã¯ç´„3000è¡Œã®SQLã§æ§‹æˆã•ã‚Œã¦ãŠã‚Šã€ å‡¦ç†æ™‚é–“ãŒ1æ—¥ã§4æ™‚é–“ç¨‹åº¦ã‹ã‹ã‚‹ã€ãã“ãã“ã®è¦æ¨¡ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã™ã€‚ ã“ã®ãƒãƒƒãƒå‡¦ç†ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’Bricolageï¼ˆãƒ–ãƒªã‚³ãƒ©ãƒ¼ã‚¸ãƒ¥ï¼‰ã¨ã„ã†ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã§æ§‹é€ åŒ–ã™ã‚‹æ‰‹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã€ŒãŸã¹ã¿ã‚‹ã€ã¨ã¯ ã¾ãšæœ€åˆã«ã€ã€ŒãŸã¹ã¿ã‚‹ã€ãŒã©ã†ã„ã†ã‚‚ã®ãªã®ã‹ã”ãç°¡å˜ã«ãŠè©±ã—ã—ã¦ãŠãã¾ã—ã‚‡ã†ã€‚ ã€ŒãŸã¹ã¿ã‚‹ã€ã¯ä¼æ¥ã®ã¿ã«æä¾›ã—ã¦ã„ã‚‹B2Bã®åˆ†æžã‚µãƒ¼ãƒ“ã‚¹ã§ã€ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã®ãƒ¬ã‚·ãƒ”æ¤œç´¢ã®åˆ†æžã‚’ã™ã‚‹ã“ã¨ãŒã§ãã¾
tune 2015/08/16
sql

ruby

cookpad

ãƒãƒƒãƒ

åˆ†æž
ãƒªãƒ³ã‚¯
SQL style guide by Simon Holywell
Overview General Do Avoid Naming conventions General Tables Columns Aliasing or correlations Stored procedures Uniform suffixes Query syntax Reserved words White space Indentation Preferred formalisms Create syntax Choosing data types Specifying default values Constraints and keys Designs to avoid Appendix Reserved keyword reference Column data types SQL style guide Overview You can use this set o
tune 2015/07/25
sql

styleguide

DB
ãƒªãƒ³ã‚¯
xRef - Database
$ sqlplus $ sqlplus myuser@myhost $ sqlplus myuser/xxxxx@myhost $ sqlplus myuser/xxxxx@myhost/xe
tune 2015/01/02
mysql

database

sql

DB

postgresql

è³‡æ–™
ãƒªãƒ³ã‚¯
O/Rãƒžãƒƒãƒ‘ãƒ¼ã«ã‚ˆã‚‹ãƒˆãƒ©ãƒ–ãƒ«ã‚’æœªç„¶ã«é˜²ã
1. O/R Mapper ã«ã‚ˆã‚‹ ãƒˆãƒ©ãƒ–ãƒ«ã‚’æœªç„¶ã«é˜²ã Makoto Kuwata <[email protected]> http://www.kuwata-lab.com/ PostgreSQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ 2014 ver 1.1.0 2. copyright Â© 2014 kuwata-lab.com all rights reserved ã¾ãˆãŒã ç¾åœ¨ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã®ç¾å ´ã§ã¯ O/R Mapper (ORM) ãŒæ™®åŠã—ã¦ã„ã¾ã™ã€‚ä»Šå¾Œ ã‚‚ ORM ã‚’ä½¿ã£ãŸé–‹ç™ºã¯ã€å¢—ãˆã‚‹ã“ã¨ã¯ã‚ã£ã¦ã‚‚æ¸›ã‚‹ã“ã¨ã¯ãªã„ã§ã—ã‚‡ã†ã€‚ ã—ã‹ã— ORM ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºè€…ã«ã¨ã£ã¦ã¯ä¾¿åˆ©ã§ã‚‚ã€DB ç®¡ç†è€… (DBA) ã‹ ã‚‰ã¿ãŸã‚‰ãƒˆãƒ©ãƒ–ãƒ«ã®ç¨®ã§ã‚‚ã‚ã‚Šã¾ã™ã€‚ãã‚ŒãŒç‰¹ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹å•é¡Œã§ã‚ã‚‹ã“ ã¨ãŒå¤šã„ãŸã‚ã€é–‹ç™ºè€…ã¨ DBA ãŒå¯¾ç«‹ã™ã‚‹ã“ã¨ã‚‚çã—ãã‚ã‚Šã¾ã›ã‚“ã€‚ ã¨ã¯ã„ãˆã€ORM ã«ã‚ˆ
tune 2014/12/22
sql

DB

orm
ãƒªãƒ³ã‚¯
é–‹ç™ºè€…ã®ãŸã‚ã®SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å…¨ã¦
å‰æ›¸ã - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆã¯ãªãœé–‹ç™ºè€…ã®ã‚¿ã‚¹ã‚¯ãªã®ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã® å†…éƒ¨æ§‹é€ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ä½•ã«ä¼¼ã¦ã„ã‚‹ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ - äºŒé‡é€£çµãƒªã‚¹ãƒˆ æ¤œç´¢ ãƒ„ãƒªãƒ¼(Bãƒ„ãƒªãƒ¼) - ãƒãƒ©ãƒ³ã‚¹æœ¨ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆI - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é…ãã™ã‚‹2ã¤ã®åŽŸå› where å¥ - æ¤œç´¢ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ãŸã‚ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆ ç‰ä¾¡ æ¼”ç®—å - ä¸€è‡´ã™ã‚‹ã‚ãƒ¼ã®æ¤œç´¢ ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ã„æ–¹ã‚’ç¢ºèª è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - è¤‡æ•°åˆ—ã«å¯¾ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆII - å‰ã®å•é¡Œç‚¹ãŒå†ã³ é–¢æ•° - whereå¥ã® ä¸ã§ã®é–¢æ•° å¤§æ–‡å—ãƒ»å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ æ¤œç´¢ - UPPERã¨ LOWER ãƒ¦ãƒ¼ã‚¶å®šç¾© é–¢æ•° - é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åˆ¶é™ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚ŠéŽãŽ - å†—é•·æ€§ã®æŽ’é™¤æ³• ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿åŒ– ã‚¯ã‚¨ãƒª - ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ãŸã‚ã« ç¯„å›² æ¤œ
tune 2014/10/22
sql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

database
ãƒªãƒ³ã‚¯
Visual Representation of SQL Joins
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins. This is just a simple article visually explaining SQL JOINs. In this article I am going to discuss seven different ways you can return data from two relational tables. The seven Joins I will discuss are: Inner JOIN, Left JOIN, Right JOIN, Outer JOIN, Left Excluding JOIN, Right Exclud
tune 2014/08/01
sql

join
ãƒªãƒ³ã‚¯
ãƒ—ãƒãŒä½œã£ãŸé»’çŒ«å°ã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ é»’çŒ«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å·¥æˆ¿ (å¼•ã£è¶Šã—ã¾ã—ãŸ)
â– æœ€æ–°æƒ…å ± é»’çŒ«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å·¥æˆ¿ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã¯å¼•ã£è¶Šã—ã¾ã—ãŸã€‚ æ–°ã—ã„ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã¯ã“ã¡ã‚‰ â†’ http://kuronekosoft.ewinds.net/ 5ç§’å¾Œã«è‡ªå‹•çš„ã«ã‚¸ãƒ£ãƒ³ãƒ—ã—ã¾ã™ã€‚ é»’çŒ« SQLÂ Studio ã¯ã€ã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šå¯èƒ½ãªæ±Žç”¨SQLé–‹ç™ºç’°å¢ƒã§ã™ã€‚é»’çŒ« SQLÂ Studio ã«ã¯ã€SQLã‚’æ‰‹æ—©ãä½œã‚‹ãŸã‚ã®å…¥åŠ›æ”¯æ´æ©Ÿèƒ½ã‚„ã€ä½œã£ãŸSQLã‚’ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦ç®¡ç†ã™ã‚‹æ©Ÿèƒ½ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ â– é»’çŒ« SQL StudioÂ ã«ã¤ã„ã¦çŸ¥ã‚ŠãŸã„ â†’ é»’çŒ« SQL Studio â– é»’çŒ« SQL StudioÂ ã‚’ç´¹ä»‹ã—ã¦ã„ãŸã ãã¾ã—ãŸ â†’ SQLæ–‡ã‚’GUIã§ä½œæˆã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒ... - çª“ã®æœ â†’ ä½¿ã„ã‚„ã™ã„SQLå®Ÿè¡Œç’°å¢ƒ... - Unofficial DB2 BLOG â†’ ã©ã‚“ãªDBã‚‚GUIã§SQLä½œæˆ... - Hibiæ—¥è¨˜ â†’ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã®å¿…éœ€å“
tune 2007/07/05
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

sql
ãƒªãƒ³ã‚¯
SQL Formatter / SQLFormatter formats SQL Statements
ProductsMenÃ¼ umschalten Free Online SQL Formatter Notepad++ Plugin Windows App DBeaver SQL Formatter VS Code Plugin Azure Data Studio Plugin Visual Studio Plugin SSMS Plugin DownloadMenÃ¼ umschalten Notepad++ Plugin Windows App VSCode Plugin ADS Plugin Visual Studio Plugin SSMS Plugin LicenseMenÃ¼ umschalten Free License Single User License (includes everything) Notepad++ Plugin License VSCode Plugi
tune 2007/05/27
sql
ãƒªãƒ³ã‚¯
1