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

taninsw id:taninsw

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

NECã€SQLã§FPGAã‚’ç›´æŽ¥è¨è¨ˆã§ãã‚‹æŠ€è¡“ã‚’é–‹ç™º--åœæ¢ã›ãšã«å‡¦ç†å†…å®¹ã‚‚å¤‰æ›´
å°åˆ·ã™ã‚‹ ãƒ¡ãƒ¼ãƒ«ã§é€ã‚‹ ãƒ†ã‚ã‚¹ãƒˆ HTML é›»åæ›¸ç± PDF ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ãƒ†ã‚ã‚¹ãƒˆ é›»åæ›¸ç± PDF ã‚¯ãƒªãƒƒãƒ—ã—ãŸè¨˜äº‹ã‚’Myãƒšãƒ¼ã‚¸ã‹ã‚‰èªã‚€ã“ã¨ãŒã§ãã¾ã™ NECã¯8æœˆ31æ—¥ã€ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã®ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ åˆ†æžå‡¦ç†ã‚’é«˜é€ŸåŒ–ã™ã‚‹ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚’å°‚é–€çŸ¥è˜ãŒãªãã¦ã‚‚ç°¡å˜ã€é«˜é€Ÿã«è¨è¨ˆã§ãã‚‹æŠ€è¡“ã‚’é–‹ç™ºã—ãŸã¨ç™ºè¡¨ã—ãŸã€‚2014å¹´åº¦ã¾ã§ã«è£½å“åŒ–ã—ã¦æä¾›ã™ã‚‹ã“ã¨ã‚’ç›®æŒ‡ã™ã€‚ ä»Šå›žé–‹ç™ºã—ãŸæŠ€è¡“ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã§æ¨™æº–çš„ã«ä½¿ã‚ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹è¨€èªžã€ŒSQLã€ã§è¨è¨ˆã—ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’ã€åŒç¤¾ãŒä¿æœ‰ã™ã‚‹æ›¸ãæ›ãˆå¯èƒ½ãªLSIï¼ˆField Programmable Gate Arrayï¼šFPGAï¼‰ã®å›žè·¯åˆæˆæŠ€è¡“ã€ŒCyberWorkBenchã€ã‚’åˆ©ç”¨ã—ã¦ã€å°‚ç”¨ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã«è‡ªå‹•å¤‰æ›ã™ã‚‹ã¨ã„ã†ã‚‚ã®ã€‚ãƒ‡ãƒ¼ã‚¿åˆ†æžæ‹…å½“è€…ã¯ã€ä½¿ã„æ…£ã‚ŒãŸSQLã§FPGAã‚’ç›´æŽ¥è¨è¨ˆã§ãã‚‹ã¨ã„ã„ã€æŠ€è¡“è€…ã«ã‚ˆã‚‹å›žè·¯è¨è¨ˆä½œæ¥ãŒ
taninsw 2012/09/01
FPGA

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ã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚
taninsw 2010/09/20
sql

ã„ã¤ã‹èªã‚€ã‹ã‚‚
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: MySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•
MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã¨è¨€ã£ãŸå ´åˆã«ã¯ã€ã‚µãƒ¼ãƒãƒ¼ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®èª¿æ•´ã‚„ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã—ãŸã‚¯ã‚¨ãƒªå®Ÿè¡Œè¨ˆç”»ã®æœ€é©åŒ–ãŒè©±é¡Œã«ä¸Šã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ã—ã‹ã—ã€ç™ºè¡Œã™ã‚‹å…¨ã¦ã® SQL ã«ã¤ã„ã¦ã€ã„ã¡ã„ã¡ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ã¦ç¢ºèªã—ã¦ã„ã¦ã¯ã€ã„ãã‚‰æ™‚é–“ãŒã‚ã£ã¦ã‚‚ãŸã‚Šã¾ã›ã‚“ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’åŠ¹çŽ‡çš„ã«é€²ã‚ã‚‹ã«ã¯ã€ã¾ãšã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã£ã¦ã„ã‚‹ SQL ã‚¯ã‚¨ãƒªã‚’ç‰¹å®šã—ã€æ¬¡ã«ãã®æœ€é©åŒ–ã‚’è¡Œã†ã¹ãã§ã™ã€‚ ã§ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’ç‰¹å®šã™ã‚‹ã®ã‹ã€‚MySQL Conference & Expo 2009 ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã«ãŠã„ã¦ Mark Callaghan æ°ã¯ã€Google ã§ã¯ SHOW PROCESSLIST ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ãŸçµ±è¨ˆçš„ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’ä½¿ã£ã¦ã„ã‚‹ã¨è¿°ã¹ã¦ã„ã‚‰ã£ã—ã‚ƒã„ã¾ã™ (å‚ç…§: MySQLConf 09: Mark Callaghan, "This is Not a
taninsw 2009/07/22
mysql

performance

programming

db

sql

ã„ã¤ã‹èªã‚€ã‹ã‚‚
ãƒªãƒ³ã‚¯
SQLite ãŒèªè˜ã™ã‚‹ SQL - Third impact
SQLite ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯æ¨™æº– SQL è¨€èªžã®å¤§éƒ¨åˆ†ã‚’ç†è§£ã§ãã¾ã™ã€‚ ã—ã‹ã—ã€ã„ãã‚‰ã‹ã®æ©Ÿèƒ½ã‚’çœç•¥ã—ã€ ã¨ã¯ã„ãˆåŒæ™‚ã«ã€å°‘ã—ã®æ©Ÿèƒ½ã‚’ä»˜ã‘åŠ ãˆã¦ã‚‚ã„ã¾ã™ã€‚ ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯ SQLite ã«ãŠã‘ã‚‹ SQL è¨€èªžã®ã‚µãƒãƒ¼ãƒˆã™ã‚‹éƒ¨åˆ†ã¨ ã—ãªã„éƒ¨åˆ†ã®æ£ç¢ºãªè¨˜è¿°ã‚’ç›®æŒ‡ã—ã¾ã™ã€‚ åŒæ§˜ã«ã€ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã®ãƒªã‚¹ãƒˆã‚‚æä¾›ã—ã¾ã™ã€‚ ä»¥ä¸‹ã®æ§‹æ–‡å›³å…¨ä½“ã§ã€ãƒªãƒ†ãƒ©ãƒ«ãƒ†ã‚ã‚¹ãƒˆã‚’å¤ªå—ã®é’ã§ç¤ºã—ã¾ã™ã€‚ éžçµ‚ç«¯è¨˜å·ã¯ã€æ–œä½“ã®èµ¤ã§ç¤ºã—ã¾ã™ã€‚ æ§‹æ–‡ãƒžãƒ¼ã‚¯ã‚¢ãƒƒãƒ—è‡ªä½“ã®ä¸€éƒ¨ã§ã‚ã‚‹æ¼”ç®—åã¯ãƒãƒ¼ãƒžãƒ³ä½“ã®é»’ã§ç¤ºã—ã¾ã™ã€‚ ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯ SQLite ãŒå®Ÿè¡Œã™ã‚‹ SQL æ§‹æ–‡ã®å˜ãªã‚‹æ¦‚è¦ã«éŽãŽã¾ã›ã‚“ã€‚ å¤šãã®ä½Žãƒ¬ãƒ™ãƒ«ã®ãƒ—ãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ã‚’çœç•¥ã—ã¾ã™ã€‚ SQLite ãŒç†è§£ã™ã‚‹è¨€èªžã®è©³ç´°ãªè³‡æ–™ã®ãŸã‚ã«ã€ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¨æ–‡æ³•ãƒ•ã‚¡ã‚¤ãƒ«ã€Œparse.yã€ã‚’ å‚ç…§ã—ã¦ãã ã•ã„ã€‚ SQLite ã¯ä»¥ä¸‹ã®æ§‹æ–‡ã‚’å®Ÿè£…ã—ã¾ã™ã€‚ ALTER TABLE ANAL
taninsw 2009/07/22
[ã„ã¤ã‹èªã‚€ã‹ã‚‚ã€

sqlite

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

rails

sql

ã„ã¤ã‹èªã‚€
ãƒªãƒ³ã‚¯
Martin Fowleræ°ã¯ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã«ã¤ã„ã¦ã®å‡çµã—ãŸè€ƒãˆãŒã»ãã‚Œã¦ããŸã¨è€ƒãˆã¦ã„ã‚‹
Spring Bootã«ã‚ˆã‚‹APIãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰æ§‹ç¯‰å®Ÿè·µã‚¬ã‚¤ãƒ‰ ç¬¬2ç‰ˆ ä½•åƒäººã‚‚ã®é–‹ç™ºè€…ãŒã€InfoQã®ãƒŸãƒ‹ãƒ–ãƒƒã‚¯ã€ŒPractical Guide to Building an API Back End with Spring Bootã€ã‹ã‚‰ã€Spring Bootã‚’ä½¿ã£ãŸREST APIæ§‹ç¯‰ã®åŸºç¤Žã‚’å¦ã‚“ã ã€‚ã“ã®æœ¬ã§ã¯ã€å‡ºç‰ˆæ™‚ã«æ–°ã—ããƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹ Spring Boot 2 ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã€‚ã—ã‹ã—ã€Spring Boot3ãŒæœ€è¿‘ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã€é‡è¦ãªå¤‰...
taninsw 2008/12/12
db

database

sql

Martin Fowler

couchdb
ãƒªãƒ³ã‚¯
SQLã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã«ãŠã‘ã‚‹ã€Œ\ã€ã®å–ã‚Šæ‰±ã„
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚å…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2008å¹´6æœˆ2æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š æ˜¨æ—¥ã®ã‚¨ãƒ³ãƒˆãƒª(å¾³ä¸¸æµ©ã®æ—¥è¨˜ - ãã‚ãã‚SQLã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã«é–¢ã—ã¦ä¸€è¨€ã„ã£ã¨ãã‹ - SQLã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å†è€ƒ)ã¯æ€ã„ãŒã‘ãšå¤šãã®æ–¹ã«èªã‚“ã§ã„ãŸã ã„ãŸã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ãã®ä¸ã§é«˜æœ¨æµ©å…‰æ°ã‹ã‚‰ãƒ–ã‚¯ãƒžã‚³ãƒ¡ãƒ³ãƒˆã‚’é ‚æˆ´ã—ãŸã€‚ \ãŒescapeç”¨æ–‡å—ã®DBã§\ã®escapeãŒå¿…é ˆã«ãªã‚‹ç†ç”±ãŒæ˜Žç¢ºã«æ›¸ã‹ã‚Œã¦ãªã„ã€‚\'ãŒä¸Žãˆã‚‰ã‚ŒãŸã¨ã'ã ã‘escapeã™ã‚‹ã¨â€¦ã€‚è‡ªä½œescapeã¯å±ã†ã„ã€‚ã€Œå®‰å…¨ãªâ€¦ä½œã‚Šæ–¹ã€3ç‰ˆã§è¿½åŠ ã®ã€Œ3.å¤±æ•—ä¾‹ã€ã§ã¯DBã§ç”¨æ„ã•ã‚ŒãŸescapeæ©Ÿèƒ½ã—ã‹æŽ¨å¥¨ã—ã¦ã„ãªã„ ã“ã®ã†ã¡ã€ã¾ãšã€Œ\ã€ã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãŒå¿…
taninsw 2008/06/03
security

sql
ãƒªãƒ³ã‚¯
15ç¨®é¡žã®SQL Injectionãƒ„ãƒ¼ãƒ«è©•ä¾¡
ã“ã“ã®ã¨ã“ã‚ã€ã„ãã¤ã‹ã®SQL Injectionãƒ„ãƒ¼ãƒ«ã«ã¤ã„ã¦èª¿ã¹ã¦ã„ã¾ã—ãŸã€‚ä»Šæ—¥ã¯ãã®çµæžœã‚’æ—¥è¨˜ã«æ›¸ã„ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« SQL Injectionãƒ„ãƒ¼ãƒ«ã¨ã¯ SQL Injectionè„†å¼±æ€§ã®ç™ºè¦‹ã¨ã€ç™ºè¦‹ã—ãŸè„†å¼±æ€§ã‚’çªã„ã¦ã®DBå†…æƒ…å ±ã®å–å¾—ã‚’è¡Œãªã†ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ãŸã ã—ã€å¤šãã®ãƒ„ãƒ¼ãƒ«ã§ã¯ã€Œè„†å¼±æ€§ã®ç™ºè¦‹ã€ã¯ãŠã¾ã‘ã§ã€å¾Œè€…ã®DBå†…æƒ…å ±ã®å–å¾—ã«ä¸»çœ¼ã‚’ç½®ã„ã¦ã„ã¾ã™ã€‚ä¸€èˆ¬çš„ã«ã¯ã€æ±Žç”¨ã®Webè„†å¼±æ€§ã‚¹ã‚ãƒ£ãƒŠãªã©ã§è„†å¼±æ€§ã‚’è¦‹ã¤ã‘ã¦ã€ãã®è„†å¼±æ€§ã«å¯¾ã—ã¦ã“ã®æ—¥è¨˜ã«æ›¸ã„ã¦ã„ã‚‹ã‚ˆã†ãªãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦æƒ…å ±ã‚’å–å¾—ã™ã‚‹ã¨ã„ã†ä½¿ã„æ–¹ã‚’ã™ã‚‹ã“ã¨ãŒå¤šã„ã§ã—ã‚‡ã†ã€‚ SQL Injectionãƒ„ãƒ¼ãƒ«ã¯ã€ã„ã‚ã‚†ã‚‹Hackingãƒ„ãƒ¼ãƒ«ã§ã™ã€‚è„†å¼±æ€§æ¤œæŸ»ã‚’è¡Œãªã†è€…ã‹ã€ã•ã‚‚ãªã‘ã‚Œã°Crackingã‚’è¡Œãªã†çŠ¯ç½ªè€…ãŒä½¿ã†ãã‚‰ã„ã§ã€ä¸€èˆ¬ã®Webé–‹ç™ºè€…ã‚„ãƒ¦ãƒ¼ã‚¶ã®äººãŒä½¿ã†å¿…è¦ã«è¿«ã‚‰ã‚Œã‚‹ã“ã¨ã¯ç„¡ã„ã§ã—ã‚‡ã†ã€‚ ãƒ„ãƒ¼ãƒ«ã®ä½¿ç”¨ã«éš›ã—ã¦
taninsw 2007/12/04
security

sql
ãƒªãƒ³ã‚¯
MySQL FULLTEXT Ngram : LIKEæ¤œç´¢ã‚ˆã‚Šæ•°åå€é«˜é€Ÿãªã€ãŠæ‰‹è»½ æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ ã«ã¤ã„ã¦ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
taninsw 2007/03/15
mysql

ngram

ã„ã¤ã‹èªã‚€

db

database

search

sql
ãƒªãƒ³ã‚¯
ãƒ¢ã‚¸ãƒ©ã®é–‹ç™ºãƒˆãƒƒãƒ—ãŒèªžã‚‹ã€Firefox 3.0ã®æ–°æ©Ÿèƒ½ | OSDN Magazine
ç±³å›½ãƒ¢ã‚¸ãƒ©ãƒ»ã‚³ãƒ¼ãƒãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€ä»Šå¹´ä¸‹åŠæœŸã«ãƒªãƒªãƒ¼ã‚¹äºˆå®šã®ã€ŒFirefox 3.0ã€ãƒ–ãƒ©ã‚¦ã‚¶ã«ã€ã‚ªãƒ•ãƒ©ã‚¤ãƒ³æ™‚ã§ã‚‚Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒåˆ©ç”¨ã§ãã‚‹æ©Ÿèƒ½ã‚’æè¼‰ã™ã‚‹è¨ˆç”»ã ã€‚ ãƒ¢ã‚¸ãƒ©ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°æ‹…å½“ãƒã‚¤ã‚¹ãƒ—ãƒ¬ã‚¸ãƒ‡ãƒ³ãƒˆã€ãƒžã‚¤ã‚¯ãƒ»ã‚·ãƒ¥ãƒ¬ãƒ—ãƒ•ã‚¡ãƒ¼æ°ãŒ2æœˆ27æ—¥ã€Firefox 3.0ã«æè¼‰äºˆå®šã®æ–°æ©Ÿèƒ½ã¨é–‹ç™ºã®é€²æ—çŠ¶æ³ã«ã¤ã„ã¦èªžã£ãŸã€‚ åŒæ°ã¯ã€Firefox 3.0ã®â€œç›®çŽ‰â€ã¨ã—ã¦ã€ã‚ªãƒ•ãƒ©ã‚¤ãƒ³æ™‚ã§ã‚‚Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹æ©Ÿèƒ½ã‚’æŒ™ã’ã‚‹ã€‚ ä¾‹ãˆã°ã‚ªãƒ•ãƒ©ã‚¤ãƒ³ã®çŠ¶æ…‹ã§ã€ã‚°ãƒ¼ã‚°ãƒ«ãŒæä¾›ã™ã‚‹ã€ŒGmailã€ã§ãƒ¡ãƒ¼ãƒ«ã‚’ä½œæˆï¼ä¿å˜ã—ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã«æŽ¥ç¶šã—ãŸæ™‚ç‚¹ã§ãƒ¡ãƒ¼ãƒ«ã‚„ãƒ‡ãƒ¼ã‚¿ã‚’é€ä¿¡ã™ã‚‹ã¨ã„ã£ãŸã“ã¨ã‚‚å¯èƒ½ã«ãªã‚‹ã¨ã®ã“ã¨ã ã€‚ ã€Œã‚ã‚Œã‚ã‚Œã®æœ€çµ‚ç›®æ¨™ã¯ã€Firefoxã¨Webãƒ™ãƒ¼ã‚¹ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‚’çµ±åˆã—ã€ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒ»ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨åŒæ§˜ã«Firefoxã‚’é€šã˜ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã“ã¨ã ã€ï¼ˆã‚·ãƒ¥ãƒ¬ãƒ—ãƒ•
taninsw 2007/02/28
firefox

sql
ãƒªãƒ³ã‚¯
é«˜æœ¨æµ©å…‰ï¼ è‡ªå®…ã®æ—¥è¨˜ - é§„ç›®ãªæŠ€è¡“æ–‡æ›¸ã®è¦‹åˆ†ã‘æ–¹ ãã®1
â– é§„ç›®ãªæŠ€è¡“æ–‡æ›¸ã®è¦‹åˆ†ã‘æ–¹ ãã®1 ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã®ãƒ›ãƒƒãƒ†ãƒ³ãƒˆãƒªã‚’è¦‹ã¦ã„ãŸã¨ã“ã‚ã€300ã‚’è¶…ãˆã‚‹ãƒ¦ãƒ¼ã‚¶ã«ç™»éŒ²ã•ã‚ŒãŸä»¥ä¸‹ã®è¨˜äº‹ãŒã‚ã£ãŸã€‚ ä»Šå¤œåˆ†ã‹ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–, ä¸Šé‡Žå®£, @IT, 2006å¹´11æœˆ2æ—¥ ã¾ãŸä¸Šé‡Žå®£ã‹ã€‚é¡”è¦‹çŸ¥ã‚Šãªã®ã§ã‚ºãƒãƒªã„ãã“ã¨ã«ã™ã‚‹ã€‚ ã—ã‹ã—ã€ãã®å¯¾ç–ã¯ã¾ã æœ¬å½“ã«ç†è§£ã•ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ€ãˆã‚‹ã€‚ ã¸ãˆã€‚ çµ‚ã‚ã‚Šã®æ–¹ã‚’è¦‹ã¦ã¿ã‚‹ã¨ã€ Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¯¾ç– å…¥åŠ›å€¤ã®SQLã®ç‰¹æ®Šæ–‡å—ã‚’é©åˆ‡ã«ã‚¨ã‚¹ã‚±ãƒ¼ãƒ— å…¥åŠ›å€¤ï¼ãƒ—ãƒã‚°ãƒ©ãƒ ï¼ˆãƒ—ãƒã‚»ã‚¹ï¼‰ã«å¤–éƒ¨ã‹ã‚‰å…¥ã£ã¦ãã‚‹ã‚‚ã® ã‚·ãƒ•ãƒˆJISã®å ´åˆã«ã¯1ãƒã‚¤ãƒˆæ–‡å—ã‚’æ•´ç† SQLã®è¨˜è¿°ã‚’ãªãã™ãŸã‚ã«O/Rï¼ˆObject/Relationalï¼‰ãƒžãƒƒãƒ”ãƒ³ã‚°ã‚’æ´»ç”¨ æ”»æ’ƒè€…ã«å½¹ç«‹ã¤æƒ…å ±ã‚’ä¸Žãˆãªã„ãŸã‚ã«ã€ä¸è¦ãªã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå‡ºåŠ›ã™ã‚‹ã‚¨ãƒ©ãƒ¼ãªã©ï¼‰ã®è¡¨ç¤ºã‚’æŠ‘æ¢ å¯¾ç–ã«ã€Œæº–å‚™ã•ã‚ŒãŸæ–‡ã€(prepared statement)
taninsw 2006/11/05
security

sql
ãƒªãƒ³ã‚¯
Web2.0ãƒŠãƒ“: SQL-DESIGNERãŒã‚¹ã‚´ã‚¤
ã„ã„ãï¼ 0 ãƒ„ã‚¤ãƒ¼ãƒˆ B! ã¯ã¦ãƒ– 447 Pocket 2 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆæ™‚ã«ERå›³ã‚’ã‹ãã“ã¨ãŒå¤šã„ã¨æ€ã„ã¾ã™ãŒã€SQL-designerã¨ã„ã†ã‚¦ã‚§ãƒ–ãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ãŒéžå¸¸ã«ä½¿ã„ã‚„ã™ã„ãã€ãƒ‡ã‚¶ã‚¤ãƒ³çš„ã«ã‚‚ç¶ºéº—ã§ä¾¿åˆ©ã€‚ MSprojectç‰ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã‚’è¡Œã†å°‚ç”¨ã‚½ãƒ•ãƒˆã¯éžå¸¸ã«å¤šãã‚ã‚‹ãŒã€ã©ã‚Œã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå¿…è¦ã ã£ãŸã‚Šã€è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ãŒå¿…è¦ã ã£ãŸã‚Šã€ã‚½ãƒ•ãƒˆãŒé‡ã‹ã£ãŸã‚Šã€ç’°å¢ƒä¾å˜ãŒæ¿€ã—ã‹ã£ãŸã‚Šã—ã¦ã€ä½¿ã„ã«ãã„ã€‚ ä½¿ã„ã‹ãŸã¯ç°¡å˜ã§ã€ ï¼‘ï¼Žã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã«ã„ã£ã¦ ï¼’ï¼Žãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’è¿½åŠ ã™ã‚‹ ï¼“ï¼Žãƒ—ãƒªãƒ³ãƒˆã‚¢ã‚¦ãƒˆorXMLã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ ã ã‘ã€‚ ãƒ‡ãƒ¼ã‚¿ã®åž‹ãªã©ã‚‚é¸æŠžã§ãã¦ã€è¨è¨ˆãŒçµ‚ã‚ã£ãŸã‚‰ã€SQLæ–‡ã‚’ãã®ã¾ã¾ç™ºè¡Œã—ãŸã‚Šã€ä½œã£ãŸEQå›³ã‚’XMLã§ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã‚„ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚Javascriptãƒ™ãƒ¼ã‚¹ãªã®ã§ã€ã‚ã‚“ã©ãã•ã„ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚„ç’°å¢ƒä¾å˜ã‚‚ãªã—ã€‚ ã‚¦ã‚§ãƒ–ä¸Šã§ã‚„ã‚‹ã®ã¯ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
taninsw 2006/10/29
ãƒ¬ãƒ“ãƒ¥ãƒ¼å¾…ã¡

web

db

sql
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å†ç¾ãƒ‡ãƒ¢ãƒ ãƒ¼ãƒ“ãƒ¼:phpspoté–‹ç™ºæ—¥èªŒ
0-DAY - SIMPLE SQL INJECTION ã‚ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®CMSã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ›ãƒ¼ãƒ«ã‚’æŽ¢ã‚‹éš›ã®Flashãƒ ãƒ¼ãƒ“ãƒ¼ã€‚ æ˜ ç”»ã®ã‚¤ãƒ³ãƒˆãƒã®ã‚ˆã†ã«å§‹ã¾ã‚Šã€æ€ªã—ã’ãªéŸ³æ¥½ã¨å…±ã«ãƒ ãƒ¼ãƒ“ãƒ¼ãŒå†ç”Ÿã•ã‚Œã‚‹ç‰ã€ã‚ã‚„ã—ã„é›°å›²æ°—ãŸã£ã·ã‚Šã«ä½œã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ IRCãƒãƒ£ãƒƒãƒˆã§ä¾é ¼ãŒå§‹ã¾ã‚Šã€ã‚½ãƒ¼ã‚¹ã®DLã€œgrepã—ã¦SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ã‚’è¦‹ã¤ã‘ã€å®Ÿéš›ã«IDã¨passã‚’å–ã‚Šå‡ºã™ã¾ã§ã€‚ ã“ã†ã„ã†æ‰‹å£ã§è„†å¼±æ€§ãŒç™ºè¦‹ã•ã‚Œã‚‹ã‚“ã ãªã€ã¨ã„ã†ã®ãŒãƒãƒƒã‚ãƒªã¨åˆ†ã‹ã‚Šã¾ã™ã€‚ ã‚‚ã¡ã‚ã‚“ã€ã‚½ãƒ¼ã‚¹ãªã©è¦‹ãªãã¦ã‚‚URLã‹ã‚‰é¡žæŽ¨ã—ãŸã‚Šãã®ä»–ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚‚å¤šæ•°ã‚ã‚‹ã¨æ€ã„ã¾ã™ãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®å ´åˆã¯ã“ã‚“ãªæ„Ÿã˜ã§ã‚½ãƒ¼ã‚¹ã‚’grepã•ã‚ŒãŸã‚Šã™ã‚‹ã‚“ã§ã—ã‚‡ã†ãã€‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã®å‚è€ƒã«ã€‚
taninsw 2006/07/04
sql

security
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
taninsw 2006/04/06
èªã‚€]

db

sql

study

ã„ã¤ã‹å†èªã™ã‚‹
ãƒªãƒ³ã‚¯
SQL RELAY (1) â€” Webcoreæ ªå¼ä¼šç¤¾
2003å¹´12æœˆ4æ—¥ã«è¡Œã‚ã‚ŒãŸJPUGãƒãƒƒãƒˆã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³åˆ†ç§‘ä¼šã®å‹‰å¼·ä¼šã®è³‡æ–™ã§ã™ã€‚RDBMSã®æ°¸ç¶šåŒ–ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ï¼Œãƒ—ãƒã‚ã‚·ãƒ¼ï¼Œãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚¹ãªã©ã®æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹SQL Relayã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ ç™ºè¡¨è³‡æ–™ã¸ã®ãƒªãƒ³ã‚¯ ç™ºè¡¨è³‡æ–™ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰(PDF,9ãƒšãƒ¼ã‚¸) æ¦‚è¦ 2003å¹´12æœˆ4æ—¥ã«è¡Œã‚ã‚ŒãŸJPUGãƒãƒƒãƒˆã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³åˆ†ç§‘ä¼šã®å‹‰å¼·ä¼šã®è³‡æ–™ã§ã™ã€‚ RDBMSã®æ°¸ç¶šåŒ–ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ï¼Œãƒ—ãƒã‚ã‚·ãƒ¼ï¼Œãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚¹ãªã©ã®æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹SQL Relayã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ å†…å®¹ What's SQL Relay ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« è¨å®š SQL Relay ã®èµ·å‹• æ°¸ç¶šåŒ–ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ« å‚è€ƒãƒªãƒ³ã‚¯ SQL Relay æ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼š ãƒãƒƒãƒˆã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³åˆ†ç§‘ä¼š Ploneï¼ŒPythonã®ã‚³ãƒ³ã‚µãƒ«ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ å¼Šç¤¾ã§ã¯Ploneã‚„Zopeï¼ŒPythonã‚’
taninsw 2006/04/04
sql
ãƒªãƒ³ã‚¯
SQL Relay
SQL Relay is a powerful database connection management solution. With SQL Relay, you can speed up and enhance the scalability of database-driven web-based applications, access databases from unsupported platforms, throttle database access, distribute load over clustered or replicated databases, route queries and migrate applications from one database to another. Advantages Persistent Database Conn
taninsw 2006/04/04
SQL
ãƒªãƒ³ã‚¯
1