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

kenjiro_n id:kenjiro_n

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

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

SQLite3ã§Upsertã‚’å®Ÿè¡Œã™ã‚‹
ä¼¼ãŸã‚ˆã†ãªå‡¦ç†ã«replaceãŒã‚ã‚‹ãŒã€ replaceã¯ãƒ¬ã‚³ãƒ¼ãƒ‰(è¡Œ)ã‚’ä¸¸ã”ã¨å…¥ã‚Œæ›¿ãˆã‚‹(delete/insert)ã®ã«å¯¾ã—ã€ upsertã¯ã‚«ãƒ©ãƒ ã‚’æŒ‡å®šã—ã¦ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ›´æ–°ã™ã‚‹ã€‚ SQLite3 ã§ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒã‚ã‚Œã°ç½®æ›ã€ãªã‘ã‚Œã°æ–°è¦æŒ¿å…¥ã™ã‚‹ (replace) å…¬å¼ ã«ã‚ˆã‚‹ã¨ PostgreSQL ã®æ§‹æ–‡ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã¨ã®ã“ã¨ã€‚ Microsoft SQLServer ã‚„ Oracle ã®ã€Œmerge(ãƒžãƒ¼ã‚¸)ã€æ§‹æ–‡ã«è¿‘ã„ä½¿ã„æ–¹ã ãŒ mergeã¯é‡è¤‡ã®åˆ¤å®šã«Uniqueã‚«ãƒ©ãƒ ä»¥å¤–ã®ã‚‚ã®ã‚’æŒ‡å®šã§ããŸã‚Šã™ã‚‹ã€‚ å®Ÿè¡Œä¾‹ ã€Œupsertã€ã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãŒã‚ã‚‹ã‚ã‘ã§ã¯ãªãã€ on conflictæ–‡ã‚’ä½¿ã„ ã‚ãƒ¼ãŒé‡è¤‡ã—ãŸå ´åˆã®å‡¦ç†ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ on conflictæ–‡ã¯ sqlite ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³3.24.0 ã‹ã‚‰åˆ©ç”¨å¯èƒ½ã€‚ ç’°å¢ƒ Windows 10 sqlite3 (3.24.0
kenjiro_n 2024/02/02
sqlite

SQL
ãƒªãƒ³ã‚¯
ç¬¬158å›žã€€Invisible Columnsã®ä½¿ã„ã©ã“ã‚ | gihyo.jp
MySQL 8.0.23ã§ã¯ã€æ–°ãŸãªæ©Ÿèƒ½ã¨ã—ã¦Invisible ColumnsãŒå°Žå…¥ã•ã‚Œã¾ã—ãŸã€‚ã“ã®æ©Ÿèƒ½ã¯ã€ã‚ã‚‹ã‚«ãƒ©ãƒ ã‚’ã€Œå˜åœ¨ã¯ã—ã¦ã„ã‚‹ã‘ã‚Œã©ã‚‚æ˜Žç¤ºçš„ã«æŒ‡å®šã—ãªã„å ´åˆã¯å‚ç…§ã—ãªã„ã‚«ãƒ©ãƒ ã¨ã—ã¦æ‰±ã†ã€ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ä»Šå›žã¯ã“ã®Invisible Columnsã®æ©Ÿèƒ½ã«ã¤ã„ã¦è¦‹ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ ãªãŠã€ä¼¼ãŸæ©Ÿèƒ½ã§ã‚ã‚‹ã€invisible indexesã«ã¤ã„ã¦ã¯ç¬¬110å›žã€€Invisible Indexesã‚’ä½¿ã£ã¦æ°—è»½ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’å§‹ã‚ã¦ã¿ã‚‹ã§ç´¹ä»‹ã—ã¦ãŠã‚Šã¾ã™ã®ã§ãã¡ã‚‰ã‚’ã”å‚ç…§ãã ã•ã„ã€‚ã¾ãŸã€ä»Šå›žåˆ©ç”¨ã—ã¦ã„ã‚‹MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯8.0.26ã¨ãªã‚Šã¾ã™ã€‚ Invisible columnsã®ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆ Invisibleãªã‚«ãƒ©ãƒ ã®ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ã«ã¯ã€Invisibleã«ã—ãŸã„ã‚«ãƒ©ãƒ ã«INVISIBLEã‚’ã¤ã‘ã¦CREATE TABLEæ–‡ã§å®Ÿè¡Œã™ã‚‹ã‹ã€ALTER
kenjiro_n 2023/01/26
SELECT * FROM HOGE; ã§ã¯å–å¾—ã§ããªã„åˆ—ã‚’è¨å®šã§ãã‚‹ã¨ã„ã†è©±ã€‚ç½ ã£ã½ã„ã€‚

MySQL

SQL
ãƒªãƒ³ã‚¯
SQLã‚’é€Ÿãã™ã‚‹ãžâ€•ãŠæ‰‹è»½ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ã“ã®ã‚µã‚¤ãƒˆã§ã¯ã€SQL ã‚’é«˜é€ŸåŒ–ã™ã‚‹ãŸã‚ã®ã¡ã‚‡ã£ã¨ã—ãŸãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®æŠ€è¡“ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ã¨è¨€ã£ã¦ã‚‚ã€ã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQLã€€ç¬¬2ç‰ˆã€ã®å—ã‘å£²ã‚ŠãŒã»ã¨ã‚“ã©ãªã®ã§ã€ã“ã®æœ¬ã‚’èªã‚“ã§ã„ãŸã ã‘ã‚Œã°ã€æœ¬ç¨¿ã‚’èªã‚€å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ æœ€åˆã«ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹å…¨ä½“ã®æ–¹é‡ã‚’è¿°ã¹ã¦ãŠãã¨ã€ãã‚Œã¯ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ï¼ˆä¸€ç•ªé…ã„ã¨ã“ã‚ï¼‰ã‚’æ”¹å–„ã™ã‚‹ã“ã¨ã§ã™ã€‚å½“ãŸã‚Šå‰ã§ã™ãŒã€æ—¢ã«ååˆ†é€Ÿã„å‡¦ç†ã‚’ã‚‚ã£ã¨é€Ÿãã—ãŸã¨ã“ã‚ã§ã€ã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¯å½±éŸ¿ã—ã¾ã›ã‚“ã€‚å¾“ã£ã¦ã€Œå‡¦ç†ãŒé…ã„ã€ã¨æ„Ÿã˜ãŸã‚‰ã€æœ€åˆã«ã™ã‚‹ã“ã¨ã¯ã€SQL ã‚„ã‚¢ãƒ—ãƒªã®æ”¹ä¿®ã§ã¯ãªãã€ã€Œã©ã“ãŒé…ã„ã®ã‹ã€ã‚’èª¿æŸ»ã™ã‚‹ã“ã¨ã§ã™ã€‚ã„ããªã‚Šã‚ã¦ãšã£ã½ã†ã§æ”¹å–„ã‚’ã¯ã˜ã‚ã¦ã‚‚åŠ¹æžœã¯å‡ºã¾ã›ã‚“ã€‚åŒ»è€…ãŒæ‚£è€…ã‚’è¨ºã‚‹ã¨ãæœ€åˆã«ã™ã‚‹ã“ã¨ãŒæ¤œæŸ»ã§ã‚ã‚‹ã®ã¨åŒã˜ã§ã™ã€‚ç—…å› ãŒä½•ã§ã‚ã‚‹ã‹ã‚’çªãæ¢ã‚ã¦ã‹ã‚‰ã§ãªã„ã¨ã€æ£ã—ã„å‡¦æ–¹ã¯ã§ããªã„ã®ã§ã™ã€‚ ãã®åŸºæœ¬ã‚’æ‰¿çŸ¥ã—ã¦ã„ãŸã ã„ãŸ
kenjiro_n 2023/01/13
SQL

database

development
ãƒªãƒ³ã‚¯
SQLiteã§æ§‹é€ ä½“ãƒªã‚¹ãƒˆã‚’ãã®ã¾ã¾insertã—ãŸã„
ä¸€æ‹¬æŒ¿å…¥ã«ã‚ˆã‚‹ã¨ SQLite ã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’ä¸€æ‹¬æŒ¿å…¥ã™ã‚‹ãŸã‚ã®ç‰¹åˆ¥ãªæ–¹æ³•ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ãƒ‡ãƒ¼ã‚¿ã®æŒ¿å…¥ã¾ãŸã¯æ›´æ–°æ™‚ã«æœ€é©ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å¾—ã‚‹ã«ã¯ã€ä»¥ä¸‹ã‚’è¡Œã£ã¦ãã ã•ã„ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ä½¿ç”¨ã€‚ åŒã˜ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼åŒ–ã‚³ãƒžãƒ³ãƒ‰ã®å†åˆ©ç”¨ã€‚ å¾Œç¶šã®å®Ÿè¡Œã§ã€æœ€åˆã®å®Ÿè¡Œã®ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã‚’å†åˆ©ç”¨ã—ã¾ã™ã€‚ ã¨æ¡ˆå†…ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãƒžã‚·ãƒ³ç’°å¢ƒãŒç•°ãªã‚‹ã®ã§æ‰€è¦æ™‚é–“ãŒç•°ãªã‚Šã¾ã™ãŒã€ takemori_kondoã•ã‚“ã®ã‚³ãƒ¼ãƒ‰ï¼š 402ms ä¸€æ‹¬æŒ¿å…¥ï¼š 230ms ä¸€æ‹¬æŒ¿å…¥ã‹ã‚‰tranã‚’ã‚³ãƒ¡ãƒ³ãƒˆã‚¢ã‚¦ãƒˆï¼š 243,755ms ã¨æ„šç›´ã«ãƒ«ãƒ¼ãƒ—ã—ã¦ã‚‚ã‹ãªã‚Šé«˜é€Ÿã«ãªã‚Šã¾ã™ã€‚ #if false foreach (var group in list.Select((hv, i) => (hv, i)).GroupBy(x => x.i / 1000)) { using var cmd = conn.CreateCommand()
kenjiro_n 2023/01/13
SQLite

C#

SQL
ãƒªãƒ³ã‚¯
Sqlime - Online SQLite playground
Sqlime is an online SQLite playground for debugging and sharing SQL snippets.
kenjiro_n 2022/12/21
SQLite

SQL
ãƒªãƒ³ã‚¯
JSON ã‚„ CSV ã§ SELECT * FROM ã—ãŸã„ã¨ãã¯ columnq-cli ãŒä¾¿åˆ©
techfeed çµŒç”±ã§ä¸‹è¨˜ã®ã‚¹ãƒ¬ãƒƒãƒ‰ã‚’è¦‹ã‹ã‘ãŸã®ã§ã™ãŒã€ã‚¿ã‚¤ãƒˆãƒ«ã ã‘ã§ã‚‚æ—¢ã«é¢ç™½ãã†ã§ã™ã€‚ ã¾ãŸã€ã¡ã‚‡ã£ã¨å‰ã‹ã‚‰ Notion ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å„ç¨®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¸å¤‰æ›ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’ä½œã£ã¦ã„ã¾ã—ã¦ã€ã“ã‚Œã‚’çµ„ã¿åˆã‚ã›ã‚‹ã¨ã„ã‚ã„ã‚æ¥½ã§ããã†ãªäºˆæ„ŸãŒã—ã¾ã™ã€‚ ãã®ã‚ˆã†ãªã‚ã‘ã§ã€ã‚¹ãƒ¬ãƒƒãƒ‰ã§ç´¹ä»‹ã•ã‚Œã¦ã„ãŸ columnq-cli ã«ã¤ã„ã¦ã®è¨˜äº‹ã§ã™ã€‚ columnq-cli ã¨ã¯ï¼Ÿ README ã‚’èªã‚€ã¨ã€Œå„ç¨®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã—ã¦ SELECT ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ CLI ãƒ„ãƒ¼ãƒ«ã€ã§ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚½ãƒ¼ã‚¹ã«ã¯ JSON ãªã©ã®ä»–ã« ROAPI ã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã‚‚ã®ã‚’æ‰±ãˆã‚‹ã¨ã®ã“ã¨ã€‚ (SELECT ã®ã¿ã§æ›´æ–°ã¯ã§ããªã„) ã“ã“ã§ ROAPI ã¨ã¯ãªã‚“ãžã‚„ã¨ãªã‚Šã¾ã™ãŒã€ã“ã¡ã‚‰ã¯ã€Œãƒãƒ¼ã‚«ãƒ«ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã‚„å„ç¨®ã‚µãƒ¼ãƒ“ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’çµ±åˆçš„ã«æ‰±ãˆã‚‹(SELECT ã§ãã‚‹)ã‚µãƒ¼ãƒãƒ¼ã€ã‚’æ§‹ç¯‰ã§ãã‚‹ãã†ã§ã™ã€‚ å›³ 1-
kenjiro_n 2022/10/03
ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ãªã—ã ã£ãŸã‚‰é¢ç™½ãã†ã€‚ãã†ã§ãªã‘ã‚Œã°SQLiteã«é£Ÿã‚ã›ã‚‹ã®ãŒé€Ÿãã†ã ã—ã€‚

SQL

CLI
ãƒªãƒ³ã‚¯
AccessãŒSQLã®æ‹¬å¼§ã‚’å‹æ‰‹ã«æ¶ˆã™ - OKWAVE
Access2010 ã§ã‚¯ã‚¨ãƒªã‚’SQLãƒ“ãƒ¥ãƒ¼ã§è¨˜è¿°ã—ã€ä¿å˜ã—ã¦é–‰ã˜ã‚‹ã¨ æ¬¡ã«SQLãƒ“ãƒ¥ãƒ¼ã‚’é–‹ã„ãŸã¨ãã«SQLãŒå¤‰ã‚ã£ã¦ã¾ã™ã€‚ æ”¹è¡ŒãŒæ¶ˆã•ã‚Œã¦ãŸã‚Šã€()æ‹¬å¼§ãŒæ¶ˆã•ã‚Œã¦ãŸã‚Šã€‚ æ”¹è¡Œã¯ã¾ã ã„ã„ã‚“ã§ã™ã€‚èªã¿é›£ã•ã‚’æˆ‘æ…¢ã™ã‚‹ã ã‘ãªã®ã§ã€‚ ã§ã‚‚()æ‹¬å¼§ã‚’æ¶ˆã—ãŸçµæžœã€SQLæ–‡æ³•ã‚¨ãƒ©ãƒ¼ã«ãªã‚‹ã“ã¨ãŒã‚ã‚Šã€ ï¼ˆãã‚Œã‚‚ä»–ã®DBã§ã¯æ£å¸¸ã«åˆ¤å®šã•ã‚Œã‚‹ã‚ˆã†ãªã€Accessç‹¬è‡ªã®æ§‹æ–‡è§£é‡ˆã‚¨ãƒ©ãƒ¼ï¼‰ ãã†ãªã‚‹ã¨SQLãƒ“ãƒ¥ãƒ¼ã§é–‹ã‘ãšä¿®æ£ã§ããšã€æ³£ãæ³£ãã‚¯ã‚¨ãƒªã‚’ä½œã‚Šç›´ã™ãƒãƒ¡ã«ãªã‚Šã¾ã™ã€‚ ()æ‹¬å¼§ã‚’å‹æ‰‹ã«æ¶ˆã—ã¦ãŠã„ã¦ã€æ–‡æ³•ã‚¨ãƒ©ãƒ¼ã ã‹ã‚‰ä½œã‚Šç›´ã› ãªã‚“ã¦ã€ Accessã¯é æ‚ªã„ã¨ã—ã‹æ€ãˆã¾ã›ã‚“ã€‚ã€‚ã€‚ å‹æ‰‹ã«å¤‰æ›´ã•ã‚Œãªã„ã‚ˆã†ã«ã§ãã¾ã›ã‚“ã‹ãï¼Ÿ
kenjiro_n 2022/08/18
ä»Šå›žæ•…ã‚ã£ã¦UNION ALLã®å¤šæ®µé‡ããŒã‚ã‚‹SQLã‚’æ›¸ãã€å†åº¦é–‹ã„ãŸã¨ãã«æ”¹è¡ŒãŒãªããªã‚Šé›£å„€ã—ã¦ã„ãŸãŒã€Œã‚ªãƒ—ã‚·ãƒ§ãƒ³ã®ã€Œåå‰ã®è‡ªå‹•ä¿®æ£ã€ã®ã¨ã“ã‚ã‚’ã™ã¹ã¦ã‚ªãƒ•ã«ã™ã‚‹ã€‚ã€ã¨ã„ã†è¨å®šã§äº‹ãªãã‚’å¾—ãŸã€‚

MSOffice

SQL

badknowhow
ãƒªãƒ³ã‚¯
ERå›³ã®è‡ªå‹•ç”Ÿæˆã«ã¤ã„ã¦ã€dbdiagram.io, DBeaver, A5M2 ã‚’æ¯”è¼ƒã—ã¦ã¿ã‚‹ã€‚ - Qiita
ã¯ã˜ã‚ã« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®ERå›³ã«ã¤ã„ã¦ã€è‡ªå‹•ã§ç”Ÿæˆã™ã‚‹ä»¥ä¸‹ï¼“ã¤ã®ãƒ„ãƒ¼ãƒ«ã‚’æ¯”è¼ƒã—ãŸè¨˜äº‹ã§ã™ã€‚ dbdiagram.io DBeaver A5:SQLÂ Mk-2ï¼ˆA5M2ï¼‰ å…ˆæ—¥ã€ã“ã¡ã‚‰ã®è¨˜äº‹ã‚’Qiitaã«æŠ•ç¨¿ã—ãŸã¨ã“ã‚ã€å¤šãã®æ–¹ã«è¨˜äº‹ã‚’è¦‹ã¦ã„ãŸã ãã€ã‚³ãƒ¡ãƒ³ãƒˆã‚‚å¤šæ•°ã„ãŸã ãã¾ã—ãŸã€‚ ERå›³ã«é–¢ã™ã‚‹ãŠå‹§ã‚ã®ãƒ„ãƒ¼ãƒ«ã‚’ã‚³ãƒ¡ãƒ³ãƒˆã„ãŸã ãæ–¹ãŒå¤šãã„ã‚‰ã£ã—ã‚ƒã„ã¾ã—ãŸã€‚ ä»Šå›žã¯ãã®ä¸ã‹ã‚‰ã€ç„¡æ–™ã§ã‚‚åˆ©ç”¨ã§ãã‚‹3ã¤ã®ãƒ„ãƒ¼ãƒ«ã®ã€ŒERå›³ã®è‡ªå‹•ç”Ÿæˆã€ã®æ©Ÿèƒ½ã‚’è©¦ã—ã¾ã™ã€‚ æ¯”è¼ƒã®çµè«–ã¨ã—ã¦ã¯ã€ã€‡ã€‡ãŒä¸€ç•ªè‰¯ã„ã¨ã„ã†æ„Ÿæƒ³ã§ã¯ãªãã€ã©ã®ãƒ„ãƒ¼ãƒ«ã‚‚å¤šæ©Ÿèƒ½ã§ã€ã§ãã‚‹ã“ã¨ã¯é•ã†ã®ã§ã€ä»Šå¾Œä½¿ã†ã¨ãã¯ç”¨é€”ã‚„æ¥å‹™ã®ç’°å¢ƒã«ã‚ˆã£ã¦ä½¿ã„åˆ†ã‘ã¦ã„ã‘ãŸã‚‰ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ç›®æ¬¡ ãã‚Œãžã‚Œã®ãƒ„ãƒ¼ãƒ«ã«ã¤ã„ã¦ã€ä¸‹è¨˜ã®å†…å®¹ã‚’æ›¸ã„ã¦ã„ãã¾ã™ã€‚ 1. dbdiagram.io 1-1. å§‹ã‚ã‚‹ 1-2. ä½¿ã† 1-3. æ„Ÿæƒ³ 2. DBeaver 2-1. å§‹
kenjiro_n 2022/08/16
Macã§Winç”¨ã‚½ãƒ•ãƒˆã®A5M2ãŒä½¿ãˆã‚‹ã®ã‹ã¨é©šã„ãŸã‘ã©ã€ã•ã™ãŒã«åˆ¥è¨˜äº‹ãŒã‚ã‚‰ã‹ã˜ã‚ã‚ã‚‹ç¨‹åº¦ã«ã¯æ‰‹é–“ã®ã‹ã‹ã‚‹è©±ã®ã‚ˆã†ã§ã€‚/ã£ã¦å˜ã«WINEã‚’å…¥ã‚Œã‚‹ã ã‘ã®è©±ã‹ãƒ¼ã„ã€‚

SQL

database

software
ãƒªãƒ³ã‚¯
ã€è§£èª¬ã€‘ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹100æœ¬ãƒŽãƒƒã‚¯ã®å§‹ã‚æ–¹
æœ¬è¨˜äº‹ã¯ã€M1 Macbookã‚’ç”¨ã„ãŸæ‰‹é †ã«ãªã‚Šã¾ã™ã€‚ Windowsã®PCã®æ–¹ã¯ã€é©å®œèªã¿æ›¿ãˆã¦å®Ÿæ–½ã—ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ãªãŠã€æœ¬ãƒ–ãƒã‚°ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹100æœ¬ãƒŽãƒƒã‚¯ã®å…¨è§£ç”è§£èª¬ã‚’æŽ²è¼‰ã—ã¦ã„ã¾ã™ã€‚ ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ãªã©ã—ã¦ç”ãˆåˆã‚ã›ã«å½¹ç«‹ã¦ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹100æœ¬ãƒŽãƒƒã‚¯ã®å›žç”é›† | ã‚¿ã‚°: datascience - omathin blog Dockerã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¾ãšã¯Dockerã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã—ã‚‡ã†ã€‚ ä»¥ä¸‹ã®è¨˜äº‹ã«ã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã‚‹æ–¹æ³•ã§å°Žå…¥å¯èƒ½ã§ã™ã€‚ https://qiita.com/ao41/it ems/5feb96cd01c312407a2b æœ¬è¨˜äº‹ã«ãŠã‘ã‚‹Dockerã¨Docker Composeã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã§ã™ã€‚ terminal$ docker --version Docker version 20.10.1,
kenjiro_n 2022/08/09
docker

study

python

R

SQL
ãƒªãƒ³ã‚¯
ã€Œãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹100æœ¬ãƒŽãƒƒã‚¯ã€ã®ç”Ÿã¿ã®è¦ªã¯ãªãœã€Œ3è¨€èªžã®ã‚µãƒãƒ¼ãƒˆã€ã¨ã€ŒDockerã€ã«ã“ã ã‚ã£ãŸã®ã‹
2020å¹´6æœˆ15æ—¥ã€ä¸€èˆ¬ç¤¾å›£æ³•äººãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆå”ä¼šï¼ˆä»¥ä¸‹ã€ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆå”ä¼šï¼‰ã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹åˆå¦è€…ãŒæ§‹é€ åŒ–ãƒ‡ãƒ¼ã‚¿ã®é›†è¨ˆãƒ»åŠ å·¥ã‚’åŠ¹çŽ‡çš„ã«å¦ã¹ã‚‹æ¼”ç¿’ç’°å¢ƒã€Œãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹100æœ¬ãƒŽãƒƒã‚¯ï¼ˆæ§‹é€ åŒ–ãƒ‡ãƒ¼ã‚¿åŠ å·¥ç·¨ï¼‰ã€ã‚’ã€ã€ŒGitHubã€ã§ç„¡å„Ÿå…¬é–‹ã—ãŸã€‚å…¬é–‹ç›´å¾Œã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹ã«é–¢ã‚ã‚‹æŠ€è¡“è€…ã®é–“ã§å¤§ããªè©±é¡Œã‚’é›†ã‚ã€ãã®å†…å®¹ã‚„åˆ©ç”¨æ³•ã‚’ç´¹ä»‹ã™ã‚‹ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ãŒãƒãƒƒãƒˆä¸Šã§æ•°å¤šãå…¬é–‹ã•ã‚ŒãŸã€‚ ã“ã®ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹100æœ¬ãƒŽãƒƒã‚¯ã®ã€Œç”Ÿã¿ã®è¦ªã€ã¨ã‚‚ã„ãˆã‚‹ã®ãŒã€ãƒ‡ãƒ¼ã‚¿è§£æžè¨è¨ˆäº‹å‹™æ‰€ã®æ£®è°·å’Œå¼˜æ°ã ã€‚åŒæ°ã¯ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆã¨ã—ã¦æ´»å‹•ã™ã‚‹å‚ã‚‰ã€ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ãƒ©ãƒœã®å–ç· å½¹CTOï¼ˆæœ€é«˜æŠ€è¡“è²¬ä»»è€…ï¼‰ã¨ã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆäººæã‚’ä¸€ã‹ã‚‰è‚²æˆã—ã¦ä¼æ¥ã«æ´¾é£ã™ã‚‹äº‹æ¥ã«æºã‚ã£ã¦ã„ã‚‹ã€‚ æœ¬ç¨¿ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹100æœ¬ãƒŽãƒƒã‚¯ã®ã“ã ã‚ã£ãŸãƒã‚¤ãƒ³ãƒˆã‚„æ´»ç”¨ã™ã‚‹ãŸã‚ã®ã‚³ãƒ„ã€ä»Šå¾Œã®å±•æœ›ã«ã¤ã„
kenjiro_n 2022/08/09
docker

study

python

R

SQL
ãƒªãƒ³ã‚¯
ç¤¾å†…SQLç ”ä¿®ã®ãŸã‚ã«ä½œã£ãŸè³‡æ–™ã‚’å…¬é–‹ã—ã¾ã™ | æ ªå¼ä¼šç¤¾AI Shift
ã“ã‚“ã«ã¡ã¯ã€Development Teamã®ä¸‰å®…ã§ã™ã€‚ å…ˆæ—¥ã€ç¤¾å†…ï¼ˆAIäº‹æ¥æœ¬éƒ¨å†…ï¼‰ã§SQLç ”ä¿®ã®è¬›å¸«ã‚’æ‹…å½“ã—ãŸã®ã§ã€ä»Šå›žã¯ãã®å†…å®¹ã«ã¤ã„ã¦ç°¡å˜ã«å…±æœ‰ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« ä¾‹å¹´ã€AIäº‹æ¥æœ¬éƒ¨ã§ã¯ã€æ–°å’ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®è‚²æˆã®ãŸã‚ã«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ç ”ä¿®ã‚’è¡Œã£ã¦ãŠã‚Šã¾ã™ã€‚ä»Šå¹´ã¯ãƒ•ãƒ«ãƒªãƒ¢ãƒ¼ãƒˆã§ã®å®Ÿæ–½ã¨ãªã‚Šã¾ã—ãŸã€‚ç ”ä¿®æœŸé–“ã¯2é€±é–“ã»ã©ã§ã€å†…å®¹ã¯å‰åŠãŒè¬›ç¾©ã€å¾ŒåŠãŒå®Ÿè·µï¼ˆãƒãƒ¼ãƒ é–‹ç™ºï¼‰ã§ã—ãŸã€‚ç§ãŒæ‹…å½“ã—ãŸã®ã¯ã€è¬›ç¾©ãƒ‘ãƒ¼ãƒˆã®ä¸€éƒ¨ã§ã‚ã‚‹SQLç ”ä¿®ã§ã™ã€‚SQLã‚„RDBã«ã‚ã¾ã‚Šæ…£ã‚Œã¦ã„ãªã„äººã§ã‚‚ã€ã§ãã‚‹ã ã‘ä½“ç³»çš„ãªå¦ã³ãŒå¾—ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã™ã‚‹ã“ã¨ã‚’ç›®æ¨™ã«ã€æ§˜ã€…ãªè³‡æ–™ã‚’ã¾ã¨ã‚ã¦æä¾›ã™ã‚‹æ–¹é‡ã§æº–å‚™ã—ã¾ã—ãŸã€‚çµæžœçš„ã«ã¯ã€ãƒãƒ³ã‚ºã‚ªãƒ³è¾¼ã¿ã§4æ™‚é–“ã»ã©ã®ã‚„ã‚„é•·ã„è¬›ç¾©ã¨ãªã‚Šã¾ã—ãŸãŒã€å‹‰å¼·ã«ãªã£ãŸã¨ã„ã†å£°ã‚‚é ‚ã‘ãŸã®ã§ã‚„ã£ã¦è‰¯ã‹ã£ãŸã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ç ”ä¿®è³‡æ–™ ç ”ä¿®å†…å®¹ SQLç ”ä¿®ã®å†…å®¹ã¯ã€åŸºæœ¬çš„ã«ã¯å¤§å¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¬›ç¾©ã§
kenjiro_n 2021/06/23
database

SQL

study
ãƒªãƒ³ã‚¯
ER Master
<body> <span>ã“ã®ãƒšãƒ¼ã‚¸ã¯ãƒ•ãƒ¬ãƒ¼ãƒ å¯¾å¿œã®ãƒ–ãƒ©ã‚¦ã‚¶ã§ã”è¦§ãã ã•ã„ã€‚</span> </body>
kenjiro_n 2021/03/03
database

SQL

ecliplse
ãƒªãƒ³ã‚¯
Excelã®å®šç¾©æ›¸ã‹ã‚‰VBAã§SQLã‚’ä½œæˆã™ã‚‹
CREATEæ–‡ã‚’ä½œæˆã™ã‚‹ãƒžã‚¯ãƒ ã¨ã‚Šã‚ãˆãšã€æœ€ã‚‚ä½¿ã„ãã†ãªCREATEæ–‡(DDL)ã‚’ä½œæˆã™ã‚‹VBAãƒžã‚¯ãƒã‚’ä½œã£ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã‚½ãƒ¼ã‚¹ã¯ä»¥ä¸‹ã«ãªã‚Šã¾ã™ã€‚ '=====å®šæ•°å®šç¾©===== 'ãƒ†ãƒ¼ãƒ–ãƒ«ç‰©ç†åã®ã‚»ãƒ«ç•ªå· Private Const COL_TABLE_NAME As Integer = 4 Private Const ROW_TABLE_NAME As Long = 1 'ãƒ†ãƒ¼ãƒ–ãƒ«è«–ç†åã®ã‚»ãƒ«ç•ªå· Private Const COL_TABLE_COMMENT As Integer = 4 Private Const ROW_TABLE_COMMENT As Long = 2 'é …ç›®é–‹å§‹è¡Œ Private Const ROW_COLUMNS_START As Long = 5 'é …ç›®ã®åˆ—å®šç¾© Enum enm_columns NO = 2 'No COLUMN_NAME '
kenjiro_n 2021/03/03
SQL

VBA

MSOffice
ãƒªãƒ³ã‚¯
Excelã‹ã‚‰Createæ–‡ã‚’ | SQLServerå¤§å¥½ã
Excelã«è¨˜å…¥ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‹ã‚‰ã€Createæ–‡ã‚’ãƒžã‚¯ãƒã§ä½œæˆã—ã¾ã™ã€‚ Createæ–‡ä½œæˆãƒžã‚¯ãƒå…¥ã‚ŠExcelï¼šcreate_table_macro.xls ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸Excelï¼štable_doc_sample.xlt ï½žä½¿ã„æ–¹ï½ž 1.C:\workãƒ•ã‚©ãƒ«ãƒ€ã‚’ä½œæˆã—ã¾ã™ã€‚ 2.ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸EXCELãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ã„ã¦ã€ä½œæˆã—ãŸã„ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚·ãƒ¼ãƒˆã‚’é¸æŠžã—ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã®ã‚µãƒ³ãƒ—ãƒ«ï¼štable_doc_sample.xlt 3.ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆãƒžã‚¯ãƒå…¥ã‚ŠEXCELã®ãƒžã‚¯ãƒã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ 4.C:\work\create.txtãŒå‡ºæ¥ä¸ŠãŒã‚Šã¾ã™ã€‚ ä½œæˆã•ã‚ŒãŸcreateæ–‡ã‚’ä½¿ã£ã¦ã€DBã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ 0 people found this article useful This article was helpful This article was helpful 0 p
kenjiro_n 2021/03/03
MSOffice

VBA

SQL

automation
ãƒªãƒ³ã‚¯
Oracle ã§ DDL ã‚’å–å¾—ã™ã‚‹ - ãµãªWiki
DDLã®å–å¾— DBMS_METADATA.GET_DDL GET_DDLã‚’ä½¿ã†ã¨DDLã‚’å–å¾—ã§ãã‚‹ã€‚ DDLã®å‡ºåŠ›å½¢å¼ã‚’å¤‰æ›´ã™ã‚‹ https://siguniang.wordpress.com/2013/09/04/oracle-dbms_metadata-get_ddl-fetch-ddl-for-tables/ https://www.toadworld.com/platforms/oracle/b/weblog/archive/2015/11/25/get-ddl-and-set-transf orm-param-in-dbms-metadata https://stackoverflow.com/questions/6782278/generating-ddl-script-for-object-without-schema-name-baked-in-using-dbms-meta
kenjiro_n 2021/02/16
Oracle

SQL

backup
ãƒªãƒ³ã‚¯
ã€Oracleã€‘ç›´è¿‘5åˆ†ä»¥å†…ã«å®Ÿè¡Œã—ãŸSQLã®å±¥æ´ã¨ãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ã‚’ç¢ºèªã™ã‚‹ - å°ã•ã„é ƒã¯ã‚¨ãƒ©å‘¼å¸
ã¯ã˜ã‚ã« ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ç™ºè¡Œã—ãŸSQLãŒã†ã¾ãå‹•ä½œã—ãªã„å ´åˆã€ç™ºè¡Œã—ãŸSQLãŒåˆ†ã‹ã‚Œã°èª¿æŸ»ã®æ‰‹ãŒã‹ã‚Šã¨ãªã‚Šã¾ã™ã€‚Oracleã®v$sqlã‚’å‚ç…§ã™ã‚‹ã¨ã€å®Ÿè¡Œã—ãŸSQLã®å±¥æ´ã¨ãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ã‚’ç¢ºèªã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã–ã£ãã‚Šè¨€ã†ã¨ SQLã®å®Ÿè¡Œå±¥æ´ã¯v$sqlãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¦‹ã‚‹ã¨åˆ†ã‹ã‚‹ã€‚ è¡ŒãŒå¤šã™ãŽã‚‹ãŸã‚ã€SQLã®æ–ç‰‡ã‚’æ¤œç´¢æ¡ä»¶ã«å«ã‚ã‚‹ã¨è‰¯ã„ã€‚ ãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ã®ç¢ºèªã¯v$sql_bind_captureã‚’è¦‹ã‚‹ã¨åˆ†ã‹ã‚‹ã€‚ æ–°ãƒ»é–€å¤–ä¸å‡ºã®Oracleç¾å ´ãƒ¯ã‚¶ ã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆãŒæ˜Žã‹ã™é‹ç”¨ãƒ»ç®¡ç†ã®æ¥µæ„ (DB Selection)posted with amazlet at 15.06.06å°ç”° åœäºŒ å¤§å¡š ä¿¡ç”· äº”ååµ å»ºå¹³ è°· æ•¦é›„ å®®å´Ž åšä¹‹ ç¥žç”° é”æˆ æ‘æ–¹ ä» ç¿”æ³³ç¤¾ å£²ã‚Šä¸Šã’ãƒ©ãƒ³ã‚ãƒ³ã‚°: 76,494 Amazon.co.jpã§è©³ç´°ã‚’è¦‹ã‚‹ ç›´è¿‘5åˆ†é–“ã«å®Ÿè¡Œã•ã‚ŒãŸSQLã‚’å‚ç…§ã™ã‚‹ ä»¥ä¸‹ã®ã‚¯ã‚¨ãƒª
kenjiro_n 2020/12/24
Oracle

SQL

knowhow
ãƒªãƒ³ã‚¯
Oracleã®CLOBãƒ‡ãƒ¼ã‚¿ã‚’æ–‡å—åˆ—(VARCHAR2)ã§å–å¾—ãƒ»è¡¨ç¤ºã™ã‚‹
dbms_lob.substr(CLOBåž‹ã®ã‚«ãƒ©ãƒ å,1000,1) AS column1 ã§ã€column1ã«å®Ÿéš›ã®æ–‡å—åˆ—ãƒ‡ãƒ¼ã‚¿ãŒå…¥ã‚Šã¾ã™ãŒã€column1ã¯VARCHA2åž‹ã«æš—é»™ã§å¤‰æ›ã•ã‚Œã‚‹ã®ã§ã€æœ€å¤§å€¤ã¯4000ãƒã‚¤ãƒˆã¨ã„ã†ã“ã¨ã«ãªã‚‹ã‚“ã§ã™ã‚ˆãã€‚ã€‚ã€‚ SQLã‚’æŠ•ã’ãŸã¨ãã«ä¸‹è¨˜ã®ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ã—ã¾ã†å ´åˆã¯ã€ãƒã‚¤ãƒˆæ•°ãŒVARCHAR2ã«å…¥ã‚‹æœ€å¤§å€¤ã‚’è¶…ãˆã¦ã„ãªã„ã‹ç¢ºèªã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ORA-06502: PL/SQL: æ•°å€¤ã¾ãŸã¯å€¤ã®ã‚¨ãƒ©ãƒ¼: æ–‡å—åˆ—ãƒãƒƒãƒ•ã‚¡ãŒå°ã•ã™ãŽã¾ã™ã€‚ãŒç™ºç”Ÿã—ã¾ã—ãŸã€‚ ORA-06512 â€œPL/SQL: numeric or value error%sâ€
kenjiro_n 2020/11/17
Oracle

SQL

knowhow

badknowhow
ãƒªãƒ³ã‚¯
SQLè¨˜è¿°è€…å…¨å“¡ãŒç†è§£ã™ã¹ãSELECTæ–‡ã®è«–ç†çš„ãªå‡¦ç†é †åºã®ãŠè©± - Qiita
2020/9/30è¿½è¨˜ æœ¬è¨˜äº‹ã¯å…ƒã€…ã€ã€ŒSQLè¨˜è¿°è€…å…¨å“¡ãŒç†è§£ã™ã¹ãSELECTæ–‡ã®å®Ÿè¡Œé †åºã®ãŠè©±ã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§æŠ•ç¨¿ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ ã—ã‹ã—ã€çŸ¥è¦‹ã®ã‚ã‚‹æ–¹ã‹ã‚‰ã®ã‚³ãƒ¡ãƒ³ãƒˆã¨è‡ªåˆ†ã§ã‚‚èª¿ã¹ã¦ã¿ãŸçµæžœã€ä»Šå›žç´¹ä»‹ã—ã¦ã„ã‚‹é †åºã¯ã‚ãã¾ã§è«–ç†çš„ãªå‡¦ç†é †åºã§ã‚ã‚Šã€å®Ÿè¡Œé †åºã¨ã¯åˆ¥ç‰©ã¨ã„ã†ã“ã¨ãŒã‚ã‹ã‚Šã¾ã—ãŸã€‚ èª¤ã£ãŸçŸ¥è˜ã‚’å¸ƒæ•™ã—ã¦ã—ã¾ã„ç”³ã—è¨³ã”ã–ã„ã¾ã›ã‚“ã€‚ 2020/9/30ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ã€æœ¬è¨˜äº‹ã®ã‚¿ã‚¤ãƒˆãƒ«ã‚’ã€ŒSQLè¨˜è¿°è€…å…¨å“¡ãŒç†è§£ã™ã¹ãSELECTæ–‡ã®è«–ç†çš„ãªå‡¦ç†é †åºã®ãŠè©±ã€ã«å¤‰æ›´ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ã¯ã˜ã‚ã« ã€ŒSQLã¨ã„ãˆã°ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒæ‰±ã†ã‚¹ã‚ãƒ«ã€ã¨æ€ã‚ã‚ŒãŒã¡ã§ã™ãŒã€æœ€è¿‘ã¯ãƒžãƒ¼ã‚±ã‚¿ãƒ¼ã‚„å–¶æ¥ãªã©ã€éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã‚‚SQLã‚’ä½¿ã£ã¦ã€è‡ªã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã—åˆ†æžã™ã‚‹æ–¹ãŒå¢—ãˆã¦ãã¦ã„ã¾ã™ã€‚ ã¾ãŸã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã§ã‚‚ã€ORMä»»ã›ã§ãªã‚“ã¨ãªãç†è§£ã—ã¦ã„ã‚‹çŠ¶æ…‹ã®æ–¹ã‚‚ã„ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ ä»Šå›žã¯ã€ãã‚“ãªæ–¹ã€…ã«ã“ã
kenjiro_n 2020/09/23
SQL

knowhow

database
ãƒªãƒ³ã‚¯
ã™ã¹ã¦ã®ã‚¨ãƒ‡ã‚£ã‚¿ã§SQLã®è‡ªå‹•è£œå®Œã‚’ã™ã‚‹ãŸã‚ã«SQL Language Server(sqls)ã‚’ä½œã£ãŸ - Qiita
sqlsã¨ã¯ sqlsã¨ã¯ã€ã„ã¾ç§ãŒé–‹ç™ºä¸ã®SQLç”¨Language Serverã§ã™ã€‚SQLã‚’ã‚¨ãƒ‡ã‚£ã‚¿ã§ç·¨é›†ã™ã‚‹ã¨ãã®æ”¯æ´æ©Ÿèƒ½ã‚’å®Ÿè£…ã—ãŸã‚µãƒ¼ãƒã¨ãªã£ã¦ãŠã‚Šã€ä¸»ãªç‰¹å¾´ã¯ä»¥ä¸‹ã§ã™ã€‚ Language Serverãªã®ã§LSã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒå˜åœ¨ã™ã‚‹ã‚¨ãƒ‡ã‚£ã‚¿ã§ã‚ã‚Œã°ã©ã‚“ãªã‚¨ãƒ‡ã‚£ã‚¿ã§ã‚‚åˆ©ç”¨å¯èƒ½ SQLç·¨é›†æ”¯æ´æ©Ÿèƒ½ è‡ªå‹•è£œå®Œ(ãƒ†ãƒ¼ãƒ–ãƒ«åã€ã‚«ãƒ©ãƒ åãªã©) å®šç¾©å‚ç…§ SQLå®Ÿè¡Œ è¤‡æ•°ã®RDSMSã«å¯¾å¿œ MySQL PostgreSQL SQLite3 Language Serverã¨ã¯ Language Server(ã‚ã‚‹ã„ã¯Language Server Protocol)ã¨ã¯ã€ãƒ—ãƒã‚°ãƒ©ãƒ è¨€èªžã®é–‹ç™ºæ”¯æ´æ©Ÿèƒ½ã‚’ã‚¨ãƒ‡ã‚£ã‚¿ã«æä¾›ã™ã‚‹ã‚µãƒ¼ãƒã€ãŠã‚ˆã³ãã®é€šä¿¡å†…å®¹ã‚’è¦å®šã—ãŸãƒ—ãƒãƒˆã‚³ãƒ«ã§ã™ã€‚ãŸã ã—ã‚µãƒ¼ãƒã¨ã„ã£ã¦ã‚‚ã»ã¨ã‚“ã©ã®å ´åˆãƒãƒ¼ã‚«ãƒ«å†…ã«ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã—ã¦ãƒãƒ¼ã‚«ãƒ«ã®ã‚¨ãƒ‡ã‚£ã‚¿ã¨é€šä¿¡ã‚’ã—ã¾ã™ã€‚ ã“ã“ã§ã¯ä¸»é¡Œã§ã¯ãªã„ã®ã§è©³ã—
kenjiro_n 2020/05/17
SQL

server

vim

database
ãƒªãƒ³ã‚¯
LINQ to SQLã§è¤‡åˆã‚ãƒ¼ã®Existså¥ã‚’æ›¸ã - modest violet
å˜ä¸€ã®Existså¥ã‚’è¡¨ã™å ´åˆã¯Containsã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã—ãŸãŒã€è¤‡æ•°ã®ã‚ãƒ¼ã§Existsã‚’å®Ÿç¾ã•ã›ãã°ãªã‚‰ãªã„çŠ¶æ³ã«é™¥ã£ãŸã®ã§ã€å‹‰å¼·ãŒã¦ã‚‰ã«ã¾ã¨ã‚ã¾ã—ãŸã€‚ å˜ä¸€ã‚ãƒ¼ã®Existsã®å ´åˆ åŸºã¨ãªã‚‹SQL SELECT * FROM table_A as A WHERE EXISTS ( SELECT * FROM table_B As B WHERE A.Key1 = B.Key1 ) ãƒ¡ã‚½ãƒƒãƒ‰å¼ï¼ˆC#ï¼‰ table_A .Select(s => s) .Where(t1 => table_B.Select(t2 = > t2.Key1) .Contains(t1.Key1) ãƒã‚¤ãƒ³ãƒˆã¯ã€table_Bã§ä¸€è‡´ã•ã›ãŸã„é …ç›®ã‚’Selectã§çµžã‚Šè¾¼ã‚“ã çµæžœã«å¯¾ã—ã¦ã€Containsã‚’è¡Œã†ç‚¹ã§ã™ã€‚ INå¥ã«è¿‘ã„ã‚¤ãƒ¡ãƒ¼ã‚¸ã§ã™ãŒã€ç”Ÿæˆã•ã‚Œã‚‹SQLã¯EXISTSã«ãªã‚Šã¾ã™ã€‚ è¤‡åˆã‚ãƒ¼ã®Existsã®
kenjiro_n 2020/02/21
C#

Entity

SQL
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸