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

brendon id:brendon

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

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

trdsqlã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã‚’ä½œã£ãŸ - Qiita
trdsqlã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã‚’ä½œã‚Šã¾ã—ãŸã€‚ Goã§ä½œã£ã¦ã¾ã™ã€‚ githubã® trdsqlã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å‡ºæ¥ã¾ã™ã€‚ ã¾ãŸLinux/Windows/macOSã®ãƒã‚¤ãƒŠãƒªã‚‚ã‚ã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã¯ã€å¤ããªã£ã¦ã„ã‚‹å†…å®¹ã‚‚ã„ãã¤ã‹ã‚ã‚Šã¾ã™ã€‚ æœ€æ–°ç‰ˆã«å¯¾å¿œã—ãŸã€ã‚ˆã‚Šè©³ç´°ãªå†…å®¹ã¯ trdsql ç›®æ¬¡ | Noboru Saito's page ã‚’å‚ç…§ã—ã¦ä¸‹ã•ã„ã€‚ ã“ã‚Œã¯ä½•ï¼Ÿ ç°¡å˜ã«è¨€ãˆã°CSV(TSVå«ã‚€)ã‚„LTSVã«å¯¾ã—ã¦SQLã‚’å®Ÿè¡Œã§ãã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ åŒæ§˜ã®ãƒ„ãƒ¼ãƒ«ãŒ q ã‚„ textql ç‰ã„ãã¤ã‹ã‚ã‚Šã¾ã™ã€‚ trdsqlã¯PostgreSQLãƒ‰ãƒ©ã‚¤ãƒã¨MySQLãƒ‰ãƒ©ã‚¤ãƒã‚’å«ã‚“ã§ã„ã¦å®Ÿéš›ã«DBã«æŽ¥ç¶šã™ã‚‹ã“ã¨ã§SQLiteä»¥ä¸Šã®æ©Ÿèƒ½ã‚’ä½¿ç”¨ã§ãã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ PostgreSQLã‚„MySQLã®æ§‹æ–‡ãŒä½¿ãˆã‚‹ã ã‘ã§ã¯ãªãã€CSVãƒ•ã‚¡ã‚¤ãƒ«ã¨å®Ÿãƒ†ãƒ¼ãƒ–ãƒ«ã§JOINã—ãŸã‚Šã€CSVãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ãƒ†ãƒ¼ãƒ–
brendon 2017/12/17
sql
ãƒªãƒ³ã‚¯
SQLiteã‹ã‚‰CSVãƒ•ã‚¡ã‚¤ãƒ«ã«SQLã‚’æŠ•ã’ã¦ã¿ãŸ | DevelopersIO
SQLite3.14(å††å‘¨çŽ‡Ï€ã¨åŒã˜ã§ã™ã!)ãŒ2016/08/08ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ ãƒªãƒªãƒ¼ã‚¹ãƒŽãƒ¼ãƒˆã«ã‚ˆã‚‹ã¨ã€CSVä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾å¿œã—ãŸã¨ã‚ã‚Šã¾ã—ãŸã®ã§ã€æ—©é€Ÿä½¿ã£ã¦ã¿ã¾ã—ãŸã€‚ Added the CSV virtual table for reading RFC 4180 formatted comma-separated value files. ã“ã®æ©Ÿèƒ½ã‚’ä½¿ã†ã¨ã€CSVå½¢å¼ã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«SQLã§å•ã„åˆã‚ã›ã‚‹ã¨ã„ã£ãŸã“ã¨ãŒç°¡å˜ã«ã§ãã¾ã™ã€‚ ä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ã„ã¦ ä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«(Virtual Table)ã¯SQLiteã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ç®¡ç†ã•ã‚Œã¦ã„ãªã„ãƒ‡ãƒ¼ã‚¿ã‚’ä»®æƒ³çš„ã«ç®¡ç†ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã«è¦‹ã›ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã™ã€‚ ä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã§ç®¡ç†ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã¯ã€é€šå¸¸ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã¨åŒã˜ã‚ˆã†ã« SQL ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã§æ“ä½œã§ãã¾ã™ã€‚ SQLite ã§ã¯ å…¨æ–‡æ¤œç´¢ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ R-Trees
brendon 2016/10/05
sql
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ å¹»ã®ç¬¬26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ 26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€ 2015/08/31 @ GMO Yours #ronsakucasual https://atnd.org/events/68902Read less
brendon 2015/09/09
sql

database
ãƒªãƒ³ã‚¯
æ–°è‘—ãŒå‡ºã¾ã™ï¼šã€ŽSQLå®Ÿè·µå…¥é–€ã€ - ãƒŸãƒƒã‚¯ã®ãƒ–ãƒã‚°
4æœˆä¸æ—¬ã“ã‚ã«ãªã‚Šã¾ã™ãŒã€æ–°è‘—ãŒå‡ºã¾ã™ã€‚SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ä¸»é¡Œã«ã—ãŸæœ¬ã§ã€å®Ÿè¡Œè¨ˆç”»ã‚’èªã‚€ã“ã¨ã§ã€ãªãœã“ã®SQLã¯é…ã„ã®ã‹ã€ã‚ã‚‹ã„ã¯é€Ÿã„ã®ã‹ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã¾ã§æŠŠæ¡ã—ã¦ç†è§£ã—ã‚ˆã†ã€ã¨ã„ã†è¶£æ—¨ã§ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†ã®ã¯ã€SQLã¨ã„ã†è‡ªç„¶è¨€èªžã‚’æ¨¡ã—ãŸã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«ã‚ˆã£ã¦ã€ä½Žæ¬¡ã®ãƒ¬ã‚¤ãƒ¤ãƒ¼ã‚’éš è”½ã™ã‚‹æ„å›³ã§ä½œã‚‰ã‚ŒãŸãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ãªã®ã§ã€æœ¬å½“ã¯å®Ÿè¡Œè¨ˆç”»ãªã©ã¨ã„ã†æ‰‹ç¶šãƒ¬ãƒ™ãƒ«ã®ä¸–ç•Œã‚’ãƒ¦ãƒ¼ã‚¶ãŒè¦—ãè¦‹ã‚‹ã®ã¯ã€æœ¬æœ«è»¢å€’ãªã¨ã“ã‚ã‚‚ã‚ã‚Šã¾ã™ã€‚ãŸã ãã†ã¯ã„ã£ã¦ã‚‚ã€ç¾å®Ÿã«SQLãŒé…ã‹ã£ãŸã‚‰åŽŸå› ã‚’è§£æžã›ã–ã‚‹ã‚’ãˆãªã„ã‚ã‘ã ã—ã€å¤§ä½“æœ¬å½“ã«ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã«ã—ãŸã„ãªã‚‰ã€ãªã‚“ã§ã©ã®DBMSã‚‚å®Ÿè¡Œè¨ˆç”»ã‚’è¦‹ã‚‰ã‚Œã‚‹æ‰‹æ®µãªã‚“ã‹ç”¨æ„ã—ã¦ã‚‹ã‚“ã§ã—ã‚‡ã†ãä¸æ€è°ã§ã™ãã€ã¨ã„ã†ç†æƒ³ã¨ç¾å®Ÿã®ç‹é–“ã§æ‚©ã‚€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã€…ã«å°‘ã—ã§ã‚‚ãƒ™ã‚¿ãƒ¼ãªè§£ã«è¾¿ã‚Šã¤ã‘ã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’æç¤ºã§ãã‚Œã°ã€ã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã¾ãˆãŒãã¨ç« ç«‹ã¦ã§ã™ã€‚
brendon 2015/03/30
database

sql

book
ãƒªãƒ³ã‚¯
SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ£ã—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã‚‹ã®ã¯ èª°ã®å½¹å‰²ï¼Ÿ
SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã¯ã€SQLãã®ã‚‚ã®ã¨åŒã˜ãã‚‰ã„ã®æ´å²ãŒã‚ã‚‹â€•â€• ã‚ã‚‹äººã¯ã€SQLã¯ãã‚‚ãã‚‚é…ã„ã‚‚ã®ã ã¨ã™ã‚‰è¨€ã†ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã€SQLã®æ´å²ãŒå§‹ã¾ã£ãŸé ƒã¯æ£ã—ã‹ã£ãŸã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ä»Šã¨ãªã£ã¦ã¯å…¨ã å½“ã¦ã¯ã¾ã‚‰ãªã„ã§ã—ã‚‡ã†ã€‚ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã¯ä»Šã‚‚ä¸€èˆ¬çš„ã§ã‚ˆãã‚ã‚‹ã“ã¨ã§ã™ã€‚ã©ã†ã—ã¦ãã†ãªã£ã¦ã—ã¾ã†ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ SQLè¨€èªžã¯ã€æã‚‰ãæœ€ã‚‚æˆåŠŸã—ãŸç¬¬4ä¸–ä»£è¨€èªž(4GL)ã§ã—ã‚‡ã†ã€‚ãã®æœ€å¤§ã®åˆ©ç‚¹ã¯ã€ã€Œä½•ã‚’ã€ã¨ã€Œã©ã®ã‚ˆã†ã«ã€ ã‚’åˆ†é›¢ã§ãã‚‹ã“ã¨ã§ã™ã€‚SQLæ–‡ã¯ã€ã©ã®ã‚ˆã†ã«ãã‚Œã‚’å®Ÿè¡Œã™ã‚‹ã‹ã‚’è¨˜è¿°ã›ãšã«ã€å˜ç´”ã« ä½•ã‚’å¿…è¦ã¨ã—ã¦ã„ã‚‹ã‹ã®ã¿ã®è¨˜è¿°ã«ãªã£ã¦ã„ã¾ã™ã€‚ä»¥ä¸‹ã®ã‚ˆã†ãªä¾‹ã‚’è€ƒãˆã¦ã¿ã¾ã—ã‚‡ã†ã€‚ SELECT date_of_birth FROM employees WHERE last_name = 'WINAND'SQLã®ã‚¯ã‚¨ãƒªã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’è¦æ±‚ã™ã‚‹è‹±èªžã®æ–‡ã¨ã—ã¦èª
brendon 2014/10/18
sql

programming
ãƒªãƒ³ã‚¯
Whereç‹™ã„ã®ã‚ãƒ¼ã€order byç‹™ã„ã®ã‚ãƒ¼
11. I'm yoku0825 â— ã¨ã‚ã‚‹ä¼æ¥ã®DBA â— ã‚ªãƒ©ã‚¯ã‚Œãªã„ â— ãƒã‚¹ã‚°ã‚Œãªã„ â— ãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ã‚‹ â— å®¶ã«å¸°ã‚‹ã¨ â— å«ã®å¤« â— ã›ãŒã‚Œã®çˆ¶ â— é¦¬é¹¿ã ã‹ã‚‰ã‹ã‚ã„ã„ã‚ã‘ã˜ã‚ƒãªãã¦ã€ã‹ã‚ã„ã„ ã‚¤ãƒ«ã‚«ãŒãŸã¾ãŸã¾ãƒã‚«ã ã£ãŸ 12. ã¯ã˜ã‚ã« â— ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ã¯ MySQLã®ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ ãƒ™ãƒ¼ã‚¹(worldãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹)ã‹ã‚‰ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ ã‚¹ã‚’å…¨ã¦å–ã£æ‰•ã£ãŸã‚‚ã®ã§ã™ â— http://dev.mysql.com/doc/index-other.html â— ã‚³ãƒ¼ãƒ‰ã¯githubã«ä¸Šã’ã¦ã‚ã‚Šã¾ã™ â— https://github.com/yoku0825/yapc_2014 â— ã™ã”ãâ€¦ã‚¦ãƒ³ã‚³ãƒ¼ãƒ‰ã§ã™â€¦ 13. ã¯ã˜ã‚ã« â— åŽŸå‰‡ã€MySQLã¯1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ãåŒæ™‚ã«1 ã¤ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã—ã‹ä½¿ã„ã¾ã›ã‚“ â— Index mergeã¨ã‹ã‚ã‚‹ã‘ã©ã‚¢ãƒ¬ã¯ä¾‹å¤–ã ã—ç‹™ã£ã¦ ã‚„ã£ã¦ã‚‚é€Ÿããªã‚‹
brendon 2014/08/30
sql
ãƒªãƒ³ã‚¯
SQLZoo
Tutorials: Learn SQL step by step 0 SELECT basics Some simple queries to get you started 1 SELECT name Some pattern matching queries 2 SELECT from World In which we query the World country profile table. 3 SELECT from Nobel Additional practice of the basic features using a table of Nobel Prize winners. 4 SELECT within SELECT In which we form queries using other queries. 5 SUM and COUNT In which we
brendon 2014/02/26
database

sql
ãƒªãƒ³ã‚¯
æ„å¤–ã¨ä¾¿åˆ©ï¼ŸPHPè£½ã®HTMLç”¨å•ã„åˆã‚ã›è¨€èªžÂ·htmlSQL MOONGIFT
html SQLã¯HTMLæ§‹é€ ã«SQLã‚’ä½¿ã£ã¦æ¤œç´¢ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚ HTMLã‚’æ“ä½œã™ã‚‹éš›ã«ã¯DOMã‚’ä½¿ã£ãŸã‚Šã€æ£è¦è¡¨ç¾ã‚’ä½¿ã†ã®ãŒä¸€èˆ¬çš„ã§ã™ã€‚ã—ã‹ã—ã‚‚ã†ä¸€ã¤ã®ã‚„ã‚Šæ–¹ã‚’ææ¡ˆã™ã‚‹ã®ãŒhtml SQLã§ã™ã€‚ä½•ã¨SQLï¼ˆå•ã„åˆã‚ã›è¨€èªžï¼‰ã‚’ä½¿ã£ã¦HTMLã‚½ãƒ¼ã‚¹ã‚’æŽ¢ç´¢ã§ãã¾ã™ã€‚ ã‚³ãƒ¼ãƒ‰ä¾‹ã€‚PHPã§æ“ä½œã—ã¾ã™ã€‚ ã“ã‚“ãªæ„Ÿã˜ã§å–å¾—ã§ãã¾ã™ï¼ˆ301ã«ãªã£ã¦ã—ã¾ã£ã¦ã„ã¾ã™ãŒâ€¦ï¼‰ã€‚ ã“ã¡ã‚‰ã‚‚ã‚³ãƒ¼ãƒ‰ä¾‹ã€‚SQLã£ã½ã„è¨˜è¿°ãŒé¢ç™½ã„ã§ã™ã€‚ ã‚¯ãƒ©ã‚¹ã‚„IDãªã©ã§çµžã‚Šè¾¼ã‚“ã ã‚Šã€ç‰¹å®šã®ã‚¿ã‚°ã ã‘ã‚’æŠ½å‡ºã™ã‚‹ã“ã¨ã‚‚ç°¡å˜ã«ã§ãã¾ã™ã€‚ãã—ã¦æŒ‡å®šã—ãŸè¦ç´ ã ã‘æŠ½å‡ºã—ã¦å‡¦ç†ãŒå¯èƒ½ã§ã™ã€‚ä»Šå¾Œã€LIMITãªã©ã«ã‚‚å¯¾å¿œã—ã¦ã„ãã¨ã®ã“ã¨ã§ã™ã€‚ html SQLã¯PHPè£½ã€New BSD Licenseã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ MOONGIFTã¯ã“ã†è¦‹ã‚‹ SQLã¯ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã§ä½¿ã‚ã‚Œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã¨æ§‹é€ ä½“ç³»ãŒå¤§ããç•°ãªã‚‹ãŸã‚ã«
brendon 2013/04/07
php

sql
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ - é–‹ç™ºè€…ã‚’å¾…ã¡å—ã‘ã‚‹25ã®è½ã¨ã—ç©´
3. è«¸å›ã¯è‡ªã‚‰ã®çµŒé¨“ã‹ã‚‰ã„ãã‚‰ã‹å¦ã¶ã“ã¨ãŒã§ ãã‚‹ã¨ã„ã†ã€å…¨ãæ„šã‹ãªè€ƒãˆã§ã‚ã‚ã†ãŒã€ ä½™ã¯ã‚€ã—ã‚ä»–äººã®å¤±æ•—ã‚’å¦ã¶ã“ã¨ã§ã€è‡ªåˆ†ã® å¤±æ•—ã‚’å›žé¿ã™ã‚‹ã“ã¨ã‚’å¥½ã‚€ã€‚ â”€ã‚ªãƒƒãƒˆãƒ¼ãƒ»ãƒ•ã‚©ãƒ³ãƒ»ãƒ“ã‚¹ãƒžãƒ«ã‚¯ Nur ein Idiot glaubt, aus den eigenen Erfahrungen zu lernen. Ich ziehe es vor, aus den Erfahrungen anderer zu lernen, um von vorneherein eigene Fehler zu vermeiden.
brendon 2013/02/17
sql

book
ãƒªãƒ³ã‚¯
ã€ŒSQL ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã¯è‰²ã‚“ãªæˆ¦äº‰ã®ç«ç¨®ã«ãªã‚Šãã† - yoshiori.github.io
ç›£è¨³ã®ä¸€äººã§ã‚ã‚‹ @t_wada ã«çŒ®æœ¬é ‚ãã¾ã—ãŸã€‚ ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ï¼ï¼ï¼ ã§ã ã€ã„ããªã‚Šã ã‘ã©ã‚³ãƒ¬ã€ã‚¿ã‚¤ãƒˆãƒ«ã§æã—ã¦ã‚‹ã¨æ€ã†ã‚“ã ã‚ˆãâ€¦â€¦ ã ã£ã¦ã€SQL ã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã¦ã‚¿ã‚¤ãƒˆãƒ«ã ã£ãŸã‚‰ã€ join ã—ãŸçµæžœã®æ–¹ã§ where ã§çµžã‚‹ã‚ˆã‚Šã‚‚ on å¥ã§å…ˆã«çµžã‚Œ çš„ãªã®ãŒæ›¸ã„ã¦ã‚ã‚‹ã¨æ€ã†ã˜ã‚ƒã‚“ï¼ï¼ å•ã„åˆã‚ã›è¨€èªžã®äº‹ã ã¨æ€ã†ã˜ã‚ƒã‚“ï¼ï¼ï¼ é•ã£ãŸâ€¦â€¦ ã»ã¨ã‚“ã©æ›¸ã„ã¦ã‚ã‚‹ã®ã¯ DB è¨è¨ˆã«ã¤ã„ã¦ã ã£ãŸâ€¦â€¦ ã¾ãã€å‰¯é¡Œã¯ã€ŒAvoiding the Pitfalls of Database Programmingã€ã®ã ã—ã€ã¾ãã„ã„ã‹ã€‚ ã‚“ã§ã€èªã‚“ã§ã¿ãŸæ„Ÿæƒ³ã¨ã‹ ã‚‚ã†ãã€ä½•å¹´ã‹ DB çµ¡ã‚“ã é–‹ç™ºã—ãŸã“ã¨ã®ã‚ã‚‹äººãªã‚‰ï¼ˆãƒ»âˆ€ãƒ»ï¼‰ï¾†ï¾”ï¾†ï¾”å‡ºæ¥ã‚‹ã¨æ€ã†ã€‚ ã€Œâ€ãƒžãƒ«ãƒã‚«ãƒ©ãƒ ã‚¢ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ãƒˆâ€ã¨ã‹ 10 å¹´å‰ã«é€šã£ãŸã‚ãƒ¼ã€ ã¨ã‹ ã€Œã‚ãƒ¼ã¯ã„ã¯ã„â€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚·ãƒ§ãƒƒãƒˆã‚¬ãƒ³â€ä¹™ã€ ã¿ãŸã„ãªã€‚ Explain
brendon 2013/02/11
sql

programming
ãƒªãƒ³ã‚¯
SQLä¸Šç´šè€…ã“ãçŸ¥ã£ã¦æ¬²ã—ã„ã€ãªãœO/Rãƒžãƒƒãƒ‘ãƒ¼ãŒé‡è¦ã‹ï¼Ÿ
(PgDay2012ç™ºè¡¨è³‡æ–™) SQLã«ã¨ã£ã¦ã€ãªãœO/Rãƒžãƒƒãƒ‘ãƒ¼ãŒé‡è¦ã‹ã‚’èª¬æ˜Žã—ãŸè³‡æ–™ã§ã™ã€‚Read less
brendon 2012/12/07
sql
ãƒªãƒ³ã‚¯
SQLã®æš—é»™ã®åž‹å¤‰æ›ã¯ãƒ¯ãƒŠãŒã„ã£ã±ã„
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚å…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2009å¹´9æœˆ24æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€SQLã«ãŠã„ã¦ã€Œæš—é»™ã®åž‹å¤‰æ›ã€ã‚’ä½¿ã†ã¹ãã§ãªã„ç†ç”±ã¨ã—ã¦ã€å…·ä½“çš„ãªã€Œãƒ¯ãƒŠã€ã‚’ã„ãã¤ã‹ç´¹ä»‹ã—ã¾ã™ã€‚Â æ•°å€¤é …ç›®ã«å¯¾ã™ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã®ã¾ã¨ã‚ã«ã¦èª¬æ˜Žã—ãŸã‚ˆã†ã«ã€RDBã®æ•°å€¤åž‹ã®åˆ—ã«å¯¾ã—ã¦SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã‚’ã™ã‚‹æ–¹æ³•ã¨ã—ã¦ã€ä»¥ä¸‹ã®ä¸‰ç¨®é¡žãŒçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ ãƒã‚¤ãƒ³ãƒ‰æ©Ÿæ§‹ã‚’ç”¨ã„ã‚‹ ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®æ•°å€¤ã¨ã—ã¦ã®å¦¥å½“æ€§ç¢ºèªã‚’è¡Œã† ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’æ–‡å—åˆ—ãƒªãƒ†ãƒ©ãƒ«ã¨ã—ã¦ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹ ã“ã®ã†ã¡ã€æ–¹æ³•3ã‚’ä½¿ã†ã¹ãã§ãªã„èª¬æ˜Žã®è£œè¶³ã§ã™ã€‚å…·ä½“çš„ã«ã¯ã€æ–¹æ³•3ã«ã¯ã€ã€Œæš—é»™ã®åž‹å¤‰æ›ã€ãŒç™ºç”Ÿã—ã¾ã™ãŒã€ãã‚ŒãŒæ€ã‚
brendon 2011/12/16
sql
ãƒªãƒ³ã‚¯
åœ°ç„ã®ã‚ˆã†ã«ã‚ˆãã‚ã‹ã‚‹SQLãƒ†ãƒ¼ãƒ–ãƒ«çµåˆ - ã“ã›ãã®æŠ€è¡“æ—¥è¨˜
ãƒ†ãƒ¼ãƒ–ãƒ«ã®JOINãŒè‹¦æ‰‹ã§ã—ãŸãŒã€ã“ã®ä¾‹ã‚’æ€ã„ã¤ã„ã¦ã‹ã‚‰ã¯ã€ã™ã£ãã‚Šãã£ãã‚Šç†è§£ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã‚€ã—ã‚é ã‹ã‚‰é›¢ã‚Œã¾ã›ã‚“â€¦â€¦ã€‚ â€» INNERã€OUTERã¯é£¾ã‚Šã€‚çœç•¥ã§ãã‚‹ã€‚ INNER JOIN â†’ JOIN LEFT OUTER JOIN â†’ LEFT JOIN RIGHT OUTER JOIN â†’ RIGHT JOIN â€» ON ...=... ã‚’ã¾ã¨ã‚ã¦ USING(å±žæ€§) ã¨æ›¸ã‘ã‚‹ã€‚ â€» ä½•ã§çµåˆã™ã‚‹ã‹è¨€ã†ã¾ã§ã‚‚ãªã„æ™‚ã¯ã€NATURALã‚’æŒ‡å®šã™ã‚‹ã¨å‹æ‰‹ã«JOINã—ã¦ãã‚Œã‚‹ã€‚NATURALã«JOINã—ã¦â€¦â€¦ã€‚ â€» WHEREã¯çµåˆã—ãŸçµæžœã«ä½œç”¨ã™ã‚‹ã€‚ â€» ç¾å®Ÿã«ã¯ä¸Šå›³ã®ã‚ˆã†ã«1å¯¾1ã§çµåˆã—ã¾ã›ã‚“ã€‚ â€» ãŠã¾ã‘ã€‚CROSS JOINã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚
brendon 2010/09/16
sql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MySQLã®è¤‡åˆINDEX - æ†‚é¬±ãªãƒ—ãƒã‚°ãƒ©ãƒžã®å½¢è€Œä¸Šå¦
MySQL MySQLã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã€‚MySQLã‚’ä½¿ã„ã“ãªã—ã¦ã„ã‚‹äººã«ã¯å¸¸è˜ã®ç¯„ç–‡ã«ã¯ã„ã‚‹çŸ¥è˜ã ã¨æ€ã†ã®ã§ã™ãŒã€ã‹ã¤ã¦ã®ç§ã®ã‚ˆã†ã«ã€çŸ¥ã‚‰ãªã„ã¨ãƒ‰ãƒ„ãƒœã«ã¯ã¾ã‚‹ã®ã§ã€ã“ã“ã«ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ã‚¿ã‚¤ãƒˆãƒ«ã§ã©ã†ã„ã†å†…å®¹ã‹ã€ã‚‚ã—ã‹ã—ãŸã‚‰å¤§ä½“ã€æƒ³åƒãŒã¤ãã‹ãªã¨æ€ã†ã®ã§ã™ãŒã€MySQLã¯1ã¤ã®ã‚¯ã‚¨ãƒªãƒ¼ã§1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã€1ã¤ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã—ã‹æ©Ÿèƒ½ã—ãªã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ˆã†ã™ã‚‹ã«ã€ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€æ™®é€šã«å¤§é‡ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¼µã£ã¦ã‚‚ã‚ã¾ã‚Šæ„å‘³ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ãã“ã§ã€ä»Šå›žã¯ã€æœ€é©ãªè¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã¯ã‚‹ã“ã¨ãŒã§ãã‚‹ã‹è€ƒãˆã¦ã„ã“ã†ã˜ã‚ƒãªã„ã‹ã€ã¨ã„ã†è¶£æ—¨ã§æ›¸ã„ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ã¾ãšã¯åˆ†æžã€‚ãƒ†ã‚¹ãƒˆç’°å¢ƒã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã¦ã„ãªã„SQLã‚’é›†ã‚ã‚‹ã¾ãšã¯ã€/etc/my.cnfã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ä»¥ä¸‹ã®ã‚ˆã†ã«è¨å®šã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã¦ã„ãªã„SQLã‚’ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒ¼ã«åãå‡ºã—ã¾ã™ã€‚ slow
brendon 2010/09/01
mysql

sql
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ - SQLer ç”Ÿå³¶å‹˜å¯Œ ã®ãƒ–ãƒã‚°
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒåˆ†ã‹ã£ã¦ãªã„äººãŒéžå¸¸ã«å¤šã„ã€‚ ç¾å®Ÿã«ã‚ã£ãŸä¾‹ã§ã€60ã‚«ãƒ©ãƒ ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã€å‰ã‹ã‚‰3ã¤ãšã¤ã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’20å€‹ä½œã‚‹ã¨ã‹ã€30ã‚«ãƒ©ãƒ ã‚’1ã¤ã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã™ã‚‹ã¨ã‹ã€æ„å‘³ãŒåˆ†ã‹ã£ã¦ã„ãªã„äººãŒéžå¸¸ã«å¤šãã„ã¾ã™ã€‚ â€» è©³ã—ã„äººã¸ã€‚ã“ã“ã§ã¯ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ = B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨è€ƒãˆã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ã€ãã®ã¾ã¾ã‚ºãƒãƒªã€Œç´¢å¼•ã€ã®ã“ã¨ã§ã™ã€‚ èº«è¿‘ãªä¾‹ã§ã¯ã‚«ãƒ©ã‚ªã‚±ãŒã‚ã‚Šã¾ã™ã€‚ã„ã‚ã‚†ã‚‹ã‚«ãƒ©ã‚ªã‚±æœ¬ãŒã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€‚ãƒªãƒ¢ã‚³ãƒ³ã§æŠ¼ã™ç•ªå·ãŒä¸»ã‚ãƒ¼ã€æµã‚Œã‚‹éŸ³æ¥½ãƒ»æ˜ åƒãŒå®Ÿãƒ¬ã‚³ãƒ¼ãƒ‰ã¨è€ƒãˆã¦ã¿ã¦ãã ã•ã„ã€‚ ã‚«ãƒ©ã‚ªã‚±æœ¬ã¯ã€ŒæŒæ‰‹åé †ã€ã¨ã€Œæ›²åé †ã€ã®2ã¤ã¯æœ€ä½Žé™ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ã“ã‚Œã‚‰ã¯ã€ æŒæ‰‹åé †ã¯ã€ã€ŒæŒæ‰‹åãƒ»æ›²åã€ã®çµ„ã¿åˆã‚ã›ã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€‚ æ›²åé †ã¯ã€ã€Œæ›²åãƒ»æŒæ‰‹åã€ã®çµ„ã¿åˆã‚ã›ã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€‚ ã¨è€ƒãˆã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ æƒ³åƒã—ã¦ã¿ã¦ãã ã•ã„ã€‚å°å¦ç”Ÿã§ã‚‚ã€Œã‚¢ãƒ³
brendon 2010/06/26
sql

database
ãƒªãƒ³ã‚¯
pg_sleepã‚’SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ¤œæŸ»ã«å¿œç”¨ã™ã‚‹ - ockeghem's blog
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®é€²åŒ–å½¢ã¨ã—ã¦ã€ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã„ã†æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ã€‚é€šå¸¸ã®SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¯ã€æ¤œç´¢çµæžœè¡¨ç¤ºã‚„ã‚¨ãƒ©ãƒ¼è¡¨ç¤ºã®ã¨ã“ã‚ã«ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æƒ³å®šã¨ã¯åˆ¥ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»åˆ—ã®å€¤ã‚’è¡¨ç¤ºã™ã‚‹ã‚‚ã®ã§ã™ãŒã€ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¯ã€SQLã®çµæžœãŒã‚¨ãƒ©ãƒ¼ã«ãªã‚‹ãƒ»ãªã‚‰ãªã„ã‚’1ãƒ“ãƒƒãƒˆã®æƒ…å ±ã¨ã—ã¦æ‚ªç”¨ã—ã€ã“ã‚Œã‚’ç©ã¿é‡ãã‚‹ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®ä»»æ„æƒ…å ±ã‚’å¾—ã‚‹ã“ã¨ãŒã§ãã‚‹ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚ 1ãƒ“ãƒƒãƒˆã®æƒ…å ±ãŒå¾—ã‚‹æ‰‹æ®µã¨ã—ã¦ã¯ã€SQLã®ã‚¨ãƒ©ãƒ¼è¡¨ç¤ºã«é™ã‚‰ãªã„ã‚ã‘ã§ã€ç¾å®Ÿå•é¡Œã¨ã—ã¦ã€SQLã®ã‚¨ãƒ©ãƒ¼ãŒå¤–éƒ¨ã‹ã‚‰ã¯åˆ¤åˆ¥ã—ã«ãã„å ´åˆã‚‚ã‚ã‚Šã¾ã™ã€‚ãã®ã‚ˆã†ãªå ´åˆã®ç©¶æ¥µå½¢ã¨ã—ã¦ã€æ™‚é–“å·®ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã„ã†æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ MS SQL Serverã«ã¯ã€waitfor delayã¨ã„ã†å‘½ä»¤ãŒã‚ã£ã¦ã€æ™‚ãƒ»åˆ†ãƒ»ç§’æŒ‡å®šã§ã‚¹ãƒªãƒ¼ãƒ—ã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚é‡‘åºŠæœ¬ã«ã¯ã€MySQLã‚„PostgreSQLã®å ´åˆã®
brendon 2009/11/05
security

database

sql
ãƒªãƒ³ã‚¯
å¿˜ã‚Œã£ã½ã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ã‚ªãƒ©ã‚¯ãƒ«ï¼³ï¼±ï¼¬ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ç‰©å¿˜ã‚Œã®æ¿€ã—ã„ç®¡ç†äººã¯ã€èª¿ã¹ãŸã“ã¨ã‚‚ã™ãå¿˜ã‚Œã¦ã—ã¾ã†ã®ã§ã€åŒã˜ã“ã¨ã‚’ã€ä½•åº¦ã‚‚èª¿ã¹ãªãŒã‚‰é–‹ç™ºã—ã¦ã„ã¾ã™ã€‚ ãŸã ã€ï¼©ï¼´æ¥ç•Œã¯è¦šãˆã‚‹ã“ã¨ãŒå¤šéŽãŽã¦ã€æ–‡æ³•ãªã©ã®ç´°ã‹ã„ã“ã¨ã¯ã‚ã¾ã‚Šè¦šãˆã‚‹æ°—ãŒç„¡ã„ã¨ã„ã†ã®ã‚‚ã‚ã‚Šã¾ã™ãŒï¼ˆç¬‘ï¼‰ ãã“ã§ã€ä½•åº¦ã‚‚åŒã˜ã“ã¨ã‚’èª¿ã¹ãªãã¦ã‚‚ã„ã„ã‚ˆã†ã«ã€ORACLE SQLãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ã‚µã‚¤ãƒˆã«ã¾ã¨ã‚ã‚‹äº‹ã«ã—ã¾ã—ãŸã€‚ ç§ã¨åŒã˜ã‚ˆã†ãªãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã‚„ï¼³ï¼¥ã‚‚çµæ§‹ã„ã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ã¨æ€ã„ã¾ã™ã®ã§ä½¿ãˆãã†ã ã£ãŸã‚‰åˆ©ç”¨ã—ã¦ã¿ã¦ä¸‹ã•ã„ã€‚
brendon 2007/05/02
oracle

sql

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

database
ãƒªãƒ³ã‚¯
1