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

supermomonga id:supermomonga

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

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

batch

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

sql

RDBMS
ãƒªãƒ³ã‚¯
DBã‚³ãƒžãƒ³ãƒ‰æ¨ªæ–æ¯”è¼ƒãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä½œã‚Šã¾ã—ãŸ - clock-up-blog
æ¨ªæ–çš„ã«DBæ“ä½œã®é¡žä¼¼ã‚³ãƒžãƒ³ãƒ‰ã‚’æŽ¢ã™ãŸã‚ã®ã‚µã‚¤ãƒˆ ä¾‹ãˆã° MySQL ã‚’çŸ¥ã£ã¦ã„ã‚‹äººãŒ æ–°ã—ãä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ä¾‹ãˆã° Oracle ã‚’å¦ç¿’ã™ã‚‹éš›ã« MySQL ã§ã„ã†ã¨ã“ã‚ã®ã‚¢ãƒ¬ã¯ Oracle ã§ã¯ã©ã†ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãªã‚“ã ã‚ã† ã¨ã„ã†æ„Ÿã˜ã«æƒ…å ±ã‚’æŽ¢ã™å ´é¢ãŒå¤šãã‚ã‚Šã¾ã™ã€‚ ãã†ã„ã†é¡žã®æƒ…å ±ã‚’æŽ¢ã™ã¨ãã«å½¹ã«ç«‹ã¡ãã†ãªãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚µã‚¤ãƒˆã‚’ä½œã‚Šã¾ã—ãŸã€‚ xref.jp xref.jp - Database è¿½è¨˜: ã‚³ãƒ³ãƒ†ãƒ³ãƒ„å¢—ã‚„ã—ã¾ã—ãŸ yum, apt-get, rpm ç‰ã€…ã®æ¨ªæ–æ¯”è¼ƒãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ - clock-up-blog ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ GitHub ã«ä¸Šã’ã¦ã‚ã‚‹ã®ã§èˆˆå‘³ã‚ã‚‹äººã¯è¦‹ã¦ã¿ã‚‹ã¨è‰¯ã„ã§ã™ã€‚ kobake/xref.jp Â· GitHub PHP ã§æ›¸ã„ã¦ã¾ã™ã€‚ã™ã‚“ã”ã„æ±šã„ã§ã™ã€‚è¬™éœã˜ã‚ƒãªãã¦æœ¬å½“ã«ã€‚ ãƒ—ãƒ«ãƒªã‚¯æ“è¿Žã€‚ æ©Ÿèƒ½ ãƒžãƒˆãƒªã‚¯ã‚¹æ–¹å‘ã®åˆ‡æ›¿ æ¯”è¼ƒè¡¨ã®è¦‹å‡ºã—ã®å‘ãã£ã¦ã€ãã®çµ„ã¿
supermomonga 2015/01/02
RDBMS

mysql

sql
ãƒªãƒ³ã‚¯
Doma SQLãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã®ã—ãã¿
é€Ÿç¿’ï¼è«–ç†ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ï½žåŸºç¤Žã‹ã‚‰æœ€æ–°å‹•å‘ã¾ã§ï½žï¼ˆPostgreSQL Conference Japan 2022 ç™ºè¡¨è³‡æ–™ï¼‰
supermomonga 2014/11/23
java8

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

database

performance
ãƒªãƒ³ã‚¯
GitHub - r7kamura/scheman: SQL schema parser.
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
supermomonga 2014/07/16
sql

schema
ãƒªãƒ³ã‚¯
ãµã¤ã†ã®Webé–‹ç™ºè€…ã®ãŸã‚ã®ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
Your browser doesn't support the features required by impress.js, so you are presented with a simplified version of this presentation. For the best experience please use the latest Chrome or Safari browser. Firefox 10 (to be released soon) will also handle it.
supermomonga 2014/07/12
sql

MySQL

slide

performance
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ Cassandraã€Mongodbã€SQLiteã€H2ã€MySQLã€Postgres - cypher256's blog
ä¸‹è¨˜ã®ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒè‰¯ã•ã’ãª SQLite ã‚’ä½¿ç”¨äºˆå®šã§ã™ãŒã€ã‚‚ã£ã¨é€Ÿã„ã‚‚ã®ãŒç„¡ã„ã‹ç¢ºèªã®ãŸã‚ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¨ˆæ¸¬ã—ã¦ã¿ã¾ã—ãŸã€‚SQL åˆ©ç”¨å‰æã§ã™ãŒã€NoSQL ãŒåœ§å€’çš„ãªæ€§èƒ½ã‚’å‡ºã™å ´åˆã¯æ¤œè¨Žã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã®ã§ KVS ã‚‚ç¢ºèªã—ã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ä»¶æ•°ã¯ 1 å„„ä»¶ç¨‹åº¦ã€JDBC SQL åˆ©ç”¨å¯èƒ½ INSERTã€UPDATE ã¯ãƒãƒƒãƒ SELECT ã¯ä¸»ã‚ãƒ¼ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã‚’é‡è¦– å°†æ¥ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®ãŸã‚ã®åˆ†æ•£ã¯ã‚ã‚Šãˆã‚‹ãŒã€ã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ³ã§é…ã„ã®ã¯ã ã‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ è¨ˆæ¸¬ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å ã‚¿ã‚¤ãƒ— å½¢æ…‹ è©•åˆ¤ è¨ˆæ¸¬ã«ã¤ã„ã¦ã®å‚™è€ƒ SQLite RDB çµ„ã¿è¾¼ã¿ â€»2 ãŠã‚‚ã¡ã‚ƒã€Androidæ¨™æº– JDBCæ“ä½œ â€»1 H2 RDB çµ„ã¿è¾¼ã¿ â€»2 çµ„ã¿è¾¼ã¿æœ€é€Ÿ JDBCæ“ä½œ â€»1 Derby RDB çµ„ã¿è¾¼ã¿ â€»2 Javaæ¨™æº–ã§
supermomonga 2013/07/06
mysql

KVS

MongoDB

performance

db

NoSQL

SQL

sqlite

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
Sequelã®ã™ã™ã‚ - ã¨ã¿ãŸã¾ã•ã²ã‚ - Rabbit Slide Show
Page: 1 Sequelã®ã™ã™ã‚ ã€œç§ãŒSQLã‚’å«Œã„ãªç†ç”±ã€œ ã¨ã¿ãŸã¾ã•ã²ã‚ RubyHiroba 2013 2013-06-02 Sequelã®ã™ã™ã‚ - ã€œç§ãŒSQLã‚’å«Œã„ãªç†ç”±ã€œ Powered by Rabbit 2.0.7 Page: 2 è‡ªå·±ç´¹ä»‹ ã¨ã¿ãŸ ã¾ã•ã²ã‚ é•·é‡ŽçœŒåŒ—éƒ¨åœ¨ä½ ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ (Ruby & C) http://tmtms.hatena blog.com http://twitter.com/tmtms å¥½ããªã‚‚ã® Ruby, MySQL, Linux Mint, Emacs, Git Sequelã®ã™ã™ã‚ - ã€œç§ãŒSQLã‚’å«Œã„ãªç†ç”±ã€œ Powered by Rabbit 2.0.7
supermomonga 2013/06/04
sequel

sql

ruby
ãƒªãƒ³ã‚¯
Rails 3&4: Arel::Tableã‚’ä½¿ã£ã¦ãªã‚‹ã¹ãç”Ÿã®SQLã‚’æ›¸ã‹ãšã«æ¸ˆã¾ã™æ–¹æ³•ï½œTechRacho by BPSæ ªå¼ä¼šç¤¾
Railsã§ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ã„ã‚‹ã¨SQLã‚’ç›´æŽ¥è¨˜è¿°ã™ã‚‹æ©Ÿä¼šãŒæ„å¤–ã¨å¤šã„ã®ã§ã€ ãªã‚‹ã¹ãRubyã‚‰ã—ãæ›¸ãæ–¹æ³•ãŒãªã„ã‹èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ ORãªã©ã‹ãªã‚ŠåŸºæœ¬çš„ãªæ§‹æ–‡ã§ã‚‚arel_tableã‚’ä½¿ã†å¿…è¦ãŒã‚ã‚‹ã®ã§ã™ãã€‚ ã¨ã„ã†ã‚ã‘ã§ã€Arel::Table ã‚’ä½¿ã£ã¦ã¿ã¾ã—ãŸã€‚ å‹•ä½œç¢ºèªç’°å¢ƒã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ ruby: 1.9.3-p392 Rails: 3.2.13 arel: 3.0.2 MySQL: 5.1.65 æ¤œç´¢æ¡ä»¶ã‚’ORã§ç¹‹ã’ãŸã„ åŸºæœ¬çš„ãªæ§‹æ–‡ã§ã™ãŒSQLã‚’ç›´æŽ¥è¨˜è¿°ã™ã‚‹å ´åˆãŒå¤šã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ User.where("name = ? OR name = ?", "å¤ªéƒŽ", "èŠ±å").to_sql #=> "SELECT `users`.* FROM `users` WHERE (name = 'å¤ªéƒŽ' OR name = 'èŠ±å')" ãªã‚‹ã¹ãRubyã§æ›¸ã“ã†ã¨ã™ã‚‹ã¨ã“ã†ãª
supermomonga 2013/05/27
Rails

SQL

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

å¢—ç”°

sql

programming
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
supermomonga 2012/09/13
SQL

MySQL

PostgreSQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

RDBMS
ãƒªãƒ³ã‚¯
ã“ã“ã¾ã§ã‚„ã‚‹ã‹ã€‚SQLiteã‚’JavaScriptã«å¤‰æ›Â·SQL.js MOONGIFT
SQL.jsã¯SQLiteã‚’Emscriptenã‚’ä½¿ã£ã¦JavaScriptåŒ–ã—ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ SQL.jsã¯Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§ä½¿ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚Emscriptenã‚’ä½¿ã£ã¦SQLiteã‚’JavaScriptã«å¤‰æ›ã—ãŸé¢ç™½ã„ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ ãƒ‡ãƒ¢ã§ã™ã€‚ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒªã‚¢ã«æ›¸ã‹ã‚ŒãŸSQLã‚’å®Ÿè¡Œã§ãã¾ã™ã€‚ å®Ÿè¡Œã—ãŸçµæžœã§ã™ã€‚æœ€çµ‚çš„ãªçµæžœã ã‘ãŒå‡ºåŠ›ã•ã‚Œã¦ã„ã¾ã™ã€‚SELECTã®çµæžœã¯JSONãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦å–å¾—ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã‚‚ã¡ã‚ã‚“æ™®é€šã«SQLãŒä½¿ãˆã¾ã™ã€‚ æ—¥æœ¬èªžã¯å‡ºåŠ›æ™‚ã¯åŒ–ã‘ã¦ã—ã¾ã„ã¾ã—ãŸãŒãƒ‡ãƒ¼ã‚¿ä¸Šã¯å•é¡Œãªã„ã¨æ€ã‚ã‚Œã¾ã™ã€‚ SQL.jsã¯SQLiteãŒãã®ã¾ã¾JavaScriptã«ãªã£ã¦ã—ã¾ã£ãŸã‚ˆã†ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚æ…£ã‚ŒãŸä½¿ã„å‹æ‰‹ã§SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã§ãã¦ã—ã¾ã†ã®ã¯é¢ç™½ãã†ã§ã™ã€‚ãªãŠç¾çŠ¶Google Chromeã‚„Firefoxã«ã—ã‹æœ€é©åŒ–ã•ã‚Œã¦ã„ã¾ã›ã‚“ã€‚ SQL.jsã¯
supermomonga 2012/03/17
sqlite

javascript

ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢

SQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã‚«ãƒ©ãƒ ã®å€¤ãŒé‡è¤‡ã—ã¦ã„ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æŠ½å‡ºã™ã‚‹SQL - ãŠã¯ã‚ˆã†ãƒãƒƒãƒ•ã‚¡ãƒãƒ¼
å€¤ãŒé‡è¤‡ã—ãŸãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æŠ½å‡ºã™ã‚‹SQLã‚’çµæ§‹é »ç¹ã«ä½¿ã†ã®ã§ãƒ¡ãƒ¢ SELECT å•†å“ID FROM å•†å“ãƒžã‚¹ã‚¿ GROUP BY å•†å“ID HAVING COUNT(å•†å“ID)<>1 HAVINGã£ã¦ã“ã®æ™‚ãã‚‰ã„ã—ã‹ä½¿ã£ãŸäº‹ãªã„ã‚“ã ã‘ã©ã€ ã€Œé›†è¨ˆé–¢æ•°ã®çµæžœã‚’æ¡ä»¶ã¨ã—ãŸçµžè¾¼ã¿ã€ã£ã¦äº‹ã‚‰ã—ã„ã€‚ å£²ä¸ŠãŒ1000ä»¥ä¸Šã®å•†å“IDã‚’æŠ½å‡ºã™ã‚‹ãªã‚“ã¦ã®ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ã«ã‚„ã‚‹ã‚ˆã†ã§ã™ã€‚ SELECT å•†å“ID, SUM(å€¤æ®µ) FROM å•†å“ãƒžã‚¹ã‚¿ GROUP BY å•†å“ID HAVING SUM(å€¤æ®µ)>1000
supermomonga 2011/08/15
SQL
ãƒªãƒ³ã‚¯
ç´›ã‚Œã‚‚ãªã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ã€ŒSQL Server Compact Editionã€ï¼šITpro
ç±³MicrosoftãŒå…ˆæ—¥ï¼Œã€ŒSQL Server Compact Editionã€ã‚’å®Œæˆã•ã›ãŸã€‚ã“ã‚Œã¯ï¼Œãƒ¢ãƒã‚¤ãƒ«ãƒ»ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚„ï¼Œã€ŒãŸã¾ã«ã—ã‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã—ãªã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã€ã‚’ã‚¿ãƒ¼ã‚²ãƒƒãƒˆã¨ã—ãŸçµ„è¾¼åž‹ã®SQL Serverã§ã‚ã‚‹ã€‚ ã‚·ã‚§ã‚¤ã‚¯ã‚¹ãƒ”ã‚¢ã®è¨€è‘‰ã«ï¼Œã€Œãƒãƒ©ã¯ä»–ã®ã©ã‚“ãªåå‰ã§ã‚ã‚ã†ã¨ï¼Œãã®é¦™ã‚Šã®ç´ æ™´ã‚‰ã—ã•ã«å¤‰ã‚ã‚Šã¯ãªã„ã€ã¨ã„ã†ã®ãŒã‚ã‚‹ã€‚ãã‚Œãªã‚‰SQL Server Compact Editionã¯ã©ã‚“ãªåå‰ã§ã‚ã‚ã†ã¨ï¼Œç´›ã‚Œã‚‚ãªã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã§ã‚ã‚Šï¼ŒMicrosoftãŒã€ŒãŸã¾ã«ã—ã‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã—ãªã„ã€ã‚ˆã†ãªãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚‚å«ã‚ã¦ï¼Œã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒžãƒ¼ã‚±ãƒƒãƒˆã‚’æ”»ç•¥ã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹å§¿å‹¢ã®è¡¨ã‚Œã ã¨è¨€ãˆã‚‹ã€‚ MicrosoftãŒæºå¸¯æ©Ÿå™¨å‘ã‘ã«åˆã‚ã¦ãƒªãƒªãƒ¼ã‚¹ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã¯ã€ŒSQL Server 2000 Windows CE Editionï¼ˆSQL Server CEï¼‰ã€ã ã£
supermomonga 2010/10/17
SQL Server Compact

SQL Server

SQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
æ¥µå°SQL Server Compactã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ãƒ—ãƒªã‚’ãŠæ‰‹è»½ä½œæˆï¼ˆ1/3ï¼‰ - ï¼ IT
çš†ã•ã‚“ã€ã“ã‚“ã«ã¡ã¯ã€‚ãƒãƒ–ã§ã™ã€‚ ä»Šå›žã¯ã€SQL Server Compact 3.5ã‚’åˆ©ç”¨ã—ãŸWindowsã‚¢ãƒ—ãƒªã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ï¼ˆã‚¢ãƒ—ãƒªã¯ã€Œã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã®ç•¥ï¼‰ã€‚ SQL Server Compact 3.5ã¨ã¯ã€Windowsã‚¢ãƒ—ãƒªã‚„ã€ãƒ¢ãƒã‚¤ãƒ«ãƒ»ã‚¢ãƒ—ãƒªã§ã®åˆ©ç”¨ã«å‘ã„ãŸå°ã•ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã§ã™ã€‚æœ¬æ¥ã¯çµ„ã¿è¾¼ã¿ç”¨é€”ã§ä½œã‚‰ã‚ŒãŸã‚‚ã®ãªã®ã§ã™ãŒã€ã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ³ã®Windows ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ãƒ»ã‚¢ãƒ—ãƒªãªã©ã§ã“ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã€ã¨ã¦ã‚‚ç°¡å˜ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ãƒ—ãƒªãŒä½œæˆã§ãã¾ã™ã€‚æ‰‹è»½ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ãƒ—ãƒªé–‹ç™ºã‚’æ¥½ã—ã‚“ã§ã¿ã¾ã›ã‚“ã‹ï¼Ÿ ãœã²æœ¬ç¨¿ã‚’èªã¿ãªãŒã‚‰å®Ÿéš›ã«ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ä½œã‚Šã€è‡ªåˆ†ã®æ‰‹ã§å‹•ã‹ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã¯ã€C#ã¨VBï¼ˆVisual Basicï¼‰ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ä»Šå›žã¯ã€ç‰¹åˆ¥ã«VBã®ã‚³ãƒ¼ãƒ‰ã‚‚ç”¨æ„ã—ã¾ã—ãŸã€‚ã“ã‚Œã¯ã€SQL Server Compact 3.5ã®ã‚¿ãƒ¼ã‚²ãƒƒãƒˆ
supermomonga 2010/10/17
SQL Server

SQL Server Compact

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

SQL

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
1