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

rx7 id:rx7

SQLã«é–¢ã™ã‚‹rx7ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

sql.js
sql.js is an SQL library for javascript containing a version of SQLite compiled for the web.
rx7 2020/11/08
JavaScript

SQL
ãƒªãƒ³ã‚¯
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç–ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç– ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã®æ¾æµ¦éš¼äººã•ã‚“ã«ã€8ã¤ã®ã€ŒSQLãŒé‡ãŸããªã‚‹åŽŸå› ã¨ãã®å¯¾ç–ã€ã‚’èžãã¾ã—ãŸã€‚ã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚‹ã‚ˆã†ãªã€Œå•é¡Œã®ã‚ã‚‹SQLã€ã‚’å›žé¿ã™ã‚‹ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã³ã¾ã—ã‚‡ã†ã€‚ ãƒ‡ãƒ¼ã‚¿ã®æ“ä½œã‚„å®šç¾©ã‚’ã™ã‚‹è¨€èªžã€ŒSQLã€ã¯ã€ã©ã®ã‚ˆã†ãªé ˜åŸŸã‚’æ‹…ã†ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦ã‚‚å¿…ä¿®ç§‘ç›®ã§ã™ã€‚ã—ã‹ã—ã€ãã®ä»•æ§˜ã‚’ãã¡ã‚“ã¨ç†è§£ã—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å„ªã‚ŒãŸSQLã‚’æ›¸ã‘ã‚‹æ–¹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚å•é¡Œã®ã‚ã‚‹SQLã‚’æ›¸ã„ã¦ã—ã¾ã„ã€çŸ¥ã‚‰ã¬é–“ã«ãã‚ŒãŒã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã†äº‹æ…‹ã¯ã‚ˆãç™ºç”Ÿã—ã¾ã™ã€‚ ã§ã¯ã€ã©ã†ã™ã‚Œã°ãã†ã—ãŸäº‹æ…‹ã‚’å›žé¿ã§ãã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã®ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã¶ãŸã‚ã€ä»Šå›žã¯ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã§ã‚ã‚Šã€è‡ªèº«ã‚‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚ã‚ã‚‹æ¾æµ¦éš¼äººï¼ˆã¾ã¤ã†ã‚‰ãƒ»ã¯ã‚„ã¨ï¼@dblmktï¼‰ã•ã‚“ã«8ã¤
rx7 2017/06/26
ä¸èº«ã®å‰ã«ã€ç”»åƒã®ç´ æã¨ã—ã¦ç§€é€¸...

SQL
ãƒªãƒ³ã‚¯
åˆ†æžSQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ« - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
SQLã€æ›¸ã„ã¦ã¾ã™ã‹ï¼Ÿ ã“ã¨å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®åˆ†é‡Žã«ãŠã„ã¦ã¯SQLã¯ã‚‚ã¯ã‚„æ¨™æº–ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã§ã‚ã‚Šã€ åˆ†æžã‚„ã‚‰ãƒãƒƒãƒã‚„ã‚‰ã«é–¢ã‚ã£ã¦ã„ã‚‹çš†æ§˜ã¯æ—¥ã€…å¤§é‡ã®SQLã‚¯ã‚¨ãƒªãƒ¼ã‚’ç”Ÿç”£ã—ã¦ã„ã‚‹ã“ã¨ã¨æ€ã„ã¾ã™ã€‚ ãã“ã§ã¡ã‚‡ã£ã¨æ°—ã«ãªã‚‹ã®ãŒã€ SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ«ã£ã¦ã©ã†ã™ã‚‹ã®ãŒä¸€èˆ¬çš„ãªã‚“ã ã£ã‘â€¦â€¦ï¼Ÿ ã¨ã„ã†ç‚¹ã§ã™ã€‚ ã‚¤ãƒžãƒ‰ã‚ã¯SQLãªã‚“ã¦O/R mapperã«åã‹ã›ã‚‹ã“ã¨ãŒå¤šã„ã‹ã‚‰ãªã®ã‹ã€ ãã‚Œã¨ã‚‚ã‚³ãƒ¼ãƒ‰ã‚’åºƒã„ç¯„å›²ã§å…±æœ‰ã™ã‚‹ã“ã¨ãŒãã‚‚ãã‚‚ãªã„ã‹ã‚‰ã‹ã€ SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ«ã«ã¤ã„ã¦è¦‹èžãã™ã‚‹ã“ã¨ã¯ä»–ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã«æ¯”ã¹ã‚‹ã¨ã ã„ã¶å°‘ãªãã€ ã„ã¾ã„ã¡æ±ºå®šç‰ˆã¨è¨€ãˆã‚‹ã‚¹ã‚¿ã‚¤ãƒ«ãŒãªã„ãªã¨æ„Ÿã˜ã¦ã„ã¾ã™ã€‚ ãã‚“ãªã‚ã‘ã§æœ¬æ—¥ã¯ã€SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ«ã«ã¤ã„ã¦ã®æ„è˜ã‚’æ´»ç™ºåŒ–ã•ã›ã‚‹ã¹ãã€ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã‚ãŸã—ï¼ˆé’æœ¨ï¼‰ãŒä½¿ã£ã¦ã„ã‚‹ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã‚¿ã‚¤ãƒ«ã‹ã‚‰ç‰¹å¾´çš„ãªç‚¹ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç‰¹ã«ã€åˆ†æž
rx7 2016/11/09
SQL
ãƒªãƒ³ã‚¯
Nyle Engineering Blog
OpenAIã®Whisper æ–‡å—èµ·ã“ã—25MBåˆ¶é™ã‚’è§£æ±ºã™ã‚‹PHP, Laravel, ffmpegã‚’ä½¿ã£ãŸãƒ•ã‚¡ã‚¤ãƒ«åˆ†å‰²ã®ä¾‹ OpenAIã®APIã‚’ä½¿ã£ãŸéŸ³å£°ã®æ–‡å—èµ·ã“ã—ã¯ã€ä»Šã‚„å¤šãã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§åˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯ã€ç‰¹ã«Whisper æ–‡å—èµ·ã“ã—ã®25MBåˆ¶é™ã«ç„¦ç‚¹ã‚’å½“ã¦ã€PHP, Laravel, ffmpegâ€¦
rx7 2016/07/07
SQL
ãƒªãƒ³ã‚¯
ãƒ‡ã‚£ãƒ¬ã‚¯ã‚¿ãƒ¼ãŒSQLã‚’ä½¿ãˆã¦ã‚ˆã‹ã£ãŸè©± - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€‚ãƒ‡ã‚£ãƒ¬ã‚¯ã‚¿ãƒ¼ã®å·åŽŸç”°ã§ã™ã€‚ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ãŠæ°—ã«å…¥ã‚Šãƒ¬ã‚·ãƒ”ã‚’ä¿å˜ã™ã‚‹ã€ŒMYãƒ•ã‚©ãƒ«ãƒ€ã€ã®ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºã‚„ã€ä¿å˜ãƒ»è¨˜éŒ²ã«é–¢ã™ã‚‹æ–°è¦ã‚µãƒ¼ãƒ“ã‚¹ã®æ¤œè¨Žãƒ»é–‹ç™ºã‚’æ‹…å½“ã—ã¦ã„ã¾ã™ã€‚ ãƒ‡ã‚£ãƒ¬ã‚¯ã‚¿ãƒ¼ã®ä»•äº‹ã¯æ§˜ã€…ã‚ã‚Šã¾ã™ãŒã€ä»Šå›žã¯ç§ãŒèº«ã«ã¤ã‘ãŸã“ã¨ã§ä»•äº‹é ˜åŸŸãŒåºƒãŒã£ãŸï¼ã¨æ„Ÿã˜ã¦ã„ã‚‹SQLã«ã¤ã„ã¦ãŠè©±ã—ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã„ããªã‚Šã§ã™ãŒã€SQLãŒä½¿ãˆã¦ã‚ˆã‹ã£ãŸç‚¹ã‚’ã¾ã¨ã‚ã‚‹ã¨ä»¥ä¸‹ã§ã™ã€‚ ã‚ˆã‹ã£ãŸã“ã¨ æ•°å€¤æŠ½å‡ºã‹ã‚‰åˆ†æžã¾ã§è‡ªå·±å®Œçµ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã®ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚¹ãƒ ãƒ¼ã‚ºã« ä»•äº‹ãŒå¢—ãˆã¦ã„ãã†ã§å®Ÿã¯åŠ¹çŽ‡ã‚¢ãƒƒãƒ— å‘¨å›²ã®çŸ¥çš„å¥½å¥‡å¿ƒã‚’åˆºæ¿€ ãã‚Œãžã‚Œå…·ä½“ä¾‹ã‚’äº¤ãˆã¦ãŠè©±ã—ã¾ã™ã€‚ æ•°å€¤æŠ½å‡ºã‹ã‚‰åˆ†æžã¾ã§è‡ªå·±å®Œçµ äº‹ä¾‹ï¼‘ï¼šãƒã‚°æ§‹é€ ã‚’ç†è§£ã§ãå¾Œã®ä»•äº‹ãŒã‚¹ãƒ ãƒ¼ã‚ºã« æ˜¨å¹´ã€ã‚¢ãƒ—ãƒªã®ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºã‚’æ‹…å½“ã—ãŸéš›ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®è¨å®šã—ãŸãƒã‚°ãŒã€å®Ÿéš›ã«é€ä¿¡ã•ã‚Œã‚‹ã‹ã©ã†ã‹ã‚’äº‹å‰ãƒã‚§ãƒƒã‚¯ã‚’ã—ã¾ã—ãŸ*1ã€‚ ã‚¢ãƒ—ãƒªã®ãƒªãƒªãƒ¼ã‚¹ã¯ã‚¿ã‚¤ãƒŸãƒ³ã‚°ãŒæ±ºã‚ã‚‰ã‚Œ
rx7 2016/07/06
SQL

é–‹ç™º
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
rx7 2015/12/10
SQL

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

DB
ãƒªãƒ³ã‚¯
RDB - å®Ÿä¾‹ã§å¦ã¶ã€JOIN (NLJ) ãŒé…ããªã‚‹ç†å±ˆã¨å¯¾å‡¦æ³• - Qiita
"Nested Loop Joinã—ã‹å–ã‚Šä¸Šã’ã¦ç„¡ã„ã®ã«ã‚¿ã‚¤ãƒˆãƒ«ãŒå¤§ãã™ãŽãªã„ã‹" ã¨æŒ‡æ‘˜ã‚’é ‚ã„ãŸã®ã§ã€ã‚¿ã‚¤ãƒˆãƒ«ã‚’ä¿®æ£ã—ã¾ã—ãŸã€‚Merge Joinã¨Hash Joinã®ã“ã¨ã¯ã¾ãŸä»Šåº¦æ›¸ã“ã†ã¨æ€ã„ã¾ã™ã€‚ ã€ŒJOINã¯é…ã„ã€ã¨ã‚ˆãè¨€ã‚ã‚Œã¾ã™ã€‚ç‰¹ã«RDBã‚’ä½¿ã„å§‹ã‚ã¦é–“ãŒãªã„å†…ã«ãã†ã„ã†è¨€èª¬ã«è§¦ã‚ŒãŸçµæžœã€ŒJOIN=æ‚ªã€ã¨ã„ã†èªè˜ã§å›ºå®šåŒ–ã•ã‚Œã¦ã—ã¾ã£ã¦ã„ã‚‹äººã‚‚å¤šã„ã‚ˆã†ã«æ„Ÿã˜ã¦ã„ã¾ã™ã€‚ ãŸã—ã‹ã«ã€JOINã‚’å«ã‚€ã‚ˆã†ãªSELECTæ–‡ã¯ã€å«ã¾ãªã„ã‚‚ã®ã«æ¯”ã¹ã¦é‡ãŸããªã‚‹å‚¾å‘ãŒã‚ã‚‹ã“ã¨ã¯äº‹å®Ÿã§ã™ã€‚ã¾ãŸã€æœ¬è³ªçš„ã«å•ã„åˆã‚ã›ãŸã„å†…å®¹ãŒè¤‡é›‘ã§ã€å¯¾å‡¦ã™ã‚‹ã“ã¨ãŒé›£ã—ã„ã‚‚ã®ã‚‚å˜åœ¨ã—ã¾ã™ã€‚ã—ã‹ã—ã€RDBã®ä¸ã§ä¸€ä½“ã©ã†ã„ã†ã“ã¨ãŒèµ·ãã¦ã„ã‚‹ã®ã‹ã‚’çŸ¥ã‚Šã€ãã‚Œã«åŸºã„ã¦å¯¾å‡¦ã™ã‚Œã°é«˜é€ŸåŒ–ã§ãã‚‹ã“ã¨ã‚‚å°‘ãªããªã„ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ æœ¬ç¨¿ã§ã¯ã€JOINã®å†…éƒ¨å‹•ä½œã‚’è§£èª¬ã—ãŸä¸Šã§ã€Webã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½œã£ã¦ã„ã‚‹ã¨ã‚ˆãå‡ºã¦ãã‚‹JOIN SQLã‚’ä¾‹é¡Œã«
rx7 2015/07/12
DB

SQL
ãƒªãƒ³ã‚¯
MySQLãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆå…¥é–€
2015/04/30 schoo WEB-campus https://schoo.jp/class/2218 Read less
rx7 2015/05/01
MySQL

DB

SQL

è³‡æ–™
ãƒªãƒ³ã‚¯
é–‹ç™ºè€…ã®ãŸã‚ã®SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å…¨ã¦
å‰æ›¸ã - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆã¯ãªãœé–‹ç™ºè€…ã®ã‚¿ã‚¹ã‚¯ãªã®ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã® å†…éƒ¨æ§‹é€ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ä½•ã«ä¼¼ã¦ã„ã‚‹ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ - äºŒé‡é€£çµãƒªã‚¹ãƒˆ æ¤œç´¢ ãƒ„ãƒªãƒ¼(Bãƒ„ãƒªãƒ¼) - ãƒãƒ©ãƒ³ã‚¹æœ¨ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆI - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é…ãã™ã‚‹2ã¤ã®åŽŸå› where å¥ - æ¤œç´¢ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ãŸã‚ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆ ç‰ä¾¡ æ¼”ç®—å - ä¸€è‡´ã™ã‚‹ã‚ãƒ¼ã®æ¤œç´¢ ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ã„æ–¹ã‚’ç¢ºèª è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - è¤‡æ•°åˆ—ã«å¯¾ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆII - å‰ã®å•é¡Œç‚¹ãŒå†ã³ é–¢æ•° - whereå¥ã® ä¸ã§ã®é–¢æ•° å¤§æ–‡å—ãƒ»å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ æ¤œç´¢ - UPPERã¨ LOWER ãƒ¦ãƒ¼ã‚¶å®šç¾© é–¢æ•° - é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åˆ¶é™ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚ŠéŽãŽ - å†—é•·æ€§ã®æŽ’é™¤æ³• ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿åŒ– ã‚¯ã‚¨ãƒª - ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ãŸã‚ã« ç¯„å›² æ¤œ
rx7 2014/10/21
SQL

DB
ãƒªãƒ³ã‚¯
ã¨ã‚ã‚‹è¨ºæ–å“¡ã¨SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³
7. é€šå¸¸ã®Webã‚µãƒ¼ãƒã¨ã®é€šä¿¡ <html> <body> <form action=â€œregisterâ€ method=â€œPOSTâ€> æ°å:vultest<BR> ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹:vulte [email protected]<BR> æ€§åˆ¥:ç”·<BR> ï¼ˆä»¥ä¸‹ç•¥ï¼‰ </html> POST /confirm.php HTTP/1.1 Host: example.jp ï¼ˆä»¥ä¸‹ç•¥ï¼‰ Cookie: PHP SESSID=xxxxxxxxxx name=vultest&mail=vultest%40example.jp&gender=1 HTTP Response HTTP Request 8. è‰²ã€…ã„ã˜ã£ã¦ã¿ã¦ã©ã†ã„ã†å¿œç”ãŒã‚ã‚‹ã‹ç¢ºèª POST /confirm.php HTTP/1.1 Host: example.jp ï¼ˆä»¥ä¸‹ç•¥ï¼‰ Cookie: PHP SESSID=xxxxxxxxxx name
rx7 2014/07/17
SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
ã€ŒSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã€‚ç›£è¨³è€… å’Œç”°å“äººæ°è‡ªèº«ã«ã‚ˆã‚‹æ›¸ç±ç´¹ä»‹
ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã«åå‰ã‚’ä»˜ã‘ã‚‹ã“ã¨ã§ã€ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆã‚’å…±æœ‰ã§ãã¦è°è«–ãŒã—ã‚„ã™ããªã‚‹ã€‚2æœˆ14æ—¥ã€15æ—¥ã«éƒ½å†…ã§é–‹å‚¬ã•ã‚ŒãŸã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Summit 2013ã€ã€é€šç§°ãƒ‡ãƒ–ã‚µãƒŸã«ãŠã„ã¦ã€æ›¸ç±ã€ŒSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã®ç›£è¨³ã‚’ã—ãŸå’Œç”°å“äººæ°ã¯æœ¬æ›¸ã®æ„ç¾©ã‚’ã“ã†å¼·èª¿ã—ã¾ã—ãŸã€‚ ã€ŒSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹è¨è¨ˆã‹ã‚‰ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«é–¢ã‚ã‚‹ãƒ¬ã‚¤ãƒ¤ã¾ã§ã€é–‹ç™ºè€…ãŒé™¥ã‚Šã‚„ã™ã„ãƒŸã‚¹ã‚„èª¤è§£ã«åå‰ã‚’ä»˜ã‘ãŸã†ãˆã§åŽŸå› ã¨è§£æ±ºç–ã‚’è©³ã—ãè§£èª¬ã—ã¦ã„ã¾ã™ã€‚ å’Œç”°æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€ã“ã‚Œã¾ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹ãƒ‡ãƒ¼ã‚¿è¨è¨ˆãªã©ã®ãƒŸã‚¹ã‚’æŒ‡æ‘˜ã—ãŸã‚Šè°è«–ã™ã‚‹ã«ã¯ã€ãã®èƒŒæ™¯ã‚’å…±æœ‰ã™ã‚‹ãŸã‚ã®é¢å€’ãªèª¬æ˜ŽãŒå¿…è¦ã§ã—ãŸã€‚SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã®ç™»å ´ã¯ã€ãã†ã—ãŸèƒŒæ™¯ã‚’æš—é»™ã®ã†ã¡ã«å…±æœ‰ã™ã‚‹æ‰‹æ®µã‚’ä¸Žãˆã¦ãã‚Œã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚æœ¬æ›¸ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ†é‡Žã®å¤å…¸ã«ãªã‚‹è³‡æ ¼ã‚’ååˆ†ã«å‚™ãˆã¦ã„ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ æ›¸ç±ã®ç›£è¨³è€…è‡ªèº«ãŒ
rx7 2013/02/19
DB

SQL

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

SQL

DB

æœ¬
ãƒªãƒ³ã‚¯
Ring
Ringã¨ã¯ã€ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ä¼šç¤¾å¾“æ¥å“¡ã‚’å¯¾è±¡ã«ã—ãŸæ–°è¦äº‹æ¥ææ¡ˆåˆ¶åº¦ã§ã™ã€‚ ã€Žã‚¼ã‚¯ã‚·ã‚£ã€ã€ŽR25ã€ã€Žã‚¹ã‚¿ãƒ‡ã‚£ã‚µãƒ—ãƒªã€ãªã©æ•°å¤šãã®äº‹æ¥ã‚’ç”Ÿã¿å‡ºã—ã¦ããŸæ–°è¦äº‹æ¥åˆ¶åº¦ã¯ã€ 1982å¹´ã«ã€ŒRINGã€ã¨ã—ã¦ã‚¹ã‚¿ãƒ¼ãƒˆã—ã€1990å¹´ã€ŒNew RINGã€ã¨æ”¹å®šã€ãã—ã¦2018å¹´ã€ŒRingã€ã«ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã—ã¾ã—ãŸã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ã®å¾“æ¥å“¡ã¯èª°ã§ã‚‚è‡ªç”±ã«å‚åŠ ã™ã‚‹ã“ã¨ãŒã§ãã€ ãƒ†ãƒ¼ãƒžã¯ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã®æ—¢å˜é ˜åŸŸã«é™ã‚‰ãšã€ã‚ã‚Šã¨ã‚ã‚‰ã‚†ã‚‹é ˜åŸŸãŒå¯¾è±¡ã§ã™ã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã«ã¨ã£ã¦ã€Ringã¨ã¯ã€Œæ–°ã—ã„ä¾¡å€¤ã®å‰µé€ ã€ã¨ã„ã†ã‚°ãƒ«ãƒ¼ãƒ—çµŒå–¶ç†å¿µã‚’ä½“ç¾ã™ã‚‹å ´ã§ã‚ã‚Šã€ å¾“æ¥å“¡ãŒè‡ªåˆ†ã®æ„æ€ã§æ–°è¦äº‹æ¥ã‚’ææ¡ˆãƒ»å®Ÿç¾ã§ãã‚‹æ©Ÿä¼šã§ã™ã€‚ Ringãƒ•ãƒãƒ¼ ãã®å¾Œã®äº‹æ¥é–‹ç™ºæ‰‹æ³• Ringã‚’é€šéŽã—ãŸæ¡ˆä»¶ã¯ã€äº‹æ¥åŒ–ã‚’æ¤œè¨Žã™ã‚‹æ¨©åˆ©ã‚’å¾—ã¦ã€äº‹æ¥é–‹ç™ºã‚’è¡Œã„ã¾ã™ã€‚ ã•ã¾ã–ã¾ãªäº‹æ¥é–‹ç™ºã®æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ãŒã€ä¾‹ãˆã°æ—¢å˜é ˜åŸŸã§ã®äº‹æ¥é–‹ç™ºã®å ´åˆã¯ã€ æ‹…å½“äº‹æ¥ä¼šç¤¾å†…ã§äºˆç®—ã‚„
rx7 2011/02/26
SQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
Ring
Ringã¨ã¯ã€ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ä¼šç¤¾å¾“æ¥å“¡ã‚’å¯¾è±¡ã«ã—ãŸæ–°è¦äº‹æ¥ææ¡ˆåˆ¶åº¦ã§ã™ã€‚ ã€Žã‚¼ã‚¯ã‚·ã‚£ã€ã€ŽR25ã€ã€Žã‚¹ã‚¿ãƒ‡ã‚£ã‚µãƒ—ãƒªã€ãªã©æ•°å¤šãã®äº‹æ¥ã‚’ç”Ÿã¿å‡ºã—ã¦ããŸæ–°è¦äº‹æ¥åˆ¶åº¦ã¯ã€ 1982å¹´ã«ã€ŒRINGã€ã¨ã—ã¦ã‚¹ã‚¿ãƒ¼ãƒˆã—ã€1990å¹´ã€ŒNew RINGã€ã¨æ”¹å®šã€ãã—ã¦2018å¹´ã€ŒRingã€ã«ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã—ã¾ã—ãŸã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ã®å¾“æ¥å“¡ã¯èª°ã§ã‚‚è‡ªç”±ã«å‚åŠ ã™ã‚‹ã“ã¨ãŒã§ãã€ ãƒ†ãƒ¼ãƒžã¯ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã®æ—¢å˜é ˜åŸŸã«é™ã‚‰ãšã€ã‚ã‚Šã¨ã‚ã‚‰ã‚†ã‚‹é ˜åŸŸãŒå¯¾è±¡ã§ã™ã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã«ã¨ã£ã¦ã€Ringã¨ã¯ã€Œæ–°ã—ã„ä¾¡å€¤ã®å‰µé€ ã€ã¨ã„ã†ã‚°ãƒ«ãƒ¼ãƒ—çµŒå–¶ç†å¿µã‚’ä½“ç¾ã™ã‚‹å ´ã§ã‚ã‚Šã€ å¾“æ¥å“¡ãŒè‡ªåˆ†ã®æ„æ€ã§æ–°è¦äº‹æ¥ã‚’ææ¡ˆãƒ»å®Ÿç¾ã§ãã‚‹æ©Ÿä¼šã§ã™ã€‚ Ringãƒ•ãƒãƒ¼ ãã®å¾Œã®äº‹æ¥é–‹ç™ºæ‰‹æ³• Ringã‚’é€šéŽã—ãŸæ¡ˆä»¶ã¯ã€äº‹æ¥åŒ–ã‚’æ¤œè¨Žã™ã‚‹æ¨©åˆ©ã‚’å¾—ã¦ã€äº‹æ¥é–‹ç™ºã‚’è¡Œã„ã¾ã™ã€‚ ã•ã¾ã–ã¾ãªäº‹æ¥é–‹ç™ºã®æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ãŒã€ä¾‹ãˆã°æ—¢å˜é ˜åŸŸã§ã®äº‹æ¥é–‹ç™ºã®å ´åˆã¯ã€ æ‹…å½“äº‹æ¥ä¼šç¤¾å†…ã§äºˆç®—ã‚„
rx7 2011/02/20
SQL

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
Ring
Ringã¨ã¯ã€ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ä¼šç¤¾å¾“æ¥å“¡ã‚’å¯¾è±¡ã«ã—ãŸæ–°è¦äº‹æ¥ææ¡ˆåˆ¶åº¦ã§ã™ã€‚ ã€Žã‚¼ã‚¯ã‚·ã‚£ã€ã€ŽR25ã€ã€Žã‚¹ã‚¿ãƒ‡ã‚£ã‚µãƒ—ãƒªã€ãªã©æ•°å¤šãã®äº‹æ¥ã‚’ç”Ÿã¿å‡ºã—ã¦ããŸæ–°è¦äº‹æ¥åˆ¶åº¦ã¯ã€ 1982å¹´ã«ã€ŒRINGã€ã¨ã—ã¦ã‚¹ã‚¿ãƒ¼ãƒˆã—ã€1990å¹´ã€ŒNew RINGã€ã¨æ”¹å®šã€ãã—ã¦2018å¹´ã€ŒRingã€ã«ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã—ã¾ã—ãŸã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ã®å¾“æ¥å“¡ã¯èª°ã§ã‚‚è‡ªç”±ã«å‚åŠ ã™ã‚‹ã“ã¨ãŒã§ãã€ ãƒ†ãƒ¼ãƒžã¯ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã®æ—¢å˜é ˜åŸŸã«é™ã‚‰ãšã€ã‚ã‚Šã¨ã‚ã‚‰ã‚†ã‚‹é ˜åŸŸãŒå¯¾è±¡ã§ã™ã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã«ã¨ã£ã¦ã€Ringã¨ã¯ã€Œæ–°ã—ã„ä¾¡å€¤ã®å‰µé€ ã€ã¨ã„ã†ã‚°ãƒ«ãƒ¼ãƒ—çµŒå–¶ç†å¿µã‚’ä½“ç¾ã™ã‚‹å ´ã§ã‚ã‚Šã€ å¾“æ¥å“¡ãŒè‡ªåˆ†ã®æ„æ€ã§æ–°è¦äº‹æ¥ã‚’ææ¡ˆãƒ»å®Ÿç¾ã§ãã‚‹æ©Ÿä¼šã§ã™ã€‚ Ringãƒ•ãƒãƒ¼ ãã®å¾Œã®äº‹æ¥é–‹ç™ºæ‰‹æ³• Ringã‚’é€šéŽã—ãŸæ¡ˆä»¶ã¯ã€äº‹æ¥åŒ–ã‚’æ¤œè¨Žã™ã‚‹æ¨©åˆ©ã‚’å¾—ã¦ã€äº‹æ¥é–‹ç™ºã‚’è¡Œã„ã¾ã™ã€‚ ã•ã¾ã–ã¾ãªäº‹æ¥é–‹ç™ºã®æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ãŒã€ä¾‹ãˆã°æ—¢å˜é ˜åŸŸã§ã®äº‹æ¥é–‹ç™ºã®å ´åˆã¯ã€ æ‹…å½“äº‹æ¥ä¼šç¤¾å†…ã§äºˆç®—ã‚„
rx7 2011/02/11
ã‚ã€@hiroohiãŒã“ã®å‰è©±ã—ã¦ã„ãŸä»¶ã ï¼

SQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
rx7 2011/01/08
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ã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚
rx7 2010/09/17
SQL

DB
ãƒªãƒ³ã‚¯
1