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

Gln id:Gln

mysqlã¨SQLã«é–¢ã™ã‚‹Glnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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][Python]8000ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’Insertã™ã‚‹ | Momentum
æ¦‚è¦ ãƒ»ã¨ã‚ã‚‹ç‰©ä»¶ã§8000ä¸‡å¼±ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ–°è¦ã®DBã«åŠ¹çŽ‡çš„ã«ã¶ã¡è¾¼ã‚€æ–¹æ³•ã‚’è€ƒãˆã‚‹å¿…è¦ã« ãƒ»MySQL(Amazon RDS) + Python(mysql.connector)ã‚’æƒ³å®š ãƒ»mysql.connector + pythonã«ã¤ã„ã¦ã¯æ‹™æ–‡ãªãŒã‚‰(http://nekopuni.holy.jp/?p=927)ã«æ›¸ã„ã¦ãŠã‚Šã¾ã™ã€‚ ãƒ»ã‚³ãƒŸãƒƒãƒˆã®ä½ç½®ã«ã¯æ°—ã‚’ã¤ã‘ã‚ˆã† + Multiple Insertæœ€å¼·ãã¨ã„ã†ãŠè©±ã€‚ æ–¹æ³•ãã®1 ã¾ãšã¯æœ€åˆã«ã‚„ã£ãŸæ–¹æ³•ã€‚1ãƒ¬ã‚³ãƒ¼ãƒ‰ã”ã¨ã«Insertã—ã¦ã‚³ãƒŸãƒƒãƒˆã—ã¦ã„ãæ–¹æ³•ã€‚ ä»Šã¾ã§DBé–¢é€£ã§ã‚„ã£ãŸã‚³ãƒ¼ãƒ‰ã¯ãƒ¬ã‚³ãƒ¼ãƒ‰é‡ã‚‚å¤§ã—ãŸã“ã¨ãªã‹ã£ãŸã®ã§ä»¥ä¸‹ã®æ–¹æ³•ã§ã‚‚ç‰¹ã«å•é¡Œãªã‹ã£ãŸã€‚ å…·ä½“çš„ãªç’°å¢ƒã¨ã—ã¦ã¯ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿(csv)ã‚’èªã¿è¾¼ã¿ã€ãã‚Œã‚’DBã«Insertã—ã¦ã„ãã¨ã„ã†ã‚‚ã®ã€‚ csvã®ä¸èº«ã¯æ—¥ä»˜(DATE)ã¨ãƒ‡ãƒ¼ã‚¿å€¤(VALUE)ãŒã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã«ãªã£ã¦ã„
Gln 2014/05/04
mysql

python

db

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

sql
ãƒªãƒ³ã‚¯
MySQL Indexå‹‰å¼·ä¼šå¤–éƒ¨å…¬é–‹ç”¨
12. Â© CROOZ,Inc. 12 ï¼‘ï¼ŽINDEXã¨ã¯ãªã«ã‹ ä½•æžšç›®ãŒãªã«ã‹ã‚’äº‹å‰ã«ãƒ¡ãƒ¢ã£ã¦ãŠã‘ã°è‰¯ã„ï¼ ã‚¹ãƒ¼ãƒˆ ãƒ©ãƒ³ã‚¯ ä½ç½® ãƒãƒ¼ãƒˆ Q 1 ã‚¹ãƒšãƒ¼ãƒ‰ 9 2 : : : ãƒ€ã‚¤ãƒ¤ 1 40 : : : ã‚¹ãƒšãƒ¼ãƒ‰ 6 45 ãªãœãªã‚‰ã€è¦æ±‚ã¯ã€Œã‚«ãƒ¼ãƒ‰ã‚’å¼•ãå›žæ•°ã‚’æœ€ã‚‚å°‘ãªã ã—ã¦ã‚¹ãƒšãƒ¼ãƒ‰6ã‚’æŽ¢ã™ã“ã¨ã€ ã‚»ã‚³ã„ã¨ã‹ãŠã‚‚ã†ãƒ’ãƒˆã¯ã„ã‚‹ã‹ ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒä½•ã‚‚ã‚»ã‚³ã„ã“ ã¯ã—ã¦ã„ãªã„ã§ã™ã€‚ å‰ææ¡ä»¶ãªã©ä¸€åˆ‡ãªã„ã‹ã‚‰ ã“ã®ãƒ¡ãƒ¢ã•ãˆã‚ã‚Œã°ä½ç½®ã‚’æŒ‡å®šã—ã¦1å›žå¼•ã‘ã°æ¸ˆã‚€
Gln 2013/09/12
mysql

DB

database

performance

sql

slideshare
ãƒªãƒ³ã‚¯
æ›¸å¼æ–‡å—åˆ—ã«ã‚ˆã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒä¾‹
ä»¥ä¸‹ã®ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ãŒã‚ã‚Šã€nameã¯ç”»é¢å…¥åŠ›ãªã®ã§SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ãŒèµ·ã“ã‚‹ã®ã§ã¯ï¼Ÿ ã¨ä½œæˆè€…ã«ç¢ºèªã—ãŸã¨ã“ã‚ã€"%s"ã—ã¦ã‚ã‚‹ã‹ã‚‰å¤§ä¸ˆå¤«ã¨ã®è¿”äº‹ã‚’ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ ãƒãƒƒãƒˆèª¿ã¹ã‚‹ã¨mysql_real_escape_stringã§ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ã¦ã‹ã‚‰"%s"ã§å¤‰æ›ã™ã‚Œã°å¤§ä¸ˆå¤«ã¨ã„ã£ãŸå†…å®¹ã¯è¦‹ã¤ã‘ãŸã®ã§ã™ãŒã€mysql_real_escape_stringãªã©ä¸è¦ã¨ã®è¿”äº‹ã‚’ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ ãªãœï¼Ÿã¨èžãã¨ãã†ã„ã†ã‚‚ã®ã ã¨ã—ã‹å›žç”ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ã²ã©ã„ã§ã™ãã€‚ã“ã‚Œã¯è³ªå•è€…ãŒæ£ã—ãã€sprintfã®%sã§å—ã‘ãŸã ã‘ã§ã¯ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ã¨ãªã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€ã©ã†ã—ã¦ã“ã®ã‚ˆã†ãªé–“é•ã£ãŸçŸ¥è˜ãŒå‡ºã¦ããŸã®ã‹ã¨è€ƒãˆã‚‹ã«ã€æ•°å€¤ã‚’%dã§å—ã‘ã‚‹å ´åˆã¨æ··ä¹±ã—ãŸã®ã§ã¯ãªã„ã‹ã¨æ†¶æ¸¬ã—ã¾ã—ãŸã€‚æ•°å€¤ã®å ´åˆã€æ›¸å¼%dã§å—ã‘ã¦ã„ã‚Œã°ã€ä»®ã«æ”»æ’ƒã‚³ãƒ¼ãƒ‰ãŒå…¥åŠ›ã•ã‚ŒãŸã¨ã—ã¦ã‚‚ã€%dã§æ•´æ•°ã«å¼·åˆ¶å¤‰æ›ã•ã‚Œã‚‹ã®ã§ã€SQLã‚¤ãƒ³ã‚¸
Gln 2012/12/10
SQL

security

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

mysql

sql

DB

DBè¨è¨ˆ
ãƒªãƒ³ã‚¯
ã‚¯ãƒªã‚¢ãƒã‚ªã®å£ã‚³ãƒŸã£ã¦ä¿¡ã˜ã¦ã„ã„ï¼ŸåŠ¹æžœã¯ç¢ºå®Ÿãªã®ï¼Ÿ | æ„›ã¨å°ç”º
ã‚¯ãƒªã‚¢ãƒã‚ªã®ç‰¹å¾´ ç„¡æ·»åŠ ãƒ»ç„¡ç€è‰²ã ã‹ã‚‰è‚ŒãŒå¼±ã„äººã§ã‚‚å®‰å¿ƒ ãƒ¯ã‚ã‚¬ã‚„å«Œãªè‡ã„ã®åŽŸå› ã¨ãªã‚‹èŒã‚’æ®ºèŒãƒ»æ¶ˆæ¯’ ãŠå¾—ãªå®šæœŸã‚³ãƒ¼ã‚¹ã¯ã€è³¼å…¥ç¸›ã‚Šãªã—ï¼ã„ã¤ã§ã‚‚è§£ç´„å¯èƒ½ ä½“è‡ã®æ‚©ã¿ã¯è€è‹¥ç”·å¥³å•ã‚ãšå…±é€šã®æ‚©ã¿ã§ã™ãŒã€ä»–äººã«ã¯ç›¸è«‡ã—ã«ãã„ã®ã§1äººã§æ‚©ã‚“ã§ã„ã‚‹äººãŒå¤šã„ã‚“ã§ã™ã€‚ ä½“è‡ã£ã¦ã€è‡ªåˆ†ã§ãƒ‹ã‚ªã‚¤ãŒæ°—ã«ãªã£ãŸæ™‚ã¯ã€ä»–ã®äººã¯ã‚‚ã£ã¨ã‚¯ã‚µã‚¤ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã‚‚ã—ã‚ãªãŸãŒã€è‡ªåˆ†ã§ãƒ¯ã‚ã‚¬ã‹ã‚‚â€¦ã¨æ€ã†ã®ã§ã‚ã‚Œã°ã€å‘¨ã‚Šã®äººã¯ã‚ãªãŸã®ãƒ‹ã‚ªã‚¤ã«æ°—ã¥ã„ã¦ã„ã‚‹ã‹ã‚‚â€¦ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã€ãã‚“ãªãƒ¯ã‚ã‚¬è‡ã‚„è¶³ã®ãƒ‹ã‚ªã‚¤ãªã©ã€ã‚¤ãƒ¤ãƒ¼ãªä½“è‡å…¨èˆ¬ã‚’10ç§’ã§ã‚«ãƒƒãƒˆã—ã¦ãã‚Œã‚‹ã‚“ã§ã™ã€‚ ã‚¯ãƒªã‚¢ãƒã‚ªã®åŠ¹æžœã‚„å£ã‚³ãƒŸã‚’èª¿æŸ»ã—ã¾ã—ãŸã®ã§å¾¹åº•è§£èª¬ã—ã¾ã™ã€‚ è³¼å…¥æ™‚ã«ç‰¹å…¸ãŒä»˜ã„ã¦ãã‚‹ã®ã§ãŠå¾— å…¬å¼ã‚µã‚¤ãƒˆã¯ã‚³ãƒãƒ© â€»ç‰¹å…¸ã¯æ¯Žæœˆå¤‰ã‚ã‚‹ã®ã§å…¬å¼ã‚µã‚¤ãƒˆã§ã”ç¢ºèªãã ã•ã„ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã©ã‚“ãªäººã«ãŠã™ã™ã‚ï¼Ÿ ã‚¯ãƒªã‚¢ãƒã‚ªã®æ®ºèŒçŽ‡ã¯ã€ãªã‚“ã¨99.999%ï¼ä½“è‡ã®æ‚©ã¿ã‚’è§£æ¶ˆã—ã¦ãã‚Œã‚‹ã‚¯ãƒª
Gln 2012/07/24
MySQL

é‹ç”¨

DB

SQL
ãƒªãƒ³ã‚¯
å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã‚’æ´»ç”¨ã™ã‚‹
ãªãŠã‚µãƒ³ãƒ—ãƒ«ã§ã¯ãƒ•ã‚©ãƒ¼ãƒ å…¥åŠ›å€¤ã®ãƒã‚§ãƒƒã‚¯ã‚„MySQLã‚µãƒ¼ãƒã®è¨å®šã«ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã«å¯¾ã™ã‚‹è€ƒæ…®ãŒä¸è¶³ã—ã¦ã„ã¾ã™ã€‚ã¾ãŸã€ä¸»ã«ç®¡ç†è€…ãŒåˆ©ç”¨ã™ã‚‹ã€Œåœ¨åº«ç®¡ç†ã€æ©Ÿèƒ½ã¨ã€ä¸ç‰¹å®šã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒåˆ©ç”¨ã™ã‚‹ã€Œã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆã‚¢ã€æ©Ÿèƒ½ãŒåŒå±…ã—ã¦ã„ã‚‹ã†ãˆã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚„ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆèªè¨¼ã«ã‚ˆã‚‹ä½¿ç”¨è¦åˆ¶ã‚‚è¡Œã‚ã‚Œã¦ã„ã¾ã›ã‚“ã€‚ ä¸ç‰¹å®šã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰åˆ©ç”¨ã•ã‚Œã‚‹ã“ã¨ãŒãªã„ã‚ˆã†ã€å…¬é–‹ã•ã‚ŒãŸã‚µãƒ¼ãƒä¸Šã§ã®ä½¿ç”¨ã¯æŽ§ãˆã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ # cd /var/www/html # tar xvfz /..pathto../sample5.tgz # cd sample5 ã€Œsample5ã€ã‚’ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ«ãƒ¼ãƒˆã«å±•é–‹ã—ä½œæ¥ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ç§»å‹•ã€‚ Apacheã‚’ã‚½ãƒ¼ã‚¹ã‹ã‚‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ã¾ã¾ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸå ´åˆã¯ã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ«ãƒ¼ãƒˆã‚’/usr/local/apache2/htdocs/ãªã©ã«é©å®œå¤‰æ›´ã—ã¾ã™ # mysqladmin -u root
Gln 2011/06/05
ON DELETE CASCADE, ON UPDATE CASCADE

mysql

DB

SQL
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬1å›žï¼šSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œ (1/3)
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯ã€ã‚¯ã‚¨ãƒªãªã©ã®ä»»æ„ãƒ‡ãƒ¼ã‚¿ã‚’ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå®Ÿè¡Œã™ã‚‹SQLæ–‡ã«æŒ¿å…¥ã—ã¾ã™ã€‚æŒ¿å…¥ã•ã‚ŒãŸã‚¯ã‚¨ãƒªã¯ã€æ„å›³ã—ãªã„ãƒ‡ãƒ¼ã‚¿ã‚’æ¤œç´¢ã—ãŸã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æƒ…å ±ã‚’å¤‰æ›´ã—ãŸã‚Šå‰Šé™¤ã—ãŸã‚Šã™ã‚‹ã¨ã„ã†ã‚ˆã†ã«ã€æ§˜ã€…ãªæ“ä½œã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«è¡Œã„ã¾ã™ã€‚å•é¡Œã‚’å®Ÿè¨¼ã™ã‚‹ãŸã‚ã«æ¬¡ã®ä¾‹ã‚’è¦‹ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ // å•é¡Œã‚’å®Ÿè¨¼ã™ã‚‹ãŸã‚ã®å…¥åŠ› $name = "ilia'; DELETE FROM users;"; mysql_query("SELECT * FROM users WHERE name='{$name}'"); ä¸Šè¨˜ã®é–¢æ•°å†…ã§ã¯ã€ãƒ¦ãƒ¼ã‚¶ãŒæŒ‡å®šã—ãŸåå‰ã¨nameã‚«ãƒ©ãƒ ã®å€¤ãŒä¸€è‡´ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’usersãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰å–ã‚Šå‡ºã™ã“ã¨ã‚’æƒ³å®šã—ã¦ã„ã¾ã™ã€‚æ™®é€šã€$nameã«ã¯ã€iliaã¨ã„ã£ãŸæ–‡å—åˆ—ã®ã‚ˆã†ã«ã€ã‚¢ãƒ«ãƒ•ã‚¡ãƒ™ãƒƒãƒˆã¨ã‚¹ãƒšãƒ¼ã‚¹ã‹ã‚‰ã§ããŸæ–‡å—åˆ—ãŒæ ¼ç´ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã—ã‹ã—ã“ã“ã§ã¯ã€$nameã«ã¾ã£ãŸãæ–°ã—ã„ã‚¯ã‚¨ãƒª
Gln 2010/01/15
SQL

mysql

security

php
ãƒªãƒ³ã‚¯
1