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

tmsanrinsha id:tmsanrinsha

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

${{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ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ãƒ†ãƒ¼ãƒ–
tmsanrinsha 2017/08/18
csv

LTSV

SQL
ãƒªãƒ³ã‚¯
vimã‹ã‚‰ç›´æŽ¥DBè§¦ã£ãŸã‚ŠSQLè£œå®Œã—ãŸã‚Š - Qiita
å…¬å¼ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯20.0ã ãŒã€githubã«ã¯19.0ã¾ã§ãŒä¸ŠãŒã£ã¦ã„ã‚‹ã€‚ ãŸã ã—19.0ã§åŠ ãˆã‚‰ã‚ŒãŸä¿®æ£ã«å°‘ã—å•é¡ŒãŒã‚ã£ãŸãŸã‚ã€ã“ã“ã§ã¯ç‰¹ã«ã“ã ã‚ã‚Šã‚‚ãªã„ãŸã‚18.0ã‚’ä½¿ç”¨ã—ãŸã€‚ (å…·ä½“çš„ã«ã¯cmd_terminatorã®å®šç¾©ã«å•é¡Œã‚ã‚Šã€‚æ˜Žç¤ºçš„ã«cmd_terminatorã‚’æŒ‡å®šã™ã‚‹ãªã©ã§å›žé¿ã¯ã§ãã‚‹) æŽ¥ç¶šè¨å®š æŽ¥ç¶šå…ˆã®æŒ‡å®šæ–¹æ³•ã«ã¯ä½•ç¨®é¡žã‹ã®æ–¹æ³•ãŒã‚ã‚‹ãŒã€ æŽ¥ç¶šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ã¾ã¨ã‚ãŸæŽ¥ç¶šãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ç”¨ã™ã‚‹ã®ãŒç°¡å˜ã‹ã¨æ€ã†ã€‚ æŽ¥ç¶šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’å€‹åˆ¥ã«.vimrcã«è¨å®š æŽ¥ç¶šãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ã‚’.vimrcã«è¨å®š ã‚¦ã‚£ã‚¶ãƒ¼ãƒˆçš„ã«æŽ¥ç¶šãƒ‘ãƒ©ãƒ¼ãƒ¡ã‚¿ã‚’æŒ‡å®š(<Leader>sbpã§åˆ©ç”¨å¯èƒ½) Modelineã‚’ä½¿ç”¨ã—ã¦æŽ¥ç¶šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’è¨å®š æŽ¥ç¶šãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ã®è¨å®š ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ã¯å¥½ããªã ã‘ä½œæˆå¯èƒ½ã€‚ è©³ç´°ã¯ãƒ˜ãƒ«ãƒ—ã«ç”¨ä¾‹ãŒãŸãã•ã‚“ã‚ã‚‹ã®ã§ãã¡ã‚‰ã‚’å‚ç…§ã€‚ " ç’°å¢ƒã«åˆã‚ã›ã¦ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ—ãƒã‚°ãƒ©ãƒ ã‚’å¤‰æ›´ "
tmsanrinsha 2016/12/03
vim

sql

dbext
ãƒªãƒ³ã‚¯
SQL ã§ãƒ•ã‚¡ã‚¤ãƒ«æ¤œç´¢ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ selects ã‚’æ›¸ã„ãŸè©± | blog.jxck.io
Intro UNIX ã‚³ãƒžãƒ³ãƒ‰ã‚’ SQL ã§æŠ½å‡ºã§ãã‚‹ãƒ„ãƒ¼ãƒ« qq ã‚’ä½œã£ãŸã€‚ ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã‚’èªã‚“ã§ã€ãã†ã„ãˆã°ä¼¼ãŸã‚ˆã†ãªã‚‚ã®ã‚’ä½œã£ã¦ãŸãªã¨æ€ã„å‡ºã—ãŸã€‚ è‡ªåˆ†ã® dotfiles ã®ä¸ã«ã‚ã‚‹ã€ä¾¿åˆ©ã‚³ãƒžãƒ³ãƒ‰é›†ã®ä¸ã«ã‚ã‚‹ selects ã«ã¤ã„ã¦ã§ã‚ã‚‹ã€‚ ã“ã®ã‚³ãƒžãƒ³ãƒ‰ã¯ SQL ã¨ã„ã†æ¤œç´¢ã‚’è¨˜è¿°çš„ã«è¡¨ç¾ã™ã‚‹å…±é€šè¨€èªžã‚’ãƒ•ã‚¡ã‚¤ãƒ«æ¤œç´¢ã«å¿œç”¨ã—ã€ Ruby ã®å‹•çš„è¨€èªžã¨ã—ã¦è¡¨ç¾åŠ›ã‚’ä½¿ã£ã¦å®Ÿè£…ã—ãŸã‚‚ã®ã¨ã„ãˆã‚‹ã€‚ ãã®å®Ÿè£…æ–¹æ³•ã¨å®Ÿè¡Œä¾‹ãªã©ã«ã¤ã„ã¦è¨˜ã™ã€‚ selects çµè«–ã‹ã‚‰ã„ã†ã¨ã“ã†ã„ã†ã‚³ãƒžãƒ³ãƒ‰ã ã€‚ $ selects mtime, size, basename from './entries/**/*' where extname '==' '.md' and size '>' 1000 order by mtime 2016-07-06 22:45:44 +0900 18437 web-font
tmsanrinsha 2016/08/07
sql

file

ruby
ãƒªãƒ³ã‚¯
Big Sky :: UNIX ã‚³ãƒžãƒ³ãƒ‰ã‚’ SQL ã§æŠ½å‡ºã§ãã‚‹ãƒ„ãƒ¼ãƒ« qq ã‚’ä½œã£ãŸã€‚
æ˜¨æ—¥åƒ•ã® Twitter ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ã§ q ã¨ã„ã†ãƒ„ãƒ¼ãƒ«ãŒè©±é¡Œã«ä¸ŠãŒã£ã¦ã„ã¾ã—ãŸã€‚ GitHub - harelba/q: q - Run SQL directly on CSV or TSV files Text as Data q is a command line tool that allows direct execution of SQL-like q... https://github.com/harelba/q æ¨™æº–å…¥åŠ›ã‚’ SQL ã§æŠ½å‡ºã§ãã‚‹ã¨ã„ã†ç‰©ã§ã™ã€‚ãŸã å€‹äººçš„ã«ã¯ã€Œã“ã†ã„ã†ã® python ã˜ã‚ƒãªãã¦ Go ã§ãƒ“ãƒ«ãƒ‰ã•ã‚Œã¦ã‚‹ã¨åŠ©ã‹ã‚‹ã‚ˆãªãƒ¼ã€ã¨æ€ã£ãŸã®ã§ q ã¨åŒã˜æ§˜ãªå‹•ä½œã«ãªã‚‹ãƒ„ãƒ¼ãƒ«ã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚ GitHub - mattn/qq Select stdin with query https://github.com/mattn/qq ä¾‹ãˆã° msys2 ã®ã‚·
tmsanrinsha 2016/08/06
qq

sql

mattn

command
ãƒªãƒ³ã‚¯
go-sql-driver/mysql ã§ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ç½®æ›ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¾ã—ãŸ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
å‰å›žã®è¨˜äº‹ã§å°‘ã—è§¦ã‚Œã¾ã—ãŸãŒã€ go-sql-driver/mysql ã«ãƒ‰ãƒ©ã‚¤ãƒå´ã§ã®ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ç½®æ›ã‚’å®Ÿè£…ã™ã‚‹ãƒ—ãƒ«ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’å‡ºã—ã¦ã„ã¾ã—ãŸã€‚ ãã‚ŒãŒãƒžãƒ¼ã‚¸ã•ã‚ŒãŸã®ã§ã€èƒŒæ™¯ã®ãŠã•ã‚‰ã„ã¨åˆ©ç”¨æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¦ãŠãã¾ã™ã€‚ èƒŒæ™¯ Go ã® database/sql ã®æ¦‚è¦ã«ã¤ã„ã¦ã¯å‰å›žã®è¨˜äº‹ã§è§£èª¬ã—ã¾ã—ãŸã€‚ ãã“ã§èª¬æ˜Žã—ãŸã¨ãŠã‚Šã€ DB.Prepare() ã‚’ä½¿ã‚ãšã«ç›´æŽ¥ DB.Exec() ã‚„ DB.Query() ã‚’ä½¿ã£ãŸå ´åˆã€ ãƒ‰ãƒ©ã‚¤ãƒå´ã§ã®ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ç½®æ›ã«å¯¾å¿œã—ã¦ã„ãªã„ãƒ‰ãƒ©ã‚¤ãƒã§ã¯ prepare, exec, close ã§3å›žã®ãƒ©ã‚¦ãƒ³ãƒ‰ãƒˆãƒªãƒƒãƒ—ãŒç™ºç”Ÿã™ã‚‹ã“ã¨ã«ãªã‚Šã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒæ‚ªããªã‚Šã¾ã™ã€‚ åŸºæœ¬çš„ã«ã¯ DB.Prepare() ã‚’ä½¿ãˆã°ã„ã„ã®ã§ã™ãŒã€å‰å›žã®è¨˜äº‹ã§ä¿®æ£ã—ãŸã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®å•é¡Œã¯ Go 1.5 ã«ãªã‚‹ã¾ã§ç›´ã‚Šã¾ã›ã‚“ã—ã€ IN å¥ãŒã‚ã‚‹SQLæ–‡ãªã©ã§äº‹å‰ã« P
tmsanrinsha 2016/07/06
golang

SQL
ãƒªãƒ³ã‚¯
#ronsakucasual DBã®è«–ç†å‰Šé™¤ã«ã¤ã„ã¦ã²ãŸã™ã‚‰å…±æœ‰ã™ã‚‹ è«–ç†å‰Šé™¤ Casual Talks #1 ã«ã„ã£ã¦ããŸã¾ã¨ã‚ - ã‚‚ãã‚ã½ã‚ã
åå‰ ã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚° ç›®çš„ ã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰è¦‹ã‚‹ã¨ãƒ‡ãƒ¼ã‚¿ãŒãªã„ã“ã¨ã«ã—ãŸã„ã‘ã©ã€å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ã¯æ¶ˆã—ãŸããªã„ å‰Šé™¤ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’æ¤œç´¢ã—ãŸã„ ãƒ‡ãƒ¼ã‚¿ã‚’æ¶ˆã•ãšã«ãƒã‚°ã«æ®‹ã—ãŸã„ èª¤ã£ãŸæ“ä½œã‚’ãªã‹ã£ãŸã“ã¨ã«ã—ãŸã„ã€ç›´ãã«å…ƒã«æˆ»ã—ãŸã„ ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ ä¾‹ãˆã°is_deletedã¨ã„ã†ã‚«ãƒ©ãƒ ãŒtrueã®å ´åˆã¯å‰Šé™¤ã•ã‚Œã¦ã„ã‚‹ã¨ã¿ãªã™ ãƒ¡ãƒªãƒƒãƒˆ updateæ–‡ãªã‚‰ãƒ‡ãƒ¼ã‚¿ãŒç°¡å˜ã«å…ƒã«æˆ»ã›ã‚‹æ°—ãŒã™ã‚‹ã®ã§ãªã‚“ã¨ãªãå®‰å¿ƒ -> ä¿ºã®updateæ–‡ã§ãªã‚“ã¨ã‹ãªã‚‹ï¼ï¼ èµ·ã“ã‚‹ã“ã¨ SELECTã™ã‚‹ã¨ãã«ã¯å¸¸ã«WHEREå¥ãŒè¿½åŠ ã§å¿…è¦ã«ãªã‚Šã€ã‚³ãƒ¼ãƒ‰ãŒå‰Šé™¤ãƒ•ãƒ©ã‚°ã ã‚‰ã‘ã«ãªã‚‹ å…¨å“¡ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã«ç²¾é€šã—ã¦ã‚‹ã‚ã‘ã§ã¯ãªã„ã®ã§ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚ˆã£ã¦å‰Šé™¤ãƒ•ãƒ©ã‚°ã®æœ‰ç„¡ãŒã‚ã£ãŸã‚Šã—ãŸå ´åˆã€èªè˜ã®é½Ÿé½¬ã‚’ç”Ÿã¿ã‚„ã™ã„ ä¾‹ãˆã°rubyã§default_scopeã‚’ç”¨ã„ã¦ã€ã‚ˆã‹ã‚Œã¨ãŠã‚‚ã£ã¦ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ™ãƒ«ã§ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚’å¤‰ãˆãŸã‚‰ãƒã‚°ãŒãŸãã•ã‚“å‡ºã¦ãã‚‹
tmsanrinsha 2015/09/02
db

sql

è«–ç†å‰Šé™¤
ãƒªãƒ³ã‚¯
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
tmsanrinsha 2015/07/26
sql

guide

codingstyle
ãƒªãƒ³ã‚¯
åŒä¸€ã‚°ãƒ«ãƒ¼ãƒ—ã®ä¸ã§æœ€å¤§ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–å¾—ã™ã‚‹ SQL ã‚’æ›¸ã | Webã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºï¼æ•™è‚²ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¿ã‚¤ãƒ ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ¡ãƒ‡ã‚£ã‚¢
+----+----------+------------+---------+ | id | group_id | updated_at | comment | +----+----------+------------+---------+ | 1 | 1 | 2013-12-01 | C | | 2 | 2 | 2013-12-01 | A | | 3 | 1 | 2013-12-02 | B | | 4 | 2 | 2013-11-30 | D | +----+----------+------------+---------+ CREATE TABLE sample_table ( id int(11) NOT NULL, group_id int(11) NOT NULL, updated_at date NOT NULL, comment varchar(60) NOT NU
tmsanrinsha 2015/06/22
max

SQL

group
ãƒªãƒ³ã‚¯
SQLã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ†ãƒ¼ãƒ–ãƒ«ã®ç¸¦ï½¥æ¨ªå¤‰æ›
2006å¹´07æœˆ10æ—¥ ã‚¯ã‚¨ãƒªã‚’æ€ã„ã¤ã‹ãªã‹ã£ãŸåã®ãŸã‚ã«ã€‚ã“ã‚Œã¯ã‚ãã¾ã§ãƒ’ãƒ³ãƒˆã ãžã€‚ ä»¥é™ã®ä¾‹ã§ã¯ Oracle9iãƒªãƒªãƒ¼ã‚¹ï¼’ã§èª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¯ã€ä½•æ•…ã‹ç„¡é§„ã«æ¨ªé•·ã®ã‚‚ã®ãŒã‚ã£ãŸã‚Šã—ã¾ã™ã€‚ ãƒ›ã‚¹ãƒˆæ™‚ä»£ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’ãã®ã¾ã¾ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã«ã—ã¡ã‚ƒã£ãŸã‚ˆã†ãªã‚„ã¤ã§ã™ãã€‚é …ç›®åã«ã€ŒFILLER1ã€ã¨ã‹åå‰ãŒã¤ã„ã¦ã„ã‚‹ï¼ˆï¿£â–½ï¿£ï¼› ã“ã‚“ãªãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚‹ã¨ã—ã¾ã™ã€‚ SQL> DESC å£²ä¸Šãƒ©ãƒ³ã‚ãƒ³ã‚°æ¨ª; åå‰ NULL? åž‹ ---------------------------- -------- -------------------------- å£²ä¸Šå¹´ VARCHAR2(4) ï¼‘ä½è£½å“ VARCHAR2(10) ï¼‘ä½å£²ä¸Š NUMBER(5) ï¼’ä½è£½å“ VARCHAR2(10) ï¼’ä½å£²ä¸Š NUMBER(5) ï¼“ä½è£½å“ VARCHAR2(10) ï¼“ä½å£²ä¸Š
tmsanrinsha 2015/06/13
sql

ç¸¦æŒã¡ãƒ»æ¨ªæŒã¡
ãƒªãƒ³ã‚¯
RDBã®ç¸¦æŒã¡ãƒ†ãƒ¼ãƒ–ãƒ«ã¨æ¨ªæŒã¡ãƒ†ãƒ¼ãƒ–ãƒ«ã€ãŠã‚ˆã³ãã®å¤‰æ›ã«ã¤ã„ã¦
HorizVert.md ãƒ†ãƒ¼ãƒ–ãƒ«ã®ç¸¦æŒã¡æ¨ªæŒã¡ã«ã¤ã„ã¦ æ¨ªæŒã¡ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ç¸¦æŒã¡ãƒ†ãƒ¼ãƒ–ãƒ« æ¨ªæŒã¡ã¯ã„ã‚ã‚†ã‚‹ã€Œæ™®é€šã®ã€ãƒ‡ãƒ¼ã‚¿ã®æŒã¡ã‹ãŸã®ã“ã¨ã€‚ ä¾‹ãˆã°ãƒ¬ã‚³ãƒ¼ãƒ‰ã”ã¨ã«a, b, c, dã®4ã¤ã®å±žæ€§ã‚’æŒã¤ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹å ´åˆã€æ¬¡ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ãŒæ¨ªæŒã¡ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã‚ã‚‹ã€‚ create table horiz ( rowId int, a int, b int, c int, d int ); insert into horiz values ( 1, 11, 22, 33, 44 ); â€»rowIdãŒé–¢æ•°ã®å ´åˆã¯é©å½“ã«åå‰ã‚’å¤‰ãˆã¦ã ä¸€æ–¹ã€ç¸¦æŒã¡ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã¯è¡ŒIDã¨ã‚«ãƒ©ãƒ IDã‚’è¿½åŠ ã—ã¦ ãƒ¬ã‚³ãƒ¼ãƒ‰ã”ã¨ãƒ»ã‚«ãƒ©ãƒ ã”ã¨ã«1è¡Œã‚’ä½œã‚‹ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚‹ã€‚ create table vert ( rowId int, columnId int, value int ) insert into
tmsanrinsha 2015/06/13
sql

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

performance
ãƒªãƒ³ã‚¯
åˆ†å‰²ã¨æ•´åˆæ€§ã¨æˆ¦ã†
2. è‡ªå·±ç´¹ä»‹ æ¸…æ°´ ä½‘å¾ @yamionp æ ªå¼ä¼šç¤¾ gumi å‹¤å‹™ Pythonæ´ç´„2å¹´åŠ ã‚µãƒ¼ãƒãƒ¼ã•ã‚ã‚Šã¯ã˜ã‚ã¦ç´„10å¹´ å‰è·ã¯ISP
tmsanrinsha 2014/09/04
DB

sql
ãƒªãƒ³ã‚¯
Pieter Joost on Twitter: "SQL joins http://t.co/VU0D4U7fKq"
SQL joins http://t.co/VU0D4U7fKq
tmsanrinsha 2014/08/03
SQL

join
ãƒªãƒ³ã‚¯
Entity-Attribute-Value: SQL ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ - ãƒšãƒ³ã‚®ãƒ³ãƒ©ãƒœ Wiki
Bill Karwin â€œSQL Antipatterns: Avoiding the Pitfalls of Database Programmingâ€ ã®èªæ›¸ãƒ¡ãƒ¢ã€‚ Jaywalking ç›®çš„ ã‚ã‚‹å±žæ€§ã«ã¤ã„ã¦ã€è¤‡æ•°ã®å€¤ã‚’æŒãŸã›ã‚‹ã€‚ ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ : ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šãƒªã‚¹ãƒˆ ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã§è¤‡æ•°ã®å€¤ã‚’ 1 ã¤ã®åˆ—ã«ç´ã‚ã‚‹ã€‚ ä¾‹ã§ã¯ã€ç‰¹å®šã®è£½å“ã«ã¤ã„ã¦ã®æ‹…å½“è€…ã‚’è¤‡æ•°è¨å®šã™ã‚‹ã®ã«ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã§ã€æ‹…å½“è€…ã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆIDã‚’è¨˜è¿°ã—ã¦ã„ã‚‹ã€‚ create table products ( product_id integer, product_name varchar(1000), acount_id varchar(100), -- comma separated list -- ... ); insert into products (product_id, product_name, accou
tmsanrinsha 2014/03/06
SQL

ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
ãƒªãƒ³ã‚¯
GitHub - harelba/q: q - Run SQL directly on delimited files and multi-file sqlite databases
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
tmsanrinsha 2014/02/26
sql

python

command line

q
ãƒªãƒ³ã‚¯
Big Sky :: SQL ã§ CSV ã®ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºå‡ºæ¥ã‚‹ textql
CSV ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ‰±ã£ã¦ã„ã‚‹æ™‚ã«ã€æœ€å¤§å€¤æœ€å°å€¤ã¨å¾—ãŸã‚Šåˆè¨ˆã‚’å¾—ãŸã‚Šã™ã‚‹ã®ã«ã„ã¡ã„ã¡ Excel ã‚’èµ·å‹•ã™ã‚‹ã®ã¯ã¨ã¦ã‚‚é¢å€’ã§ã™ã—ã€ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ãã®ã‚‚é¢å€’ã€‚ ãã‚“ãªå ´åˆã¯ textql ã‚’ä½¿ã†ã¨ä¾¿åˆ©ã§ã™ã€‚ dinedal/textql - GitHub Execute SQL against structured text like CSV or TSV https://github.com/dinedal/textql golang ã§æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ãƒ“ãƒ«ãƒ‰ã™ã‚‹ã¨ä¾å˜æ€§ã®ç„¡ã„å®Ÿè¡Œãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒç”Ÿæˆã•ã‚Œã¾ã™ã€‚ä½¿ã„æ–¹ã¯ãƒªãƒ³ã‚¯å…ˆã®å‹•ç”»gifã‚’å‚ç…§ä¸‹ã•ã„ã€‚ ç°¡å˜ã«ã©ã‚“ãªäº‹ãŒå‡ºæ¥ã‚‹ã‹ã¨ã„ã†ã¨ $ cat ~/sample_data.csv | textql -header -sql "select sum(cast(value as integer)) from tbl" 18 ã“ã‚“ãªäº‹ãŒå‡ºæ¥ã‚‹ãƒ„ãƒ¼ãƒ«
tmsanrinsha 2014/02/05
SQL

Go

csv

matthn
ãƒªãƒ³ã‚¯
GitHub - vim-scripts/dbext.vim: Provides database access to many dbms (Oracle, Sybase, Microsoft, MySQL, DBI,..)
tmsanrinsha 2013/12/24
vim

SQL
ãƒªãƒ³ã‚¯
ft_sql - Vimæ—¥æœ¬èªžãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ
tmsanrinsha 2013/12/24
vim

sql
ãƒªãƒ³ã‚¯
Hunting Field: [vim] vimã‹ã‚‰mysqlã‚’æ“ä½œã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ dbext
æœ€è¿‘ã€mysqlã®ã‚¯ã‚¨ãƒªãŸãŸãã“ã¨ãŒå¤šããªã£ã¦ããŸã€‚ å‘¨ã‚Šã®äººã¯ã€mysql workbenchã¨ã„ã†GUIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’ä½¿ã£ã¦ã„ã‚‹ã€‚ MySQL Workbench ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³å¼µã‚Šã¾ãã‚Šã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã™ã‚‹ã«ã¯ã„ã„ã‹ã‚‚ã—ã‚Œãªã„ãŒã€ ç¾çŠ¶ãƒ†ãƒ¼ãƒ–ãƒ«ä½œã‚‹ã¨ãã¯symfonyã®ã‚³ãƒžãƒ³ãƒ‰ä½¿ã†ã—ã€ ã¡ã‚‡ã£ã¨selectå®Ÿè¡Œã™ã‚‹ãŸã‚ã«GUIç«‹ã¡ä¸Šã’ã‚‹ã®ã¯ã‚ã‚“ã©ãã•ã„ã€‚ ãã—ã¦ä½•ã‚ˆã‚Šã€å‘¨ã‚Šã®äººã¨ãŠã‚“ãªã˜ã‚‚ã®ä½¿ã†ã®ã¯è² ã‘ãŸæ°—ãŒã™ã‚‹ã€‚ ã§ã€vimã‹ã‚‰mysqlã‚’å®Ÿè¡Œã™ã‚‹ãŸã‚ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ dbextã‚’å…¥ã‚Œã¦ã¿ãŸã€‚ vim-scripts / dbext.vim Vimã‹ã‚‰ä»»æ„ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« pathogenã‚’ä½¿ã£ã¦ã„ã‚Œã°ã€ä»¥ä¸‹ã§OKã€‚ $ cd ~/.vim/bundle $ git clone https://github.com/vim-scripts/dbext.vim ä¾¿åˆ©ã ã€‚ [
tmsanrinsha 2013/12/24
vim

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

NoSQL
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸