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

nemu90kWw id:nemu90kWw

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

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

ãƒ ãƒƒã‚¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¾¹åº•æ”»ç•¥ã€ - MySQL/Redis/MongoDB/Redshift
æœ€è¿‘ç™ºå£²ã•ã‚ŒãŸæŠ€è¡“è©•è«–ç¤¾ã®ãƒ ãƒƒã‚¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¾¹åº•æ”»ç•¥ã€ã«å¯„ç¨¿ã—ã¾ã—ãŸã€‚ ã“ã®æœ¬ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãŸã‚ã®æœ¬ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€SQLã€MySQLã€Redisã€Mongo DBã€Redshiftã¨ã„ã†ä»£è¡¨çš„ãªè¦ç´ æŠ€è¡“ã«ã¤ã„ã¦ã®ã¾ã¨ã‚ã¨ãªã£ã¦ã„ã¾ã™ã€‚å„ãƒ—ãƒãƒ€ã‚¯ãƒˆ(MySQLã€Redisã€Mongo DBã€Redshift)ã«ã¤ã„ã¦ã¯ã€ç¾å ´ã§å®Ÿéš›ã«æœ¬æ ¼çš„ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹æ–¹ã€…ã«ã‚ˆã‚‹è¨˜äº‹ãªã®ã§å¤§ã„ã«å‚è€ƒã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç§ã¯å†’é ã®ã¾ã¨ã‚è¨˜äº‹ã‚’å¯„ç¨¿ã—ã¾ã—ãŸã€‚è©³ç´°ã¯ãœã²ãŠæ‰‹ã«å–ã£ã¦èªã‚“ã§ãã ã•ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ã“ã“ã§ã‚‚è‡ªåˆ†ãŒå„æŠ€è¡“ã‚’ç¾æ™‚ç‚¹ã§ã©ã®ã‚ˆã†ã«ã¨ã‚‰ãˆã¦ã„ã‚‹ã‹ã€æœ¬ã§ã¯ã„ã•ã•ã‹æ›¸ãã¥ã‚‰ã„å†…å®¹ã«ã¤ã„ã¦ã€æœ€è¿‘æµè¡Œã‚Šã®è¨€è‘‰ã§ã‚‚ã‚ã‚‹ã€ŒæŠ€è¡“çš„è² å‚µã€ã¨ã„ã†è¦³ç‚¹ã‚‚è¸ã¾ãˆã¦æ›¸ã„ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ ãƒ»MySQL (RDBMS) ç§ã¯MySQLã®ä¸ã®äººã§ã‚‚ã‚ã‚Šã¾ã—ãŸã—ã€ã“ã‚Œã¾ã§è‡³ã‚‹ã¨ã“ã‚ã§è©±ã—ã¦ããŸã®ã§çœç•¥ã—ã¾ã™
nemu90kWw 2014/03/24
ã–ã£ãã‚Š

SQL

æ–‡ç«

åºƒå‘Š

ä»•äº‹
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒã‚™ãƒ¼æœªçµŒé¨“è€…ã‹ã‚™ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚±ã‚™ãƒ¼ãƒ ã‚’é€šã—ã¦çŸ¥ã£ãŸã‚µãƒ¼ãƒã‚™ãƒ¼ã®äº‹
2014/2/8ã«è¡Œã£ãŸã‚²ãƒ¼ãƒ ã‚µãƒ¼ãƒå‹‰å¼·ä¼šã§ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§ã™ã€‚ ã‚µãƒ¼ãƒãƒ¼æœªçµŒé¨“è€…ãŒã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚’é€šã—ã¦çŸ¥ã£ãŸã‚µãƒ¼ãƒãƒ¼ã®äº‹ã€‚ å¤±æ•—çµŒé¨“ã‚’å…ƒã«ä½•æ•…ä»ŠãŒã“ã†ãªã£ã¦ã„ã‚‹ã‹ã¨ã„ã†ã®ã‚’è©°ã‚è¾¼ã¿ã¾ã—ãŸã€‚ åˆå¿ƒè€…ã€œä¸ç´šè€…å‘ã‘å‹‰å¼·ä¼šã ã£ãŸã®ã§ã€ãªã‚‹ã¹ãéžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚ã‚¤ãƒ¡ãƒ¼ã‚¸ã§ä¼ã‚ã‚‹ã‚ˆã†ã«ã¡ã‚‡ã£ã¨ã ã‘å¿ƒãŒã‘ã¦ã¾ã™ã€‚Read less
nemu90kWw 2014/02/10
DB

é–‹ç™º

SQL
ãƒªãƒ³ã‚¯
swee.to
This domain name is parked at Register.TO Domain Registrar.
nemu90kWw 2013/01/27
CGI

SQL

Webåˆ¶ä½œ
ãƒªãƒ³ã‚¯
ãƒ©ãƒ³ã‚ãƒ³ã‚°ã‚’å–å¾—ã™ã‚‹SQL | Sun Limited Mt.
ãƒ©ãƒ³ã‚ãƒ³ã‚°ã‚’å–å¾—ã™ã‚‹SQL ã§ã™ã€‚ åŒã˜ã‚¹ã‚³ã‚¢ã®å ´åˆã¯åŒã˜é †ä½ã«ã™ã‚‹ãªã©ã®å¿…è¦ãŒã‚ã‚‹ãŸã‚çµæ§‹é¢å€’ã§ã™ãŒã€ ä¸‹è¨˜SQL ã§ã‚¤ãƒƒãƒ‘ãƒ„ã§å–å¾—ã§ãã¾ã™ã€‚ å®Ÿéš›ã«æºå¸¯ã‚²ãƒ¼ãƒ ã®ãƒ©ãƒ³ã‚ãƒ³ã‚°ã‚’å–å¾—ã™ã‚‹ã®ã«ä½¿ç”¨ã—ã¦ã„ã‚‹SQLã§ã™ã€‚ ranking ãƒ†ãƒ¼ãƒ–ãƒ« CREATE TABLE ranking ( id bigint(20) NOT NULL auto_increment, name varchar(20) NOT NULL, score bigint(20) NOT NULL, ); SQL SELECT r1.name, r1.score, (SELECT count(r2.score) FROM ranking as r2 WHERE r2.score>r1.score)+1 as rank FROM ranking as r1 ORDER BY r1.score DESC LIMIT 10; r
nemu90kWw 2012/01/17
SQL
ãƒªãƒ³ã‚¯
NoSQLãƒ¡ãƒ¢(Hishidama's NoSQL(KVS) Memo)
ã¡ãªã¿ã«ã€MySQLãƒ»PostgreSQLã¯RDBã®åå‰ã€PL/SQLã¯Oralceã®ç‹¬è‡ªè¨€èªžã€psqlã¯PostgreSQLã®å¯¾è©±åž‹ãƒ„ãƒ¼ãƒ«ï¼ˆSQL*Plusã¯Oracleã®å¯¾è©±åž‹ãƒ„ãƒ¼ãƒ«ï¼‰ã€‚ åˆ†æ•£Key/Valueã‚¹ãƒˆã‚¢ã®ç‰¹å¾´ ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼ã‚¹ãƒˆã‚¢ï¼ˆkey/value storeãƒ»KVSï¼‰ã¯ã€ã‚ãƒ¼ï¼ˆkeyï¼‰ã‚’æŒ‡å®šã—ã¦å€¤ï¼ˆvalueï¼‰ã‚’ä¿æŒãƒ»å–å¾—ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€‚ ã£ã¦è¨€ã†ã¨ã€ã©ã®DBã‚‚ãã†ã˜ã‚ƒã‚“ï¼(çˆ†) KVSã‚‚RDBã‚‚â€œã©ã¡ã‚‰ã‚‚DBã ã‹ã‚‰â€ã¨ã„ã†ç†ç”±ã§æ¯”è¼ƒã•ã‚Œã‚‹ã‘ã‚Œã©ã‚‚ã€æ§‹é€ ã‚„å‡ºæ¥ã‚‹äº‹ã‚’è€ƒãˆã‚‹ä¸Šã§ã¯ã€KVSã¯ãƒžãƒƒãƒ—ï¼ˆé€£æƒ³é…åˆ—ï¼‰ã¨å¯¾æ¯”ã—ã¦è€ƒãˆã‚‹æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã¨æ€ã†ã€‚ ä¹±æš´ã«è¨€ã†ã¨ã€KVSã¯ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ä¸Šã«ç½®ã‹ã‚Œã¦ã„ã‚‹ãƒžãƒƒãƒ—ã§ã‚ã‚‹ã€‚ ï¼ˆå¤ãã‹ã‚‰ã“ã®æ¥ç•Œã«ã„ã‚‹æ–¹ã¯ã€ã€ŒKVSã¯ISAMãƒ»VSAMã ã€ã¨ãŠã£ã—ã‚ƒã£ã¦ã„ã‚‹æ¨¡æ§˜ã€‚ç¢ºã‹IBMã®æ±Žç”¨æ©Ÿï¼ˆãƒ¡ã‚¤ãƒ³ãƒ•ãƒ¬ãƒ¼ãƒ ï¼‰ã§ä½¿ã‚ã‚Œã¦ã„ãŸç”¨èªžã ã£ãŸã‹ãªï¼‰
nemu90kWw 2011/11/08
DB

SQL
ãƒªãƒ³ã‚¯
Google Mapsã¨MySQLã®é€£æº
ã“ã‚“ã«ã¡ã¯ã€ã‚¢ã‚·ã‚¢ãƒ«ã®ä¸å·ã§ã™ã€‚ Google Mapsã«è¡¨ç¤ºã™ã‚‹æƒ…å ±ã‚’MySQLã®geometryåž‹ã§æ‰±ã†æ–¹æ³•ã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ Google Mapsã®ã‚ã‚‹åœ°ç‚¹ã«ãƒžãƒ¼ã‚«ãƒ¼ã‚’è¡¨ç¤ºã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒã‚ã‚‹å ´åˆã€ ç·¯åº¦ãƒ»çµŒåº¦ã®æƒ…å ±ã§åœ°ç‚¹ã«è¡¨ç¤ºã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ãŒã€ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã“ã®æƒ…å ±ã‚’ä¿å˜ã™ã‚‹å ´åˆã€lat(float), lng(float)ã¨ãã‚Œãžã‚Œã‚«ãƒ©ãƒ ã«ä¿å˜ã™ã‚‹æ–¹æ³•ã‚‚ã‚ã‚‹ã®ã§ã™ãŒã€ã“ã®æ–¹æ³•ã§ã¯å„ãƒ‡ãƒ¼ã‚¿ã®ä½ç½®ã®é–¢ä¿‚ãŒéžå¸¸ã«æ‰±ã„ã«ãããªã‚Šã¾ã™ã€‚ Google Mapsã§è¡¨ç¤ºã•ã‚Œã¦ã„ã‚‹ç¯„å›²å†…ã®ãƒ‡ãƒ¼ã‚¿ã®ã¿å–å¾—ã—ãŸã„å ´åˆã‚„ã€ ã‚ã‚‹åœ°ç‚¹ã‹ã‚‰è¿‘ã„é †ã«å–å¾—ã™ã‚‹å ´åˆãªã©ã«é¢å€’ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ãã“ã§ã€MySQL4.1ä»¥é™ã§ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ç©ºé–“æƒ…å ±ã‚’æ‰±ã†æ©Ÿèƒ½ã®ã€Œgeometryã€åž‹ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ã€ŒMySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 10 MySQL ã«ãŠã‘ã‚‹ç©ºé–“æƒ…å ±ã®æ©Ÿèƒ½(æ—¥æœ¬èªž)ã€ ã€Œ
nemu90kWw 2010/10/23
SQL
ãƒªãƒ³ã‚¯
10åˆ†ã§ä½œã‚‹Railsã‚¢ãƒ—ãƒª for Windows - masuidrive
Windowsã«Ruby on Railsã¨MySQLã‚’å…¥ã‚Œç’°å¢ƒã‚’ä½œã‚Šã€ãã®ä¸Šã§ç°¡å˜ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹ã¾ã§ã‚’è¨˜éŒ²ã—ãŸãƒ ãƒ¼ãƒ“ãƒ¼ã€‚ç·¨é›†ãƒŠã‚·ã§ãƒ›ãƒ³ãƒˆã«10åˆ†ä»¥å†…ã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ§‹ç¯‰ã—ã¦ã¾ã™ã€‚ è©³ã—ãã¯ã€2005å¹´11æœˆ18æ—¥ç™ºå£²ã®æŠ€è¡“è©•è«–ç¤¾ SoftwareDesign 2005å¹´12æœˆå·ã§è§£èª¬äºˆå®šã§ã™ã—ã¾ã—ãŸã€‚ Rails+MySQLã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç·¨ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç·¨ è¿½åŠ æƒ…å ± Web Developer Study @Sapporo - 2005/11/19 Rails + Selenium - OSC2006 Do 2006/07/15 æ›´æ–°æƒ…å ± 2006/07/15: OSC2006 Doã§ä½¿ã£ãŸè³‡æ–™ Rails + Seleniumã‚’å…¬é–‹ 2005/11/19: Web Developer Study @Sapporoã§ä½¿ã£ãŸè³‡æ–™ã‚’å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ 2005/1
nemu90kWw 2010/10/23
Ruby

Rails

SQL

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