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

kiyo_hiko id:kiyo_hiko

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

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

ã‚‚ã†ä»Šã®10ä»£ã€20ä»£ã«ã¯10å¹´é–“ã®ä¼‘æš‡ã‚’å–ã£ã¦ã‚‚ã‚‰ã£ã¦ç”Ÿæ®–ã¨è‚²å…ã«å°‚å¿µã—ã¦ã‚‚ã‚‰ã†ã¹ãã§ã¯ãªã„ã‹ã€‚ä»£ã‚ã‚Šã«ç”Ÿæ®–èƒ½åŠ›ã‚’å¤±ã£ãŸãƒ¯ã‚¤ã‚‰æ°·æ²³æœŸç¤¾ç•œãŒéª¨ã«ãªã‚‹ã¾ã§åƒãã¨ã„ã†æ–¹å‘ã§æ‰‹ã‚’æ‰“ã¡ã¾ã›ã‚“ã‹ã€ç·ç†ã€‚
ãƒŸãƒƒã‚¯ @copinemickmack DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢æ”¹ã‚ä½•ã§ã‚‚èª¿æŸ»å›£ã€‚ note.com/mickmack è‘—æ›¸ï¼šã€Žã‚»ãƒ³ã‚¹ã®è‰¯ã„SQLã‚’æ›¸ãæŠ€è¡“ã€ã€ŽSQLå®Ÿè·µå…¥é–€ã€ã€ŽDBè¨è¨ˆå¾¹åº•æŒ‡å—æ›¸ã€ã€ŽSQLå¾¹åº•æŒ‡å—æ›¸ã€ã€‚ mickindex.sakura.ne.jp ãƒŸãƒƒã‚¯ @copinemickmack ã‚‚ã†ä»Šã®10ä»£ã€20ä»£ã«ã¯10å¹´é–“ã®ä¼‘æš‡ã‚’å–ã£ã¦ã‚‚ã‚‰ã£ã¦ç”Ÿæ®–ã¨è‚²å…ã«å°‚å¿µã—ã¦ã‚‚ã‚‰ã†ã¹ãã§ã¯ãªã„ã‹ã€‚ä»£ã‚ã‚Šã«ç”Ÿæ®–èƒ½åŠ›ã‚’å¤±ã£ãŸãƒ¯ã‚¤ã‚‰æ°·æ²³æœŸç¤¾ç•œãŒéª¨ã«ãªã‚‹ã¾ã§åƒãã¨ã„ã†æ–¹å‘ã§æ‰‹ã‚’æ‰“ã¡ã¾ã›ã‚“ã‹ã€ç·ç†ã€‚ 2025-06-13 16:13:37
kiyo_hiko 2025/06/15
"ä»£ã‚ã‚Šã«ç”Ÿæ®–èƒ½åŠ›ã‚’å¤±ã£ãŸãƒ¯ã‚¤ã‚‰æ°·æ²³æœŸç¤¾ç•œãŒéª¨ã«ãªã‚‹ã¾ã§åƒã" â†’çµ¶å¯¾åƒã‹ããƒ¼ã€‚åªã§ã•ãˆç”Ÿã¾ã‚Œæãªã®ã«æ›´ã«æ»ã¬ã¾ã§åŠ´åƒã¨ã‹å†—è«‡ã‚‚å¤§æ¦‚ã«ã€‚ãã‚‚ãã‚‚ä½•ã§åæ®–ã‚„ã—ãŸã„ã‹ã£ã¦å°†æ¥æˆ‘ã‚‰åŒæ§˜ã«ã“ãä½¿ã†ç‚ºã§ã—ã‚‡æœ€æ—©ç•œç”£

ç•œç”£

ç¹æ®–

SQL

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

dbms

sql

tutorial
ãƒªãƒ³ã‚¯
åˆ†æžSQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ« - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
SQLã€æ›¸ã„ã¦ã¾ã™ã‹ï¼Ÿ ã“ã¨å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®åˆ†é‡Žã«ãŠã„ã¦ã¯SQLã¯ã‚‚ã¯ã‚„æ¨™æº–ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã§ã‚ã‚Šã€ åˆ†æžã‚„ã‚‰ãƒãƒƒãƒã‚„ã‚‰ã«é–¢ã‚ã£ã¦ã„ã‚‹çš†æ§˜ã¯æ—¥ã€…å¤§é‡ã®SQLã‚¯ã‚¨ãƒªãƒ¼ã‚’ç”Ÿç”£ã—ã¦ã„ã‚‹ã“ã¨ã¨æ€ã„ã¾ã™ã€‚ ãã“ã§ã¡ã‚‡ã£ã¨æ°—ã«ãªã‚‹ã®ãŒã€ SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ«ã£ã¦ã©ã†ã™ã‚‹ã®ãŒä¸€èˆ¬çš„ãªã‚“ã ã£ã‘â€¦â€¦ï¼Ÿ ã¨ã„ã†ç‚¹ã§ã™ã€‚ ã‚¤ãƒžãƒ‰ã‚ã¯SQLãªã‚“ã¦O/R mapperã«åã‹ã›ã‚‹ã“ã¨ãŒå¤šã„ã‹ã‚‰ãªã®ã‹ã€ ãã‚Œã¨ã‚‚ã‚³ãƒ¼ãƒ‰ã‚’åºƒã„ç¯„å›²ã§å…±æœ‰ã™ã‚‹ã“ã¨ãŒãã‚‚ãã‚‚ãªã„ã‹ã‚‰ã‹ã€ SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ«ã«ã¤ã„ã¦è¦‹èžãã™ã‚‹ã“ã¨ã¯ä»–ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã«æ¯”ã¹ã‚‹ã¨ã ã„ã¶å°‘ãªãã€ ã„ã¾ã„ã¡æ±ºå®šç‰ˆã¨è¨€ãˆã‚‹ã‚¹ã‚¿ã‚¤ãƒ«ãŒãªã„ãªã¨æ„Ÿã˜ã¦ã„ã¾ã™ã€‚ ãã‚“ãªã‚ã‘ã§æœ¬æ—¥ã¯ã€SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ«ã«ã¤ã„ã¦ã®æ„è˜ã‚’æ´»ç™ºåŒ–ã•ã›ã‚‹ã¹ãã€ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã‚ãŸã—ï¼ˆé’æœ¨ï¼‰ãŒä½¿ã£ã¦ã„ã‚‹ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ«ã‹ã‚‰ç‰¹å¾´çš„ãªç‚¹ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç‰¹ã«ã€åˆ†æž
kiyo_hiko 2016/11/09
sql
ãƒªãƒ³ã‚¯
schema.rbã˜ã‚ƒãªãã¦structure.sqlã§ã‚¹ã‚ãƒ¼ãƒžæƒ…å ±ã‚’ç®¡ç†ã—ã‚ˆã† - tech-kazuhisa's blog
å…ˆæ—¥é–‹å‚¬ã•ã‚ŒãŸé–¢è¥¿Rubyä¼šè°05ã«å‚åŠ ã•ã‚ŒãŸæ–¹ãŠç–²ã‚Œæ§˜ã§ã—ãŸã€‚è‰²ã€…ãªæ–¹ã¨ãŠè©±å‡ºæ¥ã¦éžå¸¸ã«æ¥½ã—ã„1æ—¥ã§ã—ãŸã€‚ ã•ã¦ã€ã€ŒNo Sugar ã€œç§ã¯ã©ã®ã‚ˆã†ã«ã—ã¦Railsé–‹ç™ºã«è²¢çŒ®ã—ãŸã‹ã€œã€ã¨ã„ã†ç™ºè¡¨ã‚’ã•ã‚ŒãŸ @kennyj_jp ã•ã‚“ã‹ã‚‰æ‡‡è¦ªä¼šã§é¢ç™½ã„è©±ã‚’èžãã“ã¨ãŒã§ãã¾ã—ãŸã€‚ schema.rbã§ã‚¹ã‚ãƒ¼ãƒžæƒ…å ±ã‚’ç®¡ç†ã™ã‚‹ã®ã¯é™ç•ŒãŒã‚ã‚‹ã®ã§ã¯ãªã„ã‹ï¼Ÿ å…ˆæ—¥ç§ãŒãƒªãƒªãƒ¼ã‚¹ã—ãŸpg_index_where ã«ã¤ã„ã¦å¤±ç¤¼ãªãŒã‚‰æ„è¦‹ã‚’èžã„ã¦ã¿ã¾ã—ãŸã€‚ãƒã‚¤ãƒ³ãƒˆã¯ã‚¹ã‚ãƒ¼ãƒžæƒ…å ±ã‚’dumpã™ã‚‹å‡¦ç†ã«ã¤ã„ã¦ç¾åœ¨ã®å®Ÿè£…æ–¹æ³•ã§æ£ã—ã„ã®ã‹ã¨ã„ã†ç‚¹ã€‚ ãã‚‚ãã‚‚ãƒ¦ãƒ‹ãƒ¼ã‚¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«whereã‚’ä»˜ã‘ã‚‹ã‚ˆã†ãªRDBå›ºæœ‰ã®å‘½ä»¤ã«ã¤ã„ã¦ã¯ã€Railsæ¨™æº–ã®schema.rbã§ç®¡ç†ã—ç¶šã‘ã‚‹ã®ã¯é™ç•ŒãŒã‚ã‚‹ã®ã§ã¯ãªã„ã‹ã¨ã„ã†ãŠè©±ã§ã—ãŸã€‚ Railsã®è¨å®šã§dumpæ–¹æ³•ã‚’å¤‰æ›´ã§ãã‚‹ æ¬¡ã®ã‚ˆã†ã«application.rbã®ä¸€éƒ¨ã‚’ã‚³ãƒ¡ãƒ³ãƒˆ
kiyo_hiko 2016/05/16
schema

migration

sql

record

active
ãƒªãƒ³ã‚¯
SQLã®è¨˜è¿°æ–¹æ³•:SmoothCSVãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
kiyo_hiko 2016/03/28
H2Databaseæº–æ‹ ã¿ãŸã„ã€‚åˆ—åãŒãªã‘ã‚Œã°æ•°å—æ–‡å—åˆ—ã‚’ä½¿ã†ã€‚ä¾‹ãˆã° SELECT CONCAT(t."1", t."2") full_name FROM CSVTABLE('filename.csv') t;

smooth

csv

manual

sql
ãƒªãƒ³ã‚¯
ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã€Linuxç‰ˆã®SQL Serverã‚’2017å¹´ä¸ç›¤ã«ãƒªãƒªãƒ¼ã‚¹ã™ã‚‹ã¨å…¬å¼ç™ºè¡¨ã€‚ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ç‰ˆã®ç”³ã—è¾¼ã¿é–‹å§‹
ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã¯ã€åŒç¤¾ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ™‚æœŸãƒ¡ã‚¸ãƒ£ãƒ¼ã‚¢ãƒƒãƒ—ç‰ˆã¨ãªã‚‹SQL Server 2016ãŒLinuxã«å¯¾å¿œã™ã‚‹ã“ã¨ã‚’å…¬å¼ã«ç™ºè¡¨ã—ã¾ã—ãŸã€‚ åŒç¤¾ã®ã‚¨ã‚°ã‚¼ã‚¯ãƒ†ã‚£ãƒ–ãƒã‚¤ã‚¹ãƒ—ãƒ¬ã‚¸ãƒ‡ãƒ³ãƒˆScott Guthrieæ°ã¯ã€Official Microsoft Blogã®ã‚¨ãƒ³ãƒˆãƒªã€ŒAnnouncing SQL Server on Linux - The Official Microsoft Blogã€ã§æ¬¡ã®ã‚ˆã†ã«æ›¸ã„ã¦ã„ã¾ã™ã€‚ Today Iâ€™m excited to announce our plans to bring SQL Server to Linux as well. This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as we
kiyo_hiko 2016/03/08
sql

server

linux
ãƒªãƒ³ã‚¯
SQL è„³ã‹ã‚‰è¦‹ãŸ Ruby
Ð”Ð¾ÐºÑƒÐ¼ÐµÐ½Ñ‚ ÐºÐ°ÑÐ°ÐµÑ‚ÑÑ ÑÐ²ÑÐ·ÐµÐ¹ Ð¼ÐµÐ¶Ð´Ñƒ SQL Ð¸ Ruby, Ð¾Ð±ÑÑƒÐ¶Ð´Ð°Ñ Ð¸Ñ… Ð¿Ñ€Ð¸Ð¼ÐµÐ½ÐµÐ½Ð¸Ðµ Ð¸ Ð²Ð·Ð°Ð¸Ð¼Ð¾Ð´ÐµÐ¹ÑÑ‚Ð²Ð¸Ðµ Ð½Ð° ÐºÐ¾Ð½Ñ„ÐµÑ€ÐµÐ½Ñ†Ð¸Ð¸ Ð¾ Ruby Ð² ÐžÑÐ°Ñ†Ðµ. Ð’ Ñ‚ÐµÐºÑÑ‚Ðµ Ñ€Ð°ÑÑÐ¼Ð°Ñ‚Ñ€Ð¸Ð²Ð°ÑŽÑ‚ÑÑ Ð²Ð¾Ð¿Ñ€Ð¾ÑÑ‹, ÑÐ²ÑÐ·Ð°Ð½Ð½Ñ‹Ðµ Ñ ActiveRecord Ð¸ Ð¼Ð¾Ð´ÐµÐ»ÑÐ¼Ð¸ Ð¿Ð¾Ð»ÑŒÐ·Ð¾Ð²Ð°Ñ‚ÐµÐ»Ñ, Ð° Ñ‚Ð°ÐºÐ¶Ðµ Ð¾Ð±ÑƒÑ‡ÐµÐ½Ð¸Ðµ Ð½Ð°Ð¿Ð¸ÑÐ°Ð½Ð¸ÑŽ ÐºÐ¾Ð´Ð°. ÐžÑÐ½Ð¾Ð²Ð½Ð¾Ð¹ Ð°ÐºÑ†ÐµÐ½Ñ‚ ÑÐ´ÐµÐ»Ð°Ð½ Ð½Ð° Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑ‚Ð¸ Ð¸ÑÐ¿Ð¾Ð»ÑŒÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ SQL Ð² ÐºÐ¾Ð½Ñ‚ÐµÐºÑÑ‚Ðµ Ruby.
kiyo_hiko 2016/02/22
group_by

ruby

sql

tips
ãƒªãƒ³ã‚¯
ã‚·ãƒ¥ãƒ¼ãƒˆã‚™ã‚ãƒ¼ãƒ‹ãƒ¼ãƒˆãƒ•ãƒªãƒ¼ã‚¯
kiyo_hiko 2016/02/22
Auto Incrementã¯ä¸€ä»¶è¡ŒãƒŠãƒ³ãƒãƒ¼ã«è¦‹ãˆã‚‹ãŒã€ä¸¡è€…ã‚’æ··ãœã¦ã¯ã„ã‘ãªã„ã¨ã„ã†ã“ã¨

sql

anti

pattern

primary

key
ãƒªãƒ³ã‚¯
2ç« Naive Trees(ç´ æœ´ãªæœ¨) - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
kiyo_hiko 2016/02/22
é–‰åŒ…ãƒ†ãƒ¼ãƒ–ãƒ«ãŒä¸€ç•ªå®‰å…¨ãã†ãªå°è±¡

sql

pattern

nested

table

tree
ãƒªãƒ³ã‚¯
ITã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’èªã‚€ã¹ã—ï¼ è»½ã„ã¾ã¨ã‚
ã‚‚ã†ã“ã‚Œã ã‘ã§Bad smellã—ã‹ã—ã¾ã›ã‚“ãã€‚æ¤œç´¢ã¨ã‹è€ƒãˆã‚‹ã¨é ãŒç—›ã„ã§ã™ã€‚é‡è¤‡è€ƒæ…®ã—ãŸæ›´æ–°ã‚„å‰Šé™¤ã¨ã‹ã‚‚åŒã˜ããã¤ã„ã§ã™ãã€‚ å¾“å±žãƒ†ãƒ¼ãƒ–ãƒ«ä½œã£ã¦å¯¾å¿œã—ã¾ã—ã‚‡ã†ã€‚ 8. ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ãƒˆãƒªãƒ–ãƒ«ï¼ˆãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿å¤§å¢—æ®–ï¼‰ å…¨ãåŒã˜ãƒ†ãƒ¼ãƒ–ãƒ«ãªã®ã«å¹´ã‚„æœˆã§åˆ†ã‹ã‚Œã¦ã„ãŸã‚Šã€åŒã˜ã‚ˆã†ãªåˆ—ãŒé€£ç¶šã—ã¦ã„ã‚‹ã‚„ã¤ã§ã™ã€‚ CREATE TABLE LOG_2013 ( ... ); CREATE TABLE LOG_2014 ( ... ); CREATE TABLE LOG_2015 ( ... ); ãƒ‡ãƒ¼ã‚¿ãŒå¤šã™ãŽã‚‹ã‹ã‚‰åˆ†ã‘ãŸã€ã¨ã„ã†ã‚±ãƒ¼ã‚¹ãŒå¤šã„ã¨æ€ã„ã¾ã™ã€‚å¤ã„ãƒ‡ãƒ¼ã‚¿ã¯ä½¿ã‚ãªã„ã—ã€ã‹ã¨ã„ã£ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ï¼‘ã¤ã«ã™ã‚‹ã¨ã‚¯ã‚¨ãƒªãŒé…ããªã‚‹ã—ã€ã¿ãŸã„ãªã€‚ ä¸Šè¨˜ã®ã‚ˆã†ãªã‚±ãƒ¼ã‚¹ãªã‚‰OKã ã—ã€å®Ÿéš›ãã†ã„ã†çµŒé¨“ã¯ã‚ã‚Šã¾ã™ãŒã€‚LOG_2014ãƒ†ãƒ¼ãƒ–ãƒ«ã®2014/12/31ã®ãƒ‡ãƒ¼ã‚¿ãŒé–“é•ã£ã¦ãŸã®ã§ã€UPDATEã—ã¦2015å¹´ã®ãƒ‡ãƒ¼ã‚¿ã«ã—ã‚ˆã†
kiyo_hiko 2016/02/22
sql

anti

pattern

book

review

matome
ãƒªãƒ³ã‚¯
Using Sublime Text as your SQL Query Tool
Using Sublime Text's "build system" see how you can use your favorite text editor as the front end to a database for interactive querying.
kiyo_hiko 2016/02/03
sublime

sql
ãƒªãƒ³ã‚¯
é€†å¼•ãSQLæ§‹æ–‡é›† - æ–‡å—åˆ—ã®ä¸€éƒ¨ã‚’å–å¾—ã™ã‚‹(Mid, SUBSTR, SUBSTRING)
ã“ã“ã§ã¯å„DBMSã”ã¨ã«æ–‡å—åˆ—ã®ä¸€éƒ¨ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ï¼Ž Accessã®å ´åˆ Accessã¯Midé–¢æ•°ã‹MidBé–¢æ•°ã‚’ä½¿ç”¨ã—ã¾ã™ï¼Ž Mid(string, start[, length]) MidB(string, start[, length]) Midé–¢æ•°ã¯ string ã§ç¤ºã™æ–‡å—åˆ—ã® start ã‹ã‚‰ length æ–‡å—åˆ†æ–‡å—åˆ—ã‚’å–å¾—ã—ã¾ã™ï¼Ž MidBé–¢æ•°ã¯ string ã§ç¤ºã™æ–‡å—åˆ—ã® start ã‹ã‚‰ length ãƒã‚¤ãƒˆåˆ†æ–‡å—åˆ—ã‚’å–å¾—ã—ã¾ã™ï¼Ž ã“ã“ã§ start ã®å…ˆé ã®ä½ç½®ã¯1ã‹ã‚‰å§‹ã¾ã‚Šã¾ã™ï¼Žã¾ãŸï¼Œlength ã¯çœç•¥å¯èƒ½ã§ã™ï¼Žçœç•¥ã—ãŸå ´åˆã¯æ–‡å—åˆ—ã®æœ€å¾Œã¾ã§å–å¾—ã—ã¾ã™ï¼Ž SQLã‚µãƒ³ãƒ—ãƒ« Midé–¢æ•°ã‚’ä½¿ç”¨ã—ã¦æ–‡å—åˆ—ã®ä¸€éƒ¨ã‚’å–å¾—ã™ã‚‹ä¾‹ã‚’ä»¥ä¸‹ã«ç¤ºã—ã¾ã™ï¼Ž SELECT Mid('ãƒãƒ£ãƒ¼ãƒªãƒ¼ãƒ–ãƒ©ã‚¦ãƒ³', 1, 5); çµæžœ Expr1000 SQLServerã®å ´åˆ SQL
kiyo_hiko 2016/01/22
sql

string

sub
ãƒªãƒ³ã‚¯
UWP ã‚’ Continuum ã«å®Œå…¨å¯¾å¿œã•ã›ã‚‹ã«ã¯ï¼Ÿ - é«˜æ©‹ å¿ã®ãƒ–ãƒã‚° - MSDN Blogs
Ever found yourself staring at the Output Window, overwhelmed by endless lines of logs and cryptic messages?Â You're not alone! For years, developers have relied on the Output Window for critical build and debug information. But making sense of itâ€”and translating it into actionâ€”has...
kiyo_hiko 2016/01/20
sql

å®Ÿè¡Œè¨ˆç”»
ãƒªãƒ³ã‚¯
Free Database Administration & Development Tools
kiyo_hiko 2016/01/20
ã‚ˆã•ãã†

db

sql

viewer

console
ãƒªãƒ³ã‚¯
Run queries | RubyMine
To run SQL code, press Ctrl+Enter ","To cancel a running statement, press Ctrl+F2 "]}"> Enable the Database Tools and SQL pluginThis functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in RubyMine by default. If the relevant features are not available, make sure that you did not disable the plugin. Press Ctrl+Alt+S to open settings and then select Plugins. Open
kiyo_hiko 2016/01/15
ã‚ã¨DBå›ºæœ‰ã®æ‹¡å¼µã¯æŠ•ã’ã‚‰ã‚Œãªã„ã£ã½ã‹ã£ãŸã€‚

ruby

mine

eval

sql

console
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ - é–‹ç™ºè€…ã‚’å¾…ã¡å—ã‘ã‚‹25ã®è½ã¨ã—ç©´ (æ‹¡å¤§ç‰ˆ)
[db tech showcase Tokyo 2015] A14:Amazon Redshiftã®å…ƒã¨ãªã£ãŸã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆåž‹ã‚«ãƒ©ãƒ ãƒŠãƒ¼DBå¾¹åº•è§£èª¬ ãã®...
kiyo_hiko 2015/12/08
"ã¹ã‹ã‚‰ãšé›†ã§ã¯ãªããƒ‘ã‚¿ãƒ¼ãƒ³"

sql

anti

pattern
ãƒªãƒ³ã‚¯
ORæ¡ä»¶ã‚ˆã‚Šã‚‚UNIONã®æ–¹ãŒé€Ÿã„ï¼ - åœ°å¹³ç·šã«è¡Œã
ä¸€é€±é–“æ‚©ã‚“ã§ã€ã‚„ã£ã¨åˆ†ã‹ã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ ã“ã†ã„ã†SQLã®å ´åˆã€å‰è€…ã‚ˆã‚Šã‚‚å¾Œè€…ã®æ–¹ãŒé€Ÿã„ã§ã™ã€‚ SELECT * FROM FooTable LEFT OUTER JOIN BarTa ble1 ON FooTable.ID = BarTa ble1.ID LEFT OUTER JOIN BarTa ble2 ON BarTa ble1.F_ID = BarTa ble2.ID LEFT OUTER JOIN BarTa ble3 ON BarTa ble2.F_ID = BarTa ble3.ID LEFT OUTER JOIN BarTa ble4 ON BarTa ble3.F_ID = BarTa ble4.ID LEFT OUTER JOIN BarTa ble5 ON BarTa ble4.F_ID = BarTa ble5.ID WHERE FooTable.Name = ? OR BarTa ble5.N
kiyo_hiko 2015/12/07
å‚è€ƒã«ãªã£ãŸ

sql

perf

tips

or

index
ãƒªãƒ³ã‚¯
ã€ŒSQL Server 2008 BETWEENå¥ã®ä½¿ã„æ–¹ã«ã¤ã„ã€ï¼ˆ1ï¼‰ Database Expert ï¼ ï¼ IT
ï¼ IT ä¼šè°å®¤ Indexãƒªãƒ³ã‚¯ Windows Server Insider Insider.NET System Insider XML & SOA Linux Square Master of IP Network Java Solution Security & Trust Database Expert RFIDï¼‹IC ãƒªãƒƒãƒã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ & å¸³ç¥¨ Server ï¼† Storage Coding Edge ï¼ ITã‚¯ãƒ©ãƒ– Cafe VBæ¥å‹™ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºç ”ç©¶ ï¼ IT SpecialPR
kiyo_hiko 2015/12/07
BETWEENå¥ã®å·¦è¾ºã«å®šæ•°ã‚’ç½®ãã¨ã„ã†ã‚¹ã‚¿ã‚¤ãƒ«ã€€"ã“ã®è¦ä»¶ã§BETWEENã‚’ä½¿ã‚ãªã„ã®ã§ã‚ã‚Œã°ã€BETWEENã®ç«‹å ´ãŒãªã„ã¨æ€ã„ã¾ã™"

sql

between

where

query
ãƒªãƒ³ã‚¯
ruby rails activerecord nested select
I have three tables/models. Recordings (id) has_many :hits has_many :tags, :through => :hits Hits (id, recording_id, tag_id) belongs_to :recordings belongs_to :tags Tags (id) has_many :hits has_many :recordings, :through => :hits I need to find all recordings that have all the tags that are passed in as a parameter. For example, find all recordings that have tag.id == 5, tag.id == 6, and tag.id ==
kiyo_hiko 2015/12/07
"SELECT * FROM recordings WHERE id IN (SELECT recording_id FROM hits WHERE recording_id IN (SELECT recording_id FROM hits WHERE recording_id IN (SELECT recording_id from hits WHERE recording_id = 5)AND tag_id = '6') AND tag_id == '7')" â†’ "Recording.joins(:tags).where(:tags => { :id => [5,6,7] })"

active

record

sql

conversion

query

where
ãƒªãƒ³ã‚¯
Can two columns from one table have a foreign key to the same column in another table?
kiyo_hiko 2015/12/02
"It's not unique key, it's just an index."

my

sql

constraint

fk

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