[B! tips][database] shin-uemonã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

shin-uemon id:shin-uemon

tipsã¨databaseã«é–¢ã™ã‚‹shin-uemonã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

æœ€çŸã‹ã¤æœ€é€Ÿã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€ŒDBé«˜é€ŸåŒ–æŠ€è¡“ã€ï¼ˆå‰ç·¨ï¼‰ï¼šITpro
ãƒã‚¤ãƒ³ãƒˆ ãƒ»é«˜åº¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ã‚¸ãƒ§ã‚¤ãƒ³ã‚’åˆ©ç”¨ã—ï¼Œæœ€çŸçµŒè·¯ã§ãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ ãƒ»ãƒ¡ãƒ¢ãƒªãƒ¼ä¸è¶³ã‚’è‡ªå¾‹çš„ã«è§£æ¶ˆã—ï¼Œã‚ãƒ£ãƒƒã‚·ãƒ¥ã®ãƒ’ãƒƒãƒˆçŽ‡ã‚’é«˜ã‚ã‚‹ ãƒ»ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ¼DBã¯å…¨ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªãƒ¼ã§å‡¦ç†ã—ï¼Œé«˜é€ŸåŒ–ã‚’å›³ã‚‹ ç›®çš„åœ°ã«æ—©ãåˆ°ç€ã—ãŸã„ãªã‚‰ï¼Œæœ€çŸã®çµŒè·¯ã‚’æœ€é€Ÿã§è¡Œã‘ã°ã‚ˆã„ã€‚ã“ã‚Œã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã§ã‚‚åŒæ§˜ã ï¼ˆå›³1ï¼‰ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã¸ã®æœ€çŸçµŒè·¯ã‚’è¦‹ã¤ã‘ï¼Œãƒ¡ãƒ¢ãƒªãƒ¼ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ã‚’å¢—ã‚„ã—ã¦ï¼Œæœ€é€Ÿã§ãŸã©ã‚Šç€ãã€‚DBã«ã¯ãã‚“ãªæŠ€è¡“ãŒè©°ã¾ã£ã¦ã„ã‚‹ã€‚ å›³1â—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–æŠ€è¡“ã®ãƒã‚¤ãƒ³ãƒˆ ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã„ã€ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ã€‚ã¾ãŸã€ã§ãã‚‹ã ã‘ãƒ¡ãƒ¢ãƒªãƒ¼ã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã›ã¦ãŠãã“ã¨ã§ã€ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ã€ã¨ã„ã†äºŒã¤ã®ãƒã‚¤ãƒ³ãƒˆãŒã‚ã‚‹ [ç”»åƒã®ã‚¯ãƒªãƒƒã‚¯ã§æ‹¡å¤§è¡¨ç¤º] ä»¥ä¸‹ã§ã¯ï¼Œï¼ˆ1ï¼‰ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ä»•çµ„ã¿ã¨ï¼Œï¼ˆ2ï¼‰ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ä»•çµ„ã¿ã®
shin-uemon 2007/09/12
database

db

ã‚ã¨ã§èªã‚€

tips
ãƒªãƒ³ã‚¯
è¡¨ãƒãƒƒã‚¯ã®ç¨®é¡žã¨ç›¸äº’é–¢ä¿‚ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
â— ãƒãƒƒã‚¯ã‚’å–å¾—å¯èƒ½ Ã— ãƒãƒƒã‚¯ã®å–å¾—ã¯ä¸å¯èƒ½ â–² ãƒãƒƒã‚¯ã‚’å–å¾—å¯èƒ½ã§ã‚ã‚‹ãŒåˆ¥ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‹ã‚‰ã®åŒä¸€è¡Œã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã¯å¾…æ©Ÿã•ã›ã‚‰ã‚Œã‚‹(TXå¾…æ©Ÿ) â–¼ ãƒãƒƒã‚¯ã‚’å–å¾—å¯èƒ½ã§ã‚ã‚‹ãŒåˆ¥ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‹ã‚‰ã® ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼åˆ¶ç´„ã€ãƒ¦ãƒ‹ãƒ¼ã‚¯åˆ¶ç´„ ã«è©²å½“ã™ã‚‹è¡Œã® INSERT ã¯å¾…æ©Ÿã•ã›ã‚‰ã‚Œã‚‹(TXå¾…æ©Ÿ) â–² â–¼ ã«é–¢ã—ã¦ï¼šãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒåˆ†æ•£ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®å ´åˆã«ã¯åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã‚ˆã£ã¦ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆãŒç™ºç”Ÿã™ã‚‹ã€‚ å‚è€ƒ â‡’ ORA-02049: ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆ: åˆ†æ•£ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒãƒãƒƒã‚¯ã‚’å¾…æ©Ÿã—ã¦ã„ã¾ã™ã€‚ å…±æœ‰ãƒãƒƒã‚¯ã¨æŽ’ä»–ãƒãƒƒã‚¯ å…±æœ‰ãƒãƒƒã‚¯ å…±æœ‰ãƒãƒƒã‚¯ã¨ã¯ä¸»ã«å‚ç…§ã‚’è¡Œã†éš›ã«æŽ›ã‘ã‚‹ãƒãƒƒã‚¯ã§ã‚ã‚Šè¤‡æ•°è¨å®šã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚ã—ã‹ã— SELECT ã®åº¦ã«ãƒãƒƒã‚¯ã‚’æŽ›ã‘ã¦ã„ã‚‹ã‚ã‘ã§ã¯ãªãã€ãƒ‡ãƒ¼ã‚¿ã‚„è¡¨å®šç¾©ãŒå¤‰æ›´ã•ã‚Œã‚‹ã¨å›°ã‚‹æ“ä½œã®ã¨ãã«ã ã‘æŽ›ã‘ã‚‰ã‚Œã‚‹ã€‚ ä¾‹: æ›´æ–°äºˆå®šã®è¡Œã‚’å®£è¨€ã—ã¦ SELECT ã™ã‚‹(RSãƒãƒƒã‚¯)ã€ã‚¤ãƒ³ãƒ‡ãƒƒ
shin-uemon 2007/09/04
database

db

oracle

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

db

ã¾ã¨ã‚

tips
ãƒªãƒ³ã‚¯
SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†â€•â€•å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
shin-uemon 2007/09/03
ãªã‚‹ã»ã©ã¨æ€ã†ã‘ã©ã€æ±ºã—ã¦ã‚·ãƒ³ãƒ—ãƒ«ã§ã¯ãªã„

sql

tips

database

db

å‚è€ƒ
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: MySQLæœ€é©åŒ–ã®ãƒŸãƒ‹tips
yukiã§ã™ã€‚ ä»Šå›žã¯Webã‚µã‚¤ãƒˆã‚’è£½ä½œã™ã‚‹ä¸Šã§æ¬ ã‹ã›ãªã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹(DB)ã®ãŠè©±ã§ã™ã€‚Linuxã€Apache,MySQL,PHPã‚’çµ„ã¿åˆã‚ã›ãŸLAMPã¨ã„ã†è¨€è‘‰ãŒç™»å ´ã—ã¦ä¹…ã—ã„ã§ã™ãŒã€Webã‚µãƒ¼ãƒ“ã‚¹ã‚’æ§‹ç¯‰ã™ã‚‹ä¸Šã§æ¬ ã‹ã›ãªã„ã®ãŒDBã®å˜åœ¨ã§ã™ãã€‚ é‹ç”¨å¾ŒWebã‚µã‚¤ãƒˆãŒé †èª¿ã«æ‹¡å¤§ã—è¦æ¨¡ã‚‚å¤§ãããªã£ã¦ããŸé ƒã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«æ‚©ã‚€ã“ã¨ã‚‚å‡ºã¦ãã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚„æ§‹æˆã«å•é¡ŒãŒã‚ã‚‹å ´åˆã€ãƒã‚¸ãƒƒã‚¯ã«å•é¡ŒãŒã‚ã‚‹å ´åˆãªã©æ§˜ã€…ã§ã™ãŒã€DBã‚’è¦‹ç›´ã—ã¦ã¿ã‚‹ã®ã‚‚æ‰‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ éŠ€è¡Œã®é é‡‘æ®‹é«˜ãªã©ã®ã‚ˆã†ã«ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ã§ã‚ã‚‹å ´åˆã‚„ã€ã¨ã‚‚ã‹ããƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ€§ã‚’æ±‚ã‚ã‚‰ã‚Œã‚‹ãªã©æ§˜ã€…ã‚ã‚Šã€ä¸€æ¦‚ã«è¨€ãˆã‚‹ã‚‚ã®ã§ã‚‚ã‚ã‚Šã¾ã›ã‚“ãŒã€ Webã‚µãƒ¼ãƒ“ã‚¹ã«ãŠã„ã¦ã¯æœ‰åãª8ç§’ãƒ«ãƒ¼ãƒ«ã‚‚ã€æœ€è¿‘ã§ã¯6ç§’ã€3ç§’ã€1ç§’ã¨æ±‚ã‚ã‚‰ã‚Œã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯ã©ã‚“ã©ã‚“çŸããªã£ã¦æ¥ã¦ã„ã¾ã™ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã ã‘ã§ãªãã€ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚³
shin-uemon 2007/07/18
db

database

mysql

tips
ãƒªãƒ³ã‚¯
SQL Injection Cheat Sheet
Examples; (MS) means : MySQL and SQL Server etc. (M*S) means : Only in some versions of MySQL or special conditions see related note and SQL Server Table Of Contents About SQL Injection Cheat Sheet Syntax Reference, Sample Attacks and Dirty SQL Injection Tricks Line Comments SQL Injection Attack Samples Inline Comments Classical Inline Comment SQL Injection Attack Samples MySQL Vers
shin-uemon 2007/03/21
ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

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

security

db

database

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

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

tips

mysql
ãƒªãƒ³ã‚¯
1