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

ken_c_lo id:ken_c_lo

mysqlã«é–¢ã™ã‚‹ken_c_loã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (23)

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

MacBookAirã§Homebrewã‚’ä½¿ã£ãŸMySQL 5.5.14ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« | DevelopersIO
Macã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« MacBook Airã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã®ã§ãƒ¡ãƒ¢ã‚’å…±æœ‰ã—ã¾ã™ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«ã¯Homebrewã¨ã„ã†ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ç®¡ç†ã‚¢ãƒ—ãƒªã‚’ç”¨ã„ã¾ã™ã€‚ OS : Mac OS X Lion 10.7.1 DB : MySQL 5.5.14 Homebrewã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Homebrewã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ã¨ã¦ã‚‚ç°¡å˜ã§ã™ã€‚ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã§æ›¸ã‘ã¾ã™ã€‚ç´ æ•µã§ã™ã€‚ $ /usr/bin/ruby -e "$(curl -fsSL https://raw.github.com/gist/323731)" MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Homebrewã‚’ä½¿ãˆã°ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚ã‚³ãƒžãƒ³ãƒ‰ï¼‘å›žã§ã™ã€‚3åˆ†ã»ã©å¾…ã¡ã¾ã™ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å®Œäº†ã§ã™ã€‚ $ brew install mysql ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã™ã‚‹ brewã§MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ã€ã„ã‚ã„ã‚ã¨æ³¨æ„æ›¸ããŒè¡¨ç¤ºã•ã‚Œã¦ã„ã¾ã™ã€‚
ken_c_lo 2012/08/21
mysql
ãƒªãƒ³ã‚¯
MySQL :: MySQL Workbench
è¨è¨ˆ MySQL Workbench ã¯ã€ DBAã€é–‹ç™ºè€…ã€ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆã€ä½œæˆã€ç®¡ç†ã‚’ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ«ã«è¡Œã†ã“ã¨ãŒã§ãã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ©ãƒ¼ãŒè¤‡é›‘ãª ER ãƒ¢ãƒ‡ãƒ«ã®ä½œæˆã€ãƒ•ã‚©ãƒ¯ãƒ¼ãƒ‰ãŠã‚ˆã³ãƒªãƒãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ä½œæ¥ã‚’è¡Œã†ãŸã‚ã«å¿…è¦ãªæ©Ÿèƒ½ã‚’å«ã¿ã€é›£ã—ã„å¤‰æ›´ç®¡ç†ã‚„ã€é€šå¸¸ã‹ãªã‚Šã®æ™‚é–“ã¨åŠ´åŠ›ã‚’å¿…è¦ã¨ã™ã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ä½œæ¥ã®ç‚ºã®é‡è¦ãªæ©Ÿèƒ½ãªã©ã‚‚å«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ è©³ã—ãã¯ã“ã¡ã‚‰Â Â» é–‹ç™º MySQL Workbench ã¯ã€SQL ã‚¯ã‚¨ãƒªãƒ¼ã®ä½œæˆã€å®Ÿè¡Œã€æœ€é©åŒ–ã‚’ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ«ã«è¡Œãˆã‚‹ãƒ„ãƒ¼ãƒ«ã‚’å‚™ãˆã¦ã„ã¾ã™ã€‚SQL ã‚¨ãƒ‡ã‚£ã‚¿ã¯ã€ã‚·ãƒ³ã‚¿ãƒƒã‚¯ã‚¹ã®ã‚«ãƒ©ãƒ¼ãƒã‚¤ãƒ©ã‚¤ãƒˆã€è‡ªå‹•è£œå®Œã€SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã®å†åˆ©ç”¨ã€SQL ã®å®Ÿè¡Œå±¥æ´æƒ…å ±ã‚’æä¾›ã—ã¾ã™ã€‚Database Connections Panel ã«ã‚ˆã£ã¦ MySQL Fabric ã‚’å«ã‚€ä¸€èˆ¬çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®ç®¡ç†ãŒå®¹æ˜“ã«ãªã‚Šã¾ã™ã€‚
ken_c_lo 2012/07/26
mysql
ãƒªãƒ³ã‚¯
ã€Linuxã€‘Xamppï¼ˆlamppï¼‰ã®MySQLã‚’è¤‡æ•°èµ·å‹•
ã™ã§ã«MySQLãŒå‹•ã„ã¦ã„ã‚‹ç’°å¢ƒã«Lamppã‚’å°Žå…¥ã—ãŸã¨ãã®ãƒ¡ãƒ¢ã€‚ç’°å¢ƒã¯CentOS Lamppã®åŸºæœ¬çš„ãªã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯å‰ã®è¨˜äº‹ã‚’å‚ç…§ã€‚è§£å‡ã™ã‚‹ã ã‘ãªã‚“ã ã‘ã©ãƒ»ãƒ»ãƒ» èª¬æ˜Žã—ã¥ã‚‰ã„ã‹ã‚‰ /opt ã«è§£å‡ã™ã‚‹ã¨ã“ã‚ã‹ã‚‰ $ cd /opt $ tar xzvf xampp-linux-upgrade-1.7.0-1.7.1.tar.gz è‡ªå‹•èµ·å‹•ã®è¨å®š $ cp /opt/lampp/lampp /etc/rc.d/init.d/ $ chkconfig --add lampp ã“ã“ã‹ã‚‰æœ¬é¡Œã€‚MySQLã®confãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç·¨é›†ã—ã¦èµ·å‹•ãƒãƒ¼ãƒˆã‚’å¤‰æ›´ï¼ˆãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒãƒ¼ãƒˆã¯3306ï¼‰ã€‚ $ vi /opt/lampp/etc/my.cnf [client] port = 3308 [mysqld] port = 3308 lamppã®èµ·å‹•ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®ä¸ã«3306ãŒç›´æ›¸ãã•ã‚Œã¦ã„ã‚‹ã®ã§ç·¨é›† $ vi
ken_c_lo 2011/11/09
$ vi /opt/lampp/etc/my.cnf [client] port = 3308 [mysqld] port = 3308

xampp

mysql
ãƒªãƒ³ã‚¯
MySQL ãŒ "Manager of pid-file quit without updating file." ã¨è¡¨ç¤ºã—ã¦èµ·å‹•ã—ãªããªã£ãŸå ´åˆã®å¯¾å¿œ - tomoyamkungã®æ—¥è¨˜
å®Ÿè¡Œç’°å¢ƒã‚’æ›¸ã„ã¦ã—ã¾ã†ã¨ç‰¹å®šã•ã‚Œã¦ã—ã¾ã†ã®ã§ç«¯æŠ˜ã‚‹ã‹ã‚‰ã€Œï¼Ÿã€ãªéƒ¨åˆ†ã‚‚ã‚ã‚‹ã‘ã©ï¼Œã„ã‚ã„ã‚èª¿ã¹ãŸã®ã§ãƒ¡ãƒ¢ãƒ¡ãƒ¢ï¼Ž ã¾ãšï¼Œä¸Šè¨˜ã®ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’åã„ã¦èµ·å‹•ã—ãªããªã‚‹åŽŸå› ã¯ï¼Œä¸»ã«ï¼”ã¤ã‚ã‚‹ã¨ã®ã“ã¨ï¼Ž æ¨©é™ã®è¨å®šãŒä¸é©åˆ‡ MySQL ã® pid ãƒ•ã‚¡ã‚¤ãƒ«ãŒæ®‹ã£ã¦ã„ã‚‹ MySQL ã®ãƒ—ãƒã‚»ã‚¹ãŒç”Ÿãæ®‹ã£ã¦ã„ã‚‹ è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã®è¨˜è¿°ã«èª¤ã‚ŠãŒã‚ã‚‹ ï¼‘ã¯è¦‹ç›´ã›ã°ã‚ˆã„ã¨ã—ã¦ï¼Œï¼’ã«é–¢ã—ã¦ã¯ã¡ã‚‡ã£ã¨å¼·å¼•ã ã‘ã© # find / -name *.pid ã§æŽ¢ã›ã‚‹ã—ï¼Œï¼“ã‚‚ # ps ax | grep mysql ã§æŽ¢ã›ã‚‹ï¼Ž ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚ŒãŸã‚ã¨ã«ï¼Œfind ã‚‚ ps ã‚‚ã—ã¦ã¿ãŸã‘ã©ï¼Œå¼•ã£ã‹ã‹ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚ãƒ—ãƒã‚»ã‚¹ã‚‚ãªã‹ã£ãŸï¼Žãªã®ã§ï¼Œï¼”ã¨ã„ã†ã“ã¨ã«ãªã‚‹ï¼ŽåŠ ãˆã¦ï¼Œ"mysql_install_db" ã‚’å®Ÿè¡Œã—ãŸã¨ãã«ã€Œ"skip-federated" ãªã‚“ã¦ã‚ªãƒ—ã‚·ãƒ§ãƒ³çŸ¥ã‚‰ãªã„ã‚ˆã€ã¨ MySQL ã«æ€’ã‚‰ã‚Œã‚‹ã®ã§ã¾ã™ã¾
ken_c_lo 2011/09/27
mysql
ãƒªãƒ³ã‚¯
Mac OS 10.5ã«MySQLã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« | ç´ æ™´ã‚‰ã—ãå“‰ã€äººç”Ÿï¼
å‰å›žã€Macã§PHPãŒä½¿ç”¨å‡ºæ¥ã‚‹ã‚ˆã†ã«è¨å®šã—ãŸã®ã«å¼•ãç¶šãã€ MySQLã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ãŸã€‚ ãªã«ã¶ã‚“çŸ¥è˜ãŒæµ…ã„ã®ã§ã€ã“ã®ä½œæ¥ã«ã‚‚ã‹ãªã‚Šã®è‹¦åŠ´ã‚’ä¼´ã£ãŸã€‚ å¿˜ã‚Œãªã„ã‚ˆã†ã«ãƒ¡ãƒ¢çš„ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã€‚ 1. MySQL5.0ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ MySQLã®ã‚µã‚¤ãƒˆã‹ã‚‰dmgãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚ ç¾æ™‚ç‚¹ã®æœ€æ–°ç‰ˆã¯Mysql5.0.51a http://dev.mysql.com/downloads/mysql/5.0.html#downloads ã¡ãªã¿ã«Mac OS10.5ã«ã¯ã€x86ã¨x86_64-bitãŒç”¨æ„ã•ã‚Œã¦ã‚‹ãŒã€ è‡ªåˆ†ã¯x86_64-bitã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸã€‚ å¤šåˆ†ã©ã¡ã‚‰ã§ã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«ã¯å•é¡Œç„¡ã„ã¨æ€ã†ãŒã€ å®Ÿéš›ã®ã¨ã“ã‚è©¦ã—ã¦ãªã„ã®ã§åˆ†ã‹ã‚‰ãªã„ã€‚ 2.MySQL5.0ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ãƒ‡ã‚£ã‚¹ã‚¯ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’å±•é–‹ã—ãŸã‚‰mysql-5.0.51a-osx10.5-x86_64.pkgã‚’ãƒ€ãƒ–ãƒ«ã‚¯
ken_c_lo 2011/09/15
mysql
ãƒªãƒ³ã‚¯
macOSã§ã‚µãƒ¼ãƒãƒ¼ç¨¼æ¥ & ã©ã†ã›ç–²ã‚Œã‚‹ãªã‚‰ã€ã§ãã‚ãŒã£ãŸã‚‚ã®ã‚’ã©ã†æ´»ã‹ã™ã‹ã§ç–²ã‚ŒãŸã„ã‚ˆã
ã‚¯ãƒªãƒƒã‚¯ã§æ‰‹è»½ã«iOSã‚„Macã¨è¦ªå’Œæ€§ã®é«˜ã„ã‚µãƒ¼ãƒãƒ¼é‹ç”¨ãŒã§ãã‚‹ã€ãã‚“ãªå¤¢ã‚’èƒŒè² ã£ã¦ãƒ‡ãƒ“ãƒ¥ãƒ¼ã—ãŸServer.appã¯ã€æ°—ãŒã¤ã‘ã°ã€ãã®å½¹å‰²ã‚’ç¸®å°ã—ç´°ã€…ã¨ã—ãŸå˜åœ¨ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚åŒæ™‚ã«ã€ãã®æŽ²ã’ã‚‰ã‚ŒãŸå¤¢ã«ã™ãŒã£ã¦æ©æµã‚’å—ã‘ã¦ã„ãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ãŸã¡ã¯ã€è·¯é ã«è¿·ã†æ™‚ä»£ã«ãªã‚Šã¾ã—ãŸã€‚ ä¸å°ã‚ªãƒ•ã‚£ã‚¹å‘ã‘ã‚µãƒ¼ãƒãƒ¼ã‚’ç°¡å˜ã«æ§‹ç¯‰ã€ç®¡ç†ã§ãã‚‹ã¨ã„ã†ä½ç½®ã¥ã‘ã§ã®Server.appã®æä¾›ã¯ãªããªã‚Šã¾ã—ãŸã€‚ã—ã‹ã—ã€ãã®å‘ã“ã†å´ã«ã¯ã€ã‹ã¤ã¦ã¨å¤‰ã‚ã‚‰ãªã„ãƒ‘ãƒ¯ãƒ•ãƒ«ãªç’°å¢ƒãŒå¼•ãç¶™ãŒã‚Œã¦ã„ã¾ã™ã€‚ã“ã“ã§ã¯ã€Server.appã«é ¼ã‚‰ãšã€macOSã®åŸºæœ¬æ§‹æˆã‚’ä¸å¿ƒã«ã€ã¡ã‚‡ã£ã¨å°ã•ãªã‚ªãƒ•ã‚£ã‚¹ã‚„è‡ªå®…å‘ã‘ã®ã‚µãƒ¼ãƒãƒ¼ç’°å¢ƒã‚’æ§‹ç¯‰ã€é‹ç”¨ã™ã‚‹æ–¹æ³•ã‚’è€ƒãˆã¦ã„ãã¾ã™ã€‚
ken_c_lo 2011/09/15
mysql
ãƒªãƒ³ã‚¯
Macã®ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã§MySQL Â» Revolution009's Blog
2009å¹´9æœˆ30æ—¥ï¼ˆæ°´ï¼‰ ãƒžãƒƒã‚¯ã®ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‚’ä½¿ã£ã¦ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®MySQLã‚’æ“ä½œã—ã¦ã¿ã‚‹ã€‚ ã€MySQLã®æŽ¥ç¶šã€‘ ~akaishishingo$ ï¼ˆã‚³ã‚³ä»¥ä¸‹ã‚’å…¥åŠ›ï¼‰ /usr/local/mysql/bin/mysql -u root -p ï¼ˆä»Šã®ãƒˆã‚³ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¯rootã«ã—ã¦ã„ã‚‹ï¼‰ Enter password: ã€å¤§æ–‡å—å°æ–‡å—ã®å…¥åŠ›ã€‘ ã€Œcaps lockã€ã‚’æŠ¼ã›ã°ã€å¤§æ–‡å—ï¼å°æ–‡å—å…¥åŠ›ã‚’åˆ‡ã‚Šæ›¿ãˆã‚‰ã‚Œã‚‹ã€‚ ã€ã‚¿ãƒ¼ãƒŸãƒŠãƒ«å†…ã§ã®æ—¥æœ¬èªžå…¥åŠ›ã€‘ è¨å®šè‡ªä½“ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§OKã€‚ãŸã ã—ã€ã€Œã‚¯ã‚»ã€ãŒã‚ã‚Šã€ã“ã®ã¸ã‚“ã¯æ³¨æ„ã—ã¦å–ã‚Šçµ„ã‚€ã¹ãã‹ï¼Ÿï¼Ÿ 1.ã€Œcaps lockã€ã‚’æŠ¼ã—ã¦ã‹ã‚‰ã€Œã‹ãªã€ã«ã—ã¦å…¥åŠ›ã—ãªã„ã¨ã€ç¢ºå®šã•ã›ãŸã‚‰åŒ–ã‘ã‚‹ã€‚ 2.æ¨ªä¸€åˆ—ã®æ—¥æœ¬èªžå…¥åŠ›æ–‡å—æ•°ãŒã‚ã‚‹ä¸€å®šä»¥ä¸Šã ã¨ã€ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã®å‹•ä½œãŒä¸Šæ‰‹ãåŠ¹ã‹ãªããªã‚‹ï¼ˆcommand + Qã§å¼·å¼•ã«é–‰ã˜ã‚‹ã—ã‹ãªããªã‚‹ï¼‰ã€‚ ã€macã®ã„ã–ã¨ã„
ken_c_lo 2010/04/27
æ—¥æœ¬èªžæ–‡å—åŒ–ã‘â†’mysql>set names utf8;

mysql
ãƒªãƒ³ã‚¯
accessclub.jpÂ -Â ã“ã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã¯è²©å£²ç”¨ã§ã™ï¼Â -Â ã‚¢ã‚¯ã‚»ã‚¹ã‚¯ãƒ©ãƒ– ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
This webpage was generated by the domain owner using Sedo Domain Parking. Disclaimer: Sedo maintains no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo nor does it constitute or imply its association, endorsement or recommendation.
ken_c_lo 2010/04/11
mysql
ãƒªãƒ³ã‚¯
MySQLã¸éƒµä¾¿ç•ªå·ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ | Fuzyã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ï¼ˆï¼Ÿï¼‰ãƒ¡ãƒ¢ - æ¥½å¤©ãƒ–ãƒã‚°
December 11, 2005 MySQLã¸éƒµä¾¿ç•ªå·ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ ã‚«ãƒ†ã‚´ãƒªï¼šã‚«ãƒ†ã‚´ãƒªæœªåˆ†é¡ž MySQLã¸CSVã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹æ–¹æ³•ã§ã™ã€‚ CSVã¨ã¯ã€Comma Separated Values ã®ç•¥ã§ã€ãƒ‡ãƒ¼ã‚¿ã‚’ã‚«ãƒ³ãƒžï¼ˆ,ï¼‰ã§åŒºåˆ‡ã£ã¦ä¸¦ã¹ãŸãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’æŒ‡ã—ã¾ã™ã€‚Excelãªã‚“ã‹ã§ã‚‚ã€[åå‰ã‚’ä»˜ã‘ã¦ä¿å˜]ã®ã¨ãã«ã€CSVå½¢å¼ã‚’é¸ã¹ãŸã‚Šã—ã¾ã™ãã€‚ã‚‚ã¡ã‚ã‚“ã€Accessç‰ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚‚CSVå‡ºåŠ›ã¯å¯¾å¿œã—ã¦ã„ã¾ã™ã—ã€ã“ã†ã„ã£ãŸç•°ãªã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–“ã§ã€ãƒ‡ãƒ¼ã‚¿ã‚’ç§»è¡Œã™ã‚‹éš›ã«ã€CSVå½¢å¼ã¯é »ç¹ã«ä½¿ã‚ã‚Œã‚‹ã®ã§ã™ã€‚ â– CSVã®ä¾‹ 0640941,"åŒ—æµ·é“","æœå¹Œå¸‚ä¸å¤®åŒº","æ—ã‚±ä¸˜" 0600041,"åŒ—æµ·é“","æœå¹Œå¸‚ä¸å¤®åŒº","å¤§é€šæ±" 0600042,"åŒ—æµ·é“","æœå¹Œå¸‚ä¸å¤®åŒº","å¤§é€šè¥¿ï¼ˆï¼‘ï½žï¼‘ï¼™ä¸ç›®ï¼‰" 0640820,"åŒ—æµ·é“","æœå¹Œå¸‚ä¸å¤®åŒº","å¤§é€šè¥¿ï¼ˆï¼’ï¼ï½žï¼’
ken_c_lo 2010/04/08
MySQL
ãƒªãƒ³ã‚¯
MySQLã‚¯ã‚¤ãƒƒã‚¯ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ã“ã®æ–‡æ›¸ã¯ã€osCommerceã§ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹MySQLã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ãŠã‚‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†è€…ã‚ˆã‚Šã‚‚ã€ãƒ¦ãƒ¼ã‚¶ã«å‘ã‘ã¦æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« ã“ã“ã§ã¯ã€MySQLã‚µãƒ¼ãƒã¯èµ·å‹•ã—ã¦ã„ã‚‹ã‚‚ã®ã¨ã—ã¦èª¬æ˜Žã—ã¾ã™ã€‚ MySQLã®æ–‡å—ã«ã¤ã„ã¦ MySQLã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã®å¤§æ–‡å—ã¨å°æ–‡å—ã‚’åŒºåˆ¥ã—ã¦ã„ã¾ã™ã€‚ãã‚Œä»¥å¤–ã¯åŒºåˆ¥ã—ã¾ã›ã‚“ã€‚ MySQLã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã«ä½¿ãˆã‚‹æ–‡å—ã¯ã€è‹±æ•°å—ã¨_ï¼ˆã‚¢ãƒ³ãƒ€ãƒ¼ãƒãƒ¼ï¼‰ã€$ã€ã‚µãƒ¼ãƒã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã«ã‚ã‚‹æ–‡å—ã§ã™ã€‚ çŸ¥ã£ã¦ãŠããŸã„ã‚³ãƒžãƒ³ãƒ‰ mysqladminï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆãƒ»å‰Šé™¤ã‚„ã€MySQLã‚µãƒ¼ãƒã®æƒ…å ±ã‚’å¾—ã‚‹ï¼‰ mysqlshowï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®æƒ…å ±ã‚’è¡¨ç¤ºã™ã‚‹ï¼‰ mysqlï¼ˆMySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®èµ·å‹•ï¼‰ mysqldumpï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ€ãƒ³ãƒ—ã™ã‚‹ï¼‰ myisamchkï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«
ken_c_lo 2010/03/31
mysql
ãƒªãƒ³ã‚¯
MySQLã®ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨Finkã®ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - yuhei.kagaya
ã¾ãˆã«é–‹ç™ºç’°å¢ƒæ•´ãˆã‚ˆã†ã‹ãªã¨Apacheã€PHPã€MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã€‚ http://d.hatena.ne.jp/yuhei_kagaya/20070915/1189843852 ã‘ã©ã€ã„ã£ãŸã‚“ãã‚Œã„ã«ã—ãŸã„ã¨ã„ã†ã“ã¨ã§ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ MySQLã®ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒè¨å®šã«ãƒ‘ãƒãƒ«ã¨ã‹ã‚ã‚‹ã®ã§ã€ãã‚Œã‚‚ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ # rm -rf /usr/local/mysql # rm -rf /Library/StartupIt ems/MYSQL # rm -rf /Library/PreferencePanes/MySQL.prefPane Finkã®ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Finkãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®F.A.Qã«è¼‰ã£ã¦ãŸã€‚ è³ªå•5.6: Fink ã‚’å…¨ã¦ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã«ã¯? å›žç”: Fink ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã¯ã»ã¨ã‚“ã© /sw (ã‚ã‚‹ã„ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«é¸æŠžã—ãŸ
ken_c_lo 2010/03/13
mysql
ãƒªãƒ³ã‚¯
MySQLã®è¨å®šãŒã†ã¾ãã„ã‹ãªã„æ™‚ã®å¯¾ç–
å°Žå…¥è‡ªä½“ã¯aptã‚’ä½¿ã£ã¦ã•ãã£ã¨çµ‚ã‚ã‚‹MySQLã§ã™ãŒã€ã„ã–ç«‹ã¡ä¸Šã’ã¦ã¿ã‚‹ã¨ï¼’å°ã‚„ã£ã¦ï¼’å°ã¨ã‚‚å¤±æ•—ã€‚ãã®æ™‚ã®è§£æ±ºæ–¹æ³•ã€‚ã¡ãªã¿ã«ç’°å¢ƒã¯CentOS 4.3ã§ã™ã€‚ ãã®ï¼‘ï¼š"/tmp"ã®ã‚¢ã‚¯ã‚»ã‚¹æ¨©ãŒæ£ã—ããªã„ ã‚¨ãƒ©ãƒ¼ãƒã‚°(/var/log/mqsqld.log)ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãŒå‡ºåŠ›ã•ã‚Œã¾ã™ã€‚ 060526 16:00:42 mysqld started /usr/libexec/mysqld: Can't create/write to file '/tmp/ibFNQH8i' (Errcode: 13) 060526 16:00:42 InnoDB: Error: unable to create temporary file; errno: 13 060526 16:00:42 [ERROR] Can't init databases 060526 16:00:42 [ERROR]
ken_c_lo 2010/03/04
mysql
ãƒªãƒ³ã‚¯
http://www.mysql.gr.jp/Manual/mysql-3.21.31/manual_Problems.html
ken_c_lo 2010/03/04
mysql
ãƒªãƒ³ã‚¯
CakePHP MySQL ã§æ–‡å—åŒ–ã‘ã‚’é˜²ãè¨å®š | Sun Limited Mt.
MySQL ã§æ–‡å—åŒ–ã‘ã‚’é˜²ããŸã‚ã«ã¯ SET NAMES utf8 ã®ã‚ˆã†ã« SET NAMES ã‚’å®Ÿè¡Œã™ã‚‹ã®ãŒæœ‰åŠ¹ãªã®ã§ã™ãŒã€ã“ã‚Œã‚’ app/config/database.php ã§è¨å®šã™ã‚‹æ–¹æ³•ã§ã™ã€‚ 'encoding'=>'æ–‡å—ã‚³ãƒ¼ãƒ‰' ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨å®šé …ç›®ã«è¿½åŠ ã—ã¦ã‚„ã‚‹ã ã‘ã§ã™ã€‚ å…·ä½“çš„ã«ã¯ app/config/database.php ãŒä¸‹è¨˜ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ var $default = array( 'driver' => 'mysql', 'connect' => 'mysql_connect', 'host' => 'localhost', 'login' => 'user', 'password' => 'password', 'database' => 'dbname', 'prefix' => '', 'encoding' => 'utf8' ); cake
ken_c_lo 2010/03/03
CakePHP

mysql
ãƒªãƒ³ã‚¯
ç¬¬ï¼“ç« ã€€ï½ï½ˆï½MyAdmin
ï¼“ï¼Žï¼”ã€€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ“ä½œ MySQL 4.1ä»¥ä¸Šã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã€ãƒ†ãƒ¼ãƒ–ãƒ«åã€ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åç‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã‚’è¨˜è¿°ã™ã‚‹æ–‡å—ã«æ—¥æœ¬èªžæ–‡å—ã‚³ãƒ¼ãƒ‰ã¯ä½¿ã‚ãªã„ã“ã¨ã‚’å¼·ãå‹§ã‚ã¾ã™ã€‚ ï¼ˆæ³¨ï¼‰MySQL 4.1ä»¥ä¸Šã§ã¯ã€ã“ã‚Œã‚‰ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã®è¨˜è¿°ã«ã¯UNICODEã®utf-8ã‚³ãƒ¼ãƒ‰ã®ã¿ãŒä½¿ã‚ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ 2006å¹´9æœˆæ™‚ç‚¹ã§ã¯ã€ä¾‹ãˆã°ã‚·ãƒ•ãƒˆJISã‚³ãƒ¼ãƒ‰ã§è¨˜è¿°ã—ãŸãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åç‰ã¯utf-8ã‚³ãƒ¼ãƒ‰ã¸å¤‰æ›ã¯ã•ã‚Œã¾ã›ã‚“ã€‚å…¥åŠ›ã‚’æ‹’å¦ã•ã‚Œã¾ã™ã€‚ è©³ç´°ã¯ã€ http://www.mysql.gr.jp/frame/modules/bwiki/index.php?cmd=read&page=FAQ#content_1_40ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ â– ä½œæˆæ¸ˆã¿ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸€è¦§è¡¨ç¤º ä½œæˆæ¸ˆã¿ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸€è¦§ã¯ã€ï½ï½ˆï½MyAdminã®èµ·å‹•ç”»é¢ã®å·¦å´ãƒ•ãƒ¬ãƒ¼ãƒ ã®
ken_c_lo 2010/03/03
mysql

phpmyadmin
ãƒªãƒ³ã‚¯
SrEngine.com is for sale | HugeDomains
Make 12 monthly payments Pay 0% interest Start using the domain today. See details
ken_c_lo 2010/03/03
MySQL

command
ãƒªãƒ³ã‚¯
Macã«MySQLã‚’å…¥ã‚Œã¦ã¿ãŸ - æ—¥ã¯ã¾ãŸæ˜‡ã‚‹
http://dev.mysql.com/downloads/mysql/4.1.html mysql-standard-4.1.15-apple-darwin7.9.0-powerpc.dmgã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã—ãŸã€‚ 2ã¤ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãŒå…¥ã£ã¦ã„ã‚‹ã®ã§ã€ mysql-standard-4.1.15-apple-darwin7.9.0-powerpc.pkgã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã€ãã®å¾Œ MySQLStartupIt em.pkgã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ æ¬¡ã«ã€ã€Œmy.confã€ã¨ã„ã†åå‰ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ã«ä½œæˆã—ã€ [mysqld] default-character-set=ujis [mysql] default-character-set=uji ã¨å…¥åŠ›ã—ã¦ã€ã“ã„ã¤ã‚’/etc/ã«å…¥ã‚Œã¾ã™ã€‚ ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‚’èµ·å‹•ã—ã¦ $ sudo cp /Users/ã‚ãªãŸã®ãƒ¦ãƒ¼ã‚¶ãƒ¼å/Desktop/my.
ken_c_lo 2010/03/03
mysql

mac

command
ãƒªãƒ³ã‚¯
MySQL5æ–‡å—åŒ–ã‘ | ã‚„ã‚“ã°ã‚‹ãã„ãª
ä¸€å®šæœŸé–“æ›´æ–°ãŒãªã„ãŸã‚åºƒå‘Šã‚’è¡¨ç¤ºã—ã¦ã„ã¾ã™
ken_c_lo 2010/03/03
mysql
ãƒªãƒ³ã‚¯
Infinity Dimensions Now Rebooting.
Infinity Dimensions Now Rebooting.
ken_c_lo 2010/03/03
php

mysql
ãƒªãƒ³ã‚¯
JOHO.BOO.JP ã€œ Labs | MySQL5ã€ãƒ†ãƒ¼ãƒ–ãƒ«åã‚’å¤‰æ›´ã™ã‚‹
MySQL5ã®ãƒ†ãƒ¼ãƒ–ãƒ«æ“ä½œã¯phpMyAdminã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ å¤§å¤‰ä¾¿åˆ©ã§ã™ãŒã€ãƒ†ãƒ¼ãƒ–ãƒ«åã®å¤‰æ›´ã¯ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã«ãªã„ã®ã§SQLã‚³ãƒžãƒ³ãƒ‰ã‚’æ‰“ã¤å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ MySQL ã§ãƒ†ãƒ¼ãƒ–ãƒ«åã‚’å¤‰æ›´ ALTER TABLE `table_old` RENAME TO `table_new`; ãƒ†ãƒ¼ãƒ–ãƒ«åã¯ã€`ãƒ†ãƒ¼ãƒ–ãƒ«å`ã€€ã¨ã„ã†ãµã†ã«`ã§å›²ã†ã»ã†ãŒè‰¯ã„ã‚ˆã†ã§ã™ã€‚ `ãŒãªã„ã¨ã‚¨ãƒ©ãƒ¼ã«ãªã£ã¦ã—ã¾ã†å ´åˆã‚‚ã‚ã‚Šã¾ã™ã€‚
ken_c_lo 2010/03/03
mysql
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸