[B! sql] taka-junã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

taka-jun id:taka-jun

sqlã«é–¢ã™ã‚‹taka-junã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

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

ã‚½ã‚·ãƒ£ã‚²ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®è‡ªåˆ†ãŒã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ“ãƒ¥ãƒ¼æ™‚ã«é‡è¦–ã™ã‚‹ç®‡æ‰€33é¸ ã€éšæ™‚è¿½åŠ ã€‘ - Qiita
ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ“ãƒ¥ãƒ¼ã§åœŸæ—¥ã«å®‰å¯§ã‚’ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã¯ã€ãƒ¦ãƒ¼ã‚¶ã‚¢ã‚¯ã‚»ã‚¹é›†ä¸ã¨ã€ãã‚Œã«ä¼´ã†ãƒ¦ãƒ¼ã‚¶ãƒ‡ãƒ¼ã‚¿å¢—åŠ ã«ã‚ˆã£ã¦åŠ‡çš„ã«è² è·ãŒä¸ŠãŒã‚Šã€ï¼ˆä¸»ã«åœŸæ—¥ã«ï¼‰ã‚µãƒ¼ãƒ“ã‚¹ã«å½±éŸ¿ã‚’ä¸ŽãˆãŒã¡ã§ã™ã€‚ å•é¡ŒãŒã‚ã‚‹ã‚³ãƒ¼ãƒ‰ã¯ã€ãŸã¨ãˆè² è·ãƒ†ã‚¹ãƒˆã‚’è¡Œã£ã¦ã‚‚ã€ä½œæˆã—ãŸã‚·ãƒŠãƒªã‚ªã«ã‚ˆã£ã¦ã¯è¦‹ã¤ã‘ã‚‰ã‚Œãªã„å¯èƒ½æ€§ã‚‚ã‚ã‚Šã¾ã™ã€‚ ãã†ã„ã£ãŸè¦‹ãˆãªã„ä¸å®‰ã‚’æ‰•æ‹ã™ã‚‹ã¨ã„ã†æ„å‘³ã§ã‚‚ã€ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ“ãƒ¥ãƒ¼ã¯é‡è¦ã ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã€ã‚¹ãƒ†ã‚ãƒã‚¤ãƒ³ãƒˆã€‘ ãƒ» ã‚½ãƒ¼ã‚¹ã‚’è¦‹ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€æ™‚é™çˆ†å¼¾ãŒåœŸæ—¥ã«çˆ†ç™ºã™ã‚‹ã®ã‚’è§£é™¤ ãƒ» ã‚¹ã‚ãƒ«å…±æœ‰ã«ã‚ˆã£ã¦ãƒ¡ãƒ³ãƒãƒ¼ãŒãƒ¬ãƒ™ãƒ«ã‚¢ãƒƒãƒ—ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€åœŸæ—¥ã«çˆ†ç™ºã™ã‚‹æ™‚é™çˆ†å¼¾ã®è¨ç½®ç¢ºçŽ‡ä½Žä¸‹ ã¾ãã¾ã¨ã‚ã‚‹ã¨ ã“ã‚Œã«å°½ãã¾ã™ï¼ˆ4æ³ã®æ¯åè«‡ï¼‰ ä»Šã¯ã€gitã®ãƒ—ãƒ«ãƒªã‚¯ã‚¨ã‚¹ãƒˆã¨ã„ã†å¼·åŠ›ãªãƒ¬ãƒ“ãƒ¥ãƒ¼ãƒ„ãƒ¼ãƒ«ã‚‚ã‚ã‚Šã€æ•·å±…ãŒã‹ãªã‚Šä½Žããªã£ãŸã®ã§ã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ï¼ ãƒã‚§ãƒƒã‚¯ã™ã‚‹ãƒã‚¤ãƒ³ãƒˆã¯5ã¤ ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚’è¡Œã†ã«ã‚ãŸã‚Šã€*ã€Œã©ã‚“ãªã¨ã“ã‚ã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚Œã°ã„ã„ã®ã‹åˆ†
taka-jun 2016/04/07
sql

programming

redis

ãƒ¬ãƒ“ãƒ¥ãƒ¼
ãƒªãƒ³ã‚¯
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
taka-jun 2014/03/06
SQL

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

db

database

SQL
ãƒªãƒ³ã‚¯
ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã§Googleæ¤œç´¢ã—ã¦ä¸Šä½15è¨˜äº‹ã‚’æ¤œè¨¼ã—ãŸ - ockeghem's blog
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€ãƒãƒƒãƒˆä¸Šã§ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã§Googleæ¤œç´¢ã—ãŸçµæžœã®ä¸Šä½15ã‚¨ãƒ³ãƒˆãƒªã‚’æ¤œè¨¼ã—ãŸçµæžœã‚’å ±å‘Šã—ã¾ã™ã€‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ã®å¯¾ç–ã¯ã€æ—¢ã«ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã«ãƒ•ã‚¡ã‚¤ãƒŠãƒ«ã‚¢ãƒ³ã‚µãƒ¼ï¼ˆå¾Œè¿°ï¼‰ã‚’ç¤ºã—ã¦ã„ã¾ã™ãŒã€ã¾ã ã“ã®æ–‡æ›¸ã‚’çŸ¥ã‚‰ãªã„äººãŒå¤šã„ã ã‚ã†ã“ã¨ã¨ã€ã‚„ã‚„ä¸Šç´šè€…å‘ã‘ã®æ–‡æ›¸ã§ã‚ã‚‹ã“ã¨ã‹ã‚‰ã€ã¾ã ååˆ†ã«å®Ÿè·µã•ã‚Œã¦ã¯ã„ãªã„ã¨æ€ã„ã¾ã™ã€‚ ã“ã®çŠ¶æ³ã§ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ã“ã¨ã‚’ã‚ˆãçŸ¥ã‚‰ãªã„äººãŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã—ã‚ˆã†ã¨ã—ãŸå ´åˆã®è¡Œå‹•ã‚’äºˆæ¸¬ã—ã¦ã¿ã‚‹ã¨ã€ã‹ãªã‚Šã®å‰²åˆã®äººãŒGoogleç‰ã§æ¤œç´¢ã—ã¦å¯¾å‡¦æ–¹æ³•ã‚’èª¿ã¹ã‚‹ã¨æ€ã‚ã‚Œã¾ã™ã€‚ãã“ã§ã€ä»¥ä¸‹ã®URLã§SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–æ–¹æ³•ã‚’æ¤œç´¢ã—ãŸçµæžœã®ä¸Šä½ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ¤œè¨¼ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ç«‹ã¡ã¾ã—ãŸã€‚ http://www.google.co.jp/search?q=SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç– ã©ã“ã¾ã§èª¿ã¹ã‚‹ã‹ã§ã™ãŒã€ä»¥å‰NH
taka-jun 2011/11/10
sql
ãƒªãƒ³ã‚¯
SEãƒ»ãƒ—ãƒã‚°ãƒ©ãƒžãŒçŸ¥ã£ã¦ã‚‹ã¨ä¾¿åˆ©ãªè„†å¼±æ€§ãƒã‚§ãƒƒã‚¯ãƒ„ãƒ¼ãƒ« 5 ã¤ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
æ±äº¬ãƒ©ãƒ¼ãƒ¡ãƒ³ã‚·ãƒ§ãƒ¼2011 ã„ãã¦ãƒ¼ãƒ¼ãƒ¼ï¼ã¿ãªã•ã‚“ã“ã‚“ã«ã¡ã¯ã€nakamura ã§ã™ã€‚ ä»Šæ—¥ã¯ãƒ—ãƒã‚°ãƒ©ãƒžã ã£ãŸã‚Šã‚µãƒ¼ãƒç®¡ç†è€…ã ã£ãŸã‚Šï¼ˆã‚‚ã—ãã¯ãã®ä¸¡æ–¹ã ã£ãŸã‚Šï¼‰ã™ã‚‹æ–¹ã«ãŠå‹§ã‚ã—ãŸã„ã‚µã‚¤ãƒˆã¨ãƒ„ãƒ¼ãƒ«ã‚’ã„ãã¤ã‹ã”ç´¹ä»‹ã—ã¾ã™ã€‚ç´°ã‹ã„è„†å¼±æ€§ã®ãƒã‚§ãƒƒã‚¯ç‰ã©ã†ã—ã¦ã‚‚æ‰‹é–“ãŒæŽ›ã‹ã‚‹ã‚‚ã®ãŒå¤šã„ã§ã™ãŒã€ä»Šå›žã”ç´¹ä»‹ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’ã†ã¾ãä½¿ã†ã¨ãã®è¾ºã‚Šã ã„ã¶åŠ¹çŽ‡ã‚ˆãã§ãã‚‹ã¨æ€ã„ã¾ã™ã‚ˆï¼ WEB ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–¢é€£ XSS Me XSS Me :: Add-ons for Firefox XSS ã®ãƒ†ã‚¹ãƒˆã‚’ã‚ã‚‹ç¨‹åº¦è‡ªå‹•åŒ–ã—ã¦ãã‚Œã‚‹ Firefox ã®ã‚¢ãƒ‰ã‚ªãƒ³ã§ã™ã€‚æ®‹å¿µãªãŒã‚‰ Firefox3.0.* ç³»ã®é ƒã«é–‹ç™ºãŒæ¢ã¾ã£ã¦ã—ã¾ã£ã¦ã„ã‚‹ã‚ˆã†ã§ã™ãŒã€åƒ•ã®ç’°å¢ƒã§ã¯ install.rdf ã®æ›¸ãæ›ãˆã§å•é¡Œãªãå‹•ä½œã—ã¦ã„ã¾ã™ã€‚ï¼ˆWindows7 64bit + Firefox7.0.1ï¼‰ SQL Inject Me SQL I
taka-jun 2011/11/04
Firefox

sql

security

tool

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

DB
ãƒªãƒ³ã‚¯
ä»Šå¤œã“ãã‚ã‹ã‚‹å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€€ï½ž é«˜æœ¨æµ©å…‰æ°ã«èžã„ã¦ã¿ãŸ
ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã¨ã„ã†SQLã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã«ç„¦ç‚¹ã‚’å½“ã¦ãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒã€2010å¹´3æœˆã«IPAï¼ˆç‹¬ç«‹è¡Œæ”¿æ³•äººæƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼‰ã‹ã‚‰å…¬é–‹ã•ã‚ŒãŸã€‚ ã“ã‚Œã¯2006å¹´1æœˆã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã‚‹ã€Webã‚µã‚¤ãƒˆé–‹ç™ºè€…ã‚„é‹å–¶è€…å‘ã‘ã®ã‚»ã‚ãƒ¥ã‚¢Webã‚µã‚¤ãƒˆæ§‹ç¯‰ã®ãŸã‚ã®è³‡æ–™ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ã®åˆ¥å†Šã¨ã—ã¦æ›¸ã‹ã‚ŒãŸã‚‚ã®ã§ã‚ã‚‹ã€‚ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ãŒ92ãƒšãƒ¼ã‚¸ãªã®ã«å¯¾ã—ã¦ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã ã‘ã§40ãƒšãƒ¼ã‚¸ã‚‚ã®åˆ†é‡ãŒã‚ã‚‹ã€‚ãªãœã“ã‚“ãªã«åˆ†åŽšã„ã®ã ã‚ã†ã‹ã€‚ ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆä½œæˆã«å”åŠ›ã—ãŸã¨ã„ã†ã€ç‹¬ç«‹è¡Œæ”¿æ³•äººç”£æ¥æŠ€è¡“ç·åˆç ”ç©¶æ‰€ æƒ…å ±ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç ”ç©¶ã‚»ãƒ³ã‚¿ãƒ¼ã®é«˜æœ¨æµ©å…‰æ°ã«ãŠè©±ã‚’ä¼ºã†ã“ã¨ãŒã§ããŸã€‚é«˜æœ¨æ°ã¯å€‹äººãƒ–ãƒã‚°ã€Œé«˜æœ¨æµ©å…‰ï¼ è‡ªå®…ã®æ—¥è¨˜ã€ã§ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£é–¢é€£ã®å•é¡Œã‚’è¿½æ±‚ã™ã‚‹è«–å®¢ã¨ã—ã¦ã‚‚çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ç†è€…ã‚‚ä»¥å‰ã€ã“ã®é€£è¼‰ã®ã€Œä»Šå¤œã‚ã‹ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã®å›žï¼ˆ2006å¹´11æœˆ
taka-jun 2010/06/27
DB

sql
ãƒªãƒ³ã‚¯
WEBãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼å¿…è¦‹ï¼WEBè„†å¼±æ€§åŸºç¤ŽçŸ¥è˜æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼ - ç‡ˆæ˜Žæ—¥è¨˜
ä»¥ä¸‹ã¯ã€WEBãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ç”¨ã®WEBè„†å¼±æ€§ã®åŸºç¤ŽçŸ¥è˜ã®ä¸€è¦§ã§ã™ã€‚ WEBãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®äººã¯ã“ã‚Œã‚’èªã‚ã°WEBè„†å¼±æ€§ã®åŸºç¤Žã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã¦WEBãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ãã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã‹ã‚‚ã§ã™ã€‚ ã¾ãŸã€WEBè„†å¼±æ€§ã®ç°¡æ˜“ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã¨ã—ã¦ã‚‚å°‘ã—åˆ©ç”¨ã§ãã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ WEBã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹ç™ºã™ã‚‹ã«ã¯ã€é–‹ç™ºè¦ä»¶æ›¸ã‚„ãƒ—ãƒã‚°ãƒ©ãƒ ä»•æ§˜æ›¸é€šã‚Šã«é–‹ç™ºã™ã‚Œã°è‰¯ã„ã¨ã„ã†ã‚ã‘ã«ã¯ã„ãã¾ã›ã‚“ã€‚ ãã†ã€WEBè„†å¼±æ€§ã‚’ç‹™ã†æ‚ªæ„ã®ãƒ¦ãƒ¼ã‚¶ã«ã‚‚å¯¾å‡¦ã—ãªã„ã¨ã„ã‘ãªã„ã®ã§ã™ã€‚ ä»Šå›žã€WEBã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹ç™ºã«ã‚ãŸã£ã¦ã®WEBè„†å¼±æ€§ã‚’ã€ä»¥ä¸‹ã®ä¸€è¦§ã«ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ã“ã®ã¾ã¨ã‚ãŒWEBã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã®å‚è€ƒã«ãªã‚Œã°å¹¸ã„ã§ã™ã€‚ ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ ã‚¯ãƒã‚¹ã‚µã‚¤ãƒˆãƒ»ã‚¹ã‚¯ãƒªãƒ—ãƒ†ã‚£ãƒ³ã‚° ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ»ãƒã‚¤ã‚¸ãƒ£ãƒƒã‚¯ ã‚¢ã‚¯ã‚»ã‚¹åˆ¶å¾¡ã‚„èªå¯åˆ¶å¾¡ã®æ¬ è½ ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãƒ»ãƒˆãƒ©ãƒãƒ¼ã‚µãƒ«(Directory Traversal) CSRFï¼ˆ
taka-jun 2010/05/11
web

security

sql
ãƒªãƒ³ã‚¯
MySQL ã®NULL ã§ã¯ã¾ã£ãŸã“ã¨ã‚ã‚Œã“ã‚Œ - LukeSilviaâ€™s diary
MySQL ã«é™ã‚‰ãšã€SQL ã®NULL ã®ä»•æ§˜ã«ã¯ä½•å›žã‹ã€Œãˆã£ã€ã¨é©šãã“ã¨ãŒã‚ã£ãŸã®ã§ãƒ¡ãƒ¢ã—ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚5.1 ç‰ˆã®æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãŒãªã‹ã£ãŸã‚‚ã®ã«ã¤ã„ã¦ã¯ã€4.1 ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’å‚ç…§ã—ã¾ã—ãŸã€‚ ãã‚‚ãã‚‚NULL ã¯ä½•ã‚’æ„å‘³ã™ã‚‹ã‹ NULL ã¯æœªå®šç¾©ã¾ãŸã¯ã€ä¸æ˜Žã‚’æ„å‘³ã™ã‚‹ã€‚ã€Œé›»è©±ç•ªå·ã‚’æŒãŸãªã„ã€ã¨ã„ã†ã“ã¨ã‚’è¡¨ç¾ã™ã‚‹å ´åˆã¯ã€NULL ã§ã¯ãªãã€ç©ºã®æ–‡å—åˆ—ã‚’ä½¿ã†ã€‚ NULL å€¤ã¨ã„ã†ã‚‚ã®ã‚’ SQL åˆå¿ƒè€…ã¯ã‚ˆãæ··ä¹±ã—ã¾ã™ã€‚SQL åˆå¿ƒè€…ã¯ã€å¤šãã®å ´åˆã€NULL ãŒç©ºæ–‡å— "" ã¨åŒã˜ã§ã‚ã‚‹ã¨è€ƒãˆã¦ã—ã¾ã„ã¾ã™ã€‚ã“ã‚Œã¯é•ã„ã¾ã™ã€‚ãŸã¨ãˆã°ã€ä»¥ä¸‹ã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¯å®Œå…¨ã«åˆ¥ã®ã‚‚ã®ã§ã™ã€‚ mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (""); ã©ã¡ã‚‰ã®ã‚¹
taka-jun 2010/03/23
mysql

NULL

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

sql

db
ãƒªãƒ³ã‚¯
ãƒ—ãƒã‚°ãƒ©ãƒ ã®ã‚³ãƒ¼ãƒ‰é‡ã‚’æ¸›ã‚‰ã™ MySQL é–¢æ•° | ãƒã‚·ãƒ£ãƒã‚°ã€‚
ã¿ãªã•ã‚“ç‰çƒæœé¡”ã£ã¦ã”å˜çŸ¥ã§ã™ã‹ï¼Ÿæœé¡”ã®ä¸ã§ã‚‚ã¨ã¦ã‚‚ãŸãã¾ã—ã„äº‹ã§æœ‰åãªç¨®é¡žã§ã™ãŒä»Šå¹´ã®å¤ã‹ã‚‰æˆ‘ãŒå®¶ã®åºã«æ¤ãˆãŸæ‰€ã€æœªã ã«èŠ±ãŒå’²ãèª‡ã£ã¦ã„ã¦å£ç¯€å¤–ã‚Œãªäº‹ã“ã®ä¸Šã‚ã‚Šã¾ã›ã‚“ã€ã€ã€ãªã‚“ã‹é›‘è‰åŒ–ã™ã‚‹ã¨é§†é™¤ã¯å›°é›£ã ã¨ã‹ã€ã€ã€ ã•ã¦ä»Šæ—¥ã¯çŸ¥ã£ã¦ãŠãã¨ä½•ã‹ã¨ä¾¿åˆ©ãª MySQL çµ„ã¿è¾¼ã¿ã®é–¢æ•°ãŸã¡ã‚’ã”ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ãƒ—ãƒã‚°ãƒ©ãƒ ã‚µã‚¤ãƒ‰ã«è¨˜è¿°ã™ã‚‹ã¨æ•°è¡Œã«åŠã¶å‡¦ç†ãŒã€SQL ãƒ™ãƒ¼ã‚¹ã§è¡Œã†ã¨ã»ã‚“ã®æ•°æ–‡å—ã§æ¸ˆã‚“ã§ã—ã¾ã„ã¾ã™ã€‚ DATE, DATE_FORMAT æ—¥ä»˜ã‚„æ™‚åˆ»é–¢é€£ã®é–¢æ•°ã¯ã¨ã¦ã‚‚å……å®Ÿã—ã¦ã„ã¾ã™ãŒã€ä¸ã§ã‚‚ã‚ˆãä½¿ã†ã®ã¯ã“ã®è¾ºã‚Šã§ã—ã‚‡ã†ã‹ã€‚ã“ã‚“ãªãƒ¬ã‚³ãƒ¼ãƒ‰ãŒã‚ã‚‹æ™‚ã€ã€ã€ mysql> SELECT created FROM users; +---------------------+ | created | +---------------------+ | 2009-06-05 13:33:26 | |
taka-jun 2009/10/29
sql

mysql

db

programming
ãƒªãƒ³ã‚¯
rpbourret.com - XML Database Products
Ronald Bourret Technical writing, Software development, and Consulting Copyright 2000-2010 by Ronald Bourret Last updated on: June 20, 2010 WARNING! This list has not been updated since roughly 2010. As a result, information may be out of date and products may no longer be available. If you are interested in a product whose link does not work, search for it on the Web, as product pages frequently
taka-jun 2008/07/07
xml

database

sql

db
ãƒªãƒ³ã‚¯
HTML&CSSã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãªã©ã®ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆé›†
Webmasters by Designã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‹ã‚‰ã€HTML, CSS, XML,ã‚„ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€htaccessã€DOCTYPEã€SEOãªã©ã‚¦ã‚§ãƒ–é–‹ç™ºè€…ã®ãŸã‚ã®ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ The Best Developer Cheat Sheets Around HTML & CSS HTML HTML Cheat Sheet (PNG, PDF) HTML Help Sheet. Panic Over. (PDF) XHTML cheat sheet (HTML) CSS CSS Cheat Sheet (PNG, PDF) CSS Cheat Sheet (PDF) CSS Cheat Sheet (HTML) XML XML Quick Reference (PDF) XSLT Quick Reference (PDF) XML Syntax Quick R
taka-jun 2008/06/25
web

css

html

sql

javascript
ãƒªãƒ³ã‚¯
1