[B! &MySQL] sankasekiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

sankaseki id:sankaseki

&MySQLã«é–¢ã™ã‚‹sankasekiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

${{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 CSVãƒ•ã‚¡ã‚¤ãƒ«å…¥å‡ºåŠ›
MYSQLã§ã®ã€ŒCSVãƒ•ã‚¡ã‚¤ãƒ«ã€ã®å…¥å‡ºåŠ›(ã‚¤ãƒ³ãƒãƒ¼ãƒˆã€ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ)æ–¹æ³•ã«ã¤ã„ã¦è¨˜è¼‰ã—ã¦ã„ã¾ã™ã€‚ Windowsã€Linuxã®ã©ã¡ã‚‰ã®ç’°å¢ƒã§ã‚‚ãƒ•ã‚¡ã‚¤ãƒ«ãƒ‘ã‚¹ã®è¨˜è¼‰ãŒå¤‰ã‚ã‚‹ã ã‘ã§ã‚³ãƒžãƒ³ãƒ‰ã¯åŒä¸€ã«ãªã‚Šã¾ã™ã€‚ å…¥åŠ›ã€€LOAD DATA INFILE ã€Œ,ã€ãªã©ã§åŒºåˆ‡ã‚‰ã‚ŒãŸCSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”¨æ„ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€MySQLã«é«˜é€Ÿã«ãƒ‡ãƒ¼ã‚¿ã‚’å…¥åŠ›ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ æ–‡å—ã®å›²ã¿æ–‡å—ãŒã€Œâ€ã€ã®ã¨ãã®ä½¿ç”¨ä¾‹ã§ã™ã€‚ å›²ã¿æ–‡å—ãŒå¿…è¦ãªã„ã¨ãã¯ENCLOSED BY â€˜â€â€˜ã‚’å¤–ã—ã¾ã™ã€‚ æ§‹æ–‡ LOAD DATA INFILE "ãƒ•ã‚¡ã‚¤ãƒ«å" INTO TABLE ãƒ†ãƒ¼ãƒ–ãƒ«å FIELDS TERMINATED BY ',åŒºåˆ‡ã‚Šæ–‡å—' ENCLOSED BY '"';
sankaseki 2009/03/20
MYSQLã€€CSVãƒ•ã‚¡ã‚¤ãƒ«å…¥å‡ºåŠ›

&Mysql

.Tips
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
sankaseki 2009/02/18
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•

&MySQL

.Tips
ãƒªãƒ³ã‚¯
MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½œæˆã¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ä½œæˆ
MySQLã‚’ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã€ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã—ãŸã‚‰ã€ ã¾ãšã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚Šã€ãã—ã¦ãã‚Œã‚’åˆ©ç”¨ã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’ä½œæˆã—ã¾ã™ã€‚ ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã®èµ·å‹• MySQLã®æ“ä½œã¯ã€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‚’ä½¿ã„ã¾ã™ã€‚ ã‚¹ã‚¿ãƒ¼ãƒˆ â†’ ã™ã¹ã¦ã®ãƒ—ãƒã‚°ãƒ©ãƒ â†’ ã‚¢ã‚¯ã‚»ã‚µãƒª â†’ ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆ ã‚’èµ·å‹•ã—ã¾ã™ã€‚ï¼ˆWindowsã®å ´åˆï¼‰ â€» > ã®å¾Œã®éƒ¨åˆ†ãŒã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‹ã‚‰ã®å…¥åŠ›ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆ ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒä½¿ã†ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã£ã¦ãŠãã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åï¼š user_dbã€€ã¨ã—ã¾ã™ã€‚ C:\> C:\mysql\bin\mysql -u root -p Enter password: è¨å®šã—ãŸãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ mysql> create database user_db; mysql> exit Bye C:\> exit â€» ã“ã“ã§ä½œã£ãŸã®ã¯ã€ç®±ã¨ã—ã¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚
sankaseki 2009/02/17
MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½œæˆã¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ä½œæˆ

&MySQL

.Tips
ãƒªãƒ³ã‚¯
http://www.mysql.gr.jp/
sankaseki 2008/11/17
æ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼š

&MySQL

&DB

=å…¬å¼ã‚µã‚¤ãƒˆ
ãƒªãƒ³ã‚¯
æ¤œç´¢æ¡ä»¶ã«æ¤œç´¢çµæžœã®å€¤ã‚’ä½¿ã† - æ–°ã ã‚‹ã‚ãè·¡åœ°
SELECT id,parent_id FROM child where id not like concat('%',parent_id,'%');
sankaseki 2008/10/08
æ¤œç´¢æ¡ä»¶ã«æ¤œç´¢çµæžœã®å€¤ã‚’ä½¿ã† - ã ã‚‹ã‚ã

&MySQL

.Tips
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
sankaseki 2008/08/19
ãƒ–ãƒ©ã‚¦ã‚¶ã‹ã‚‰å¿«é©ã«ä½¿ãˆã‚‹MySQLç®¡ç†ãƒ„ãƒ¼ãƒ«ã€ŽSQL Buddyã€ã‚’è©¦ã—ã¦ã¿ãŸ | IDEA*IDEA

!GTD è³‡æ–™(ã„ã¤ã‹ä½¿ã†)

!æ°—ã«ãªã‚‹|ä½¿ãˆã‚‹

&MySQL
ãƒªãƒ³ã‚¯
MSN Japan - ãƒ‹ãƒ¥ãƒ¼ã‚¹, å¤©æ°—, ãƒ¡ãƒ¼ãƒ« (Outlook, Hotmail), Bingæ¤œç´¢, Skype
sankaseki 2008/08/14
MSNç›¸è«‡ç®± mysqlã®LOADã§ã‚ªãƒ¼ãƒˆã‚³ãƒŸãƒƒãƒˆã‚ªãƒ•ã«ã™ã‚‹ã«ã¯ï¼Ÿ

!è³‡æ–™

&MySQL

.ã‚ªãƒ¼ãƒˆã‚³ãƒŸãƒƒãƒˆã‚ªãƒ•
ãƒªãƒ³ã‚¯
GIGAZINE - GIGAZINEã®LoadAvarageã‚’ã€Œ27ã€ã‹ã‚‰ã€Œ2ã€ã¸ä¸‹ã’ãŸæ–¹æ³•
ã“ã“3æ—¥é–“ãã‚‰ã„è¶…çµ¶ãªé‡ã•ã ã£ãŸã®ã¯ã‚µãƒ¼ãƒã«ç‰©ç†çš„ãƒˆãƒ©ãƒ–ãƒ«ãŒç™ºç”Ÿã—ãŸã‹ã‚‰ã§ã¯ãªãã€å˜ç´”ã«é–²è¦§è€…æ•°ãŒæº€å“¡å¾¡ç¤¼ã¨ãªã‚Šã€å„æ™‚é–“ã§å€å¢—ã—ãŸãŸã‚ã§ã™ã€‚LoadAverageã¯ã²ã©ã„ã¨ãã§15åˆ†é–“ã®å¹³å‡å€¤ã€Œ27.1ã€ç¨‹åº¦ã€‚çž¬é–“æœ€å¤§é¢¨é€Ÿã ã¨ã‚‚ã£ã¨é«˜ã„ã§ã™â€¦â€¦æ˜Žã‚‰ã‹ã«ã¾ãšã„ã€‚ ã¨ã„ã†ã‚ã‘ã§ã€Apacheã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã§ä»Šã¾ã§ã¯å¤§ä¸ˆå¤«ã ã£ãŸã®ã§ã™ãŒã€ã¤ã„ã«é«˜è² è·ã‚µã‚¤ãƒˆç”¨ã®è¨å®šã«å¤‰æ›´ã›ã–ã‚‹ã‚’å¾—ãªããªã‚Šã¾ã—ãŸã€‚ ãã®ãŸã‚ã€å®Ÿéš›ã«è¡Œã£ãŸå¯¾å‡¦æ–¹æ³•ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚1æ—¥30ä¸‡PVè¿‘ã„å‹•çš„ã‚µã‚¤ãƒˆã®é«˜è² è·ã‚’ç·©å’Œã•ã›ã‚‹æ–¹æ³•ã¨ã—ã¦å‚è€ƒã«ãªã‚Œã°å¹¸ã„ã§ã™ã€‚ ã¾ãšå¤§å‰æã¨ã—ã¦ã€æ—¢ã«DNSé€†å¼•ãã‚„.htaccessã®ä½™è¨ˆãªèªã¿è¾¼ã¿ãªã©ã¯åœæ¢ã•ã›ã¦ã„ã¾ã—ãŸã€‚ä¸‹è¨˜ãƒšãƒ¼ã‚¸ã«æ›¸ã„ã¦ã‚ã‚‹ã“ã¨ã¯å®Ÿè¡Œæ¸ˆã¿ã€‚ ï¼ ITï¼šApacheãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®å®Ÿè·µï¼ˆ1/2ï¼‰ ã“ã®çŠ¶æ…‹ã§è² è·ãŒ15åˆ†å¹³å‡ã§ã€Œ27ã€ã«ãªã£ã¦ã„ãŸã‚ã‘ã§ã™ã€‚ ã¾ãŸã€LoadA
sankaseki 2008/04/21
GIGAZINE - GIGAZINEã®LoadAvarageã‚’ã€Œ27ã€ã‹ã‚‰ã€Œ2ã€ã¸ä¸‹ã’ãŸæ–¹æ³•

!è³‡æ–™

#apache

&MySQL

.ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
ä»²æ˜¥ã¯ã‚†ã£ãã‚Šã¨é€šã‚ŠéŽãŽã‚‹ å¯ã¦èµ·ããŸã‚‰3æœˆã§ã‚ã‚‹ã€‚ä»Šæ—¥ã®æ±äº¬ã®æœ€é«˜æ°—æ¸©ã¯20åº¦ã‚’è¶…ãˆã¦ã„ã‚‹ã€‚æ£æœˆã®ã‚¤ãƒ³ãƒ•ãƒ«ã‚¨ãƒ³ã‚¶ãŒå®Œæ²»ã—ã¦ã€ã“ã‚Œã§ã‚„ã£ã¨å¥åº·ã§æ–‡åŒ–çš„ãªæœ¬å¹´åº¦ã‚’å§‹ã‚ã‚‰ã‚Œã‚‹ãžã€ã¨æ„æ°—è¾¼ã‚“ã ã®ã‚‚æŸã®é–“ã€ä»Šåº¦ã¯åŽŸå› ä¸æ˜Žã®é«˜ç†±ã‚’å‡ºã—ã¦1é€±é–“å¯è¾¼ã‚“ã ã€‚ è„³ãŒã‚°ãƒ„ã‚°ãƒ„ç…®ãˆã‚‹éŸ³ãŒè´ã“ãˆãã†ãªã»ã©â€¦
sankaseki 2008/03/20
MySQLã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸€è¦§ã‚’è¡¨ç¤ºã™ã‚‹æ–¹æ³• - ä½è—¤ä¼¸å¾ã®ãƒ•ã‚£ã‚¸ã‚«ãƒ«/ãƒ¦ãƒ“ã‚ã‚¿ã‚¹ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°

&MySQL

.Tips
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
2024å¤ä¼‘ã¿æ—…è¡Œã€€ç¥žæˆ¸ãƒ»2æ—¥ç›®ã€å‰ç·¨ã€‘ zfinchyan.hatena blog.com â†‘ï¼‘æ—¥ç›®ã¯ã“ã¡ã‚‰ 6:50 ã‚ãŸã—ã¨å¤«ã ã‘å…ˆã«èµ·åºŠ å‰æ—¥ã«è²·ã£ã¦ãŠã„ãŸãŠèŠ‹ã®ãƒ‘ãƒ³ã§æœã”ã¯ã‚“ æ˜¨æ—¥ã®ç–²ã‚Œã‹ã‚‰ã‹ã€ãªã‹ãªã‹æ¯åãŸã¡ãŒèµ·ãã¦ã“ãªã‹ã£ãŸã®ã§ã€ã‚†ã£ãã‚Šå¯ã‹ã›ã¦ã‹ã‚‰10:00ã«ãƒ›ãƒ†ãƒ«ã®ä¸‹ã«ã‚ã‚‹ãƒ—ãƒ¬ã‚¤ã‚¾ãƒ¼ãƒ³ã«è¡Œã£ã¦ã€ãƒ‘ã‚¿ãƒ¼ã‚´ãƒ«ãƒ•ã‚„ãƒã‚¹â€¦
sankaseki 2008/03/20
MySQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§ã‚’è¡¨ç¤ºã™ã‚‹æ–¹æ³• - ä½è—¤ä¼¸å¾ã®ãƒ•ã‚£ã‚¸ã‚«ãƒ«/ãƒ¦ãƒ“ã‚ã‚¿ã‚¹ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°

&MySQL

.Tips
ãƒªãƒ³ã‚¯
1