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

yasu_boy id:yasu_boy

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

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

Linuxæ¥½ã—ã™ãŽã‚ã‚ãŸwwwwww - ãƒ–ãƒ©ãƒ–ãƒ©ãƒ–ãƒ©ã‚¦ã‚¸ãƒ³ã‚°
1 :VIPãŒãŠé€ã‚Šã—ã¾ã™:2010/09/28(ç«) 15:05:10.95 ID:I+zJt+x80 windowsã„ã‚‰ãªã„wwwwwww 4 :VIPãŒãŠé€ã‚Šã—ã¾ã™:2010/09/28(ç«) 15:06:08.35 ID:GteRPow00 ã™ãã‚ãã‚‹ã‚ˆ 17 :VIPãŒãŠé€ã‚Šã—ã¾ã™:2010/09/28(ç«) 15:15:51.70 ID:h6o6M8yP0 ã†ã¶ã‚“ã¡ã‚…ãŸã‚“ï¼ 29 :VIPãŒãŠé€ã‚Šã—ã¾ã™:2010/09/28(ç«) 15:37:39.46 ID:Ly36zr1v0 mypaintã§ãŠçµµæ›¸ãã !! 32 :VIPãŒãŠé€ã‚Šã—ã¾ã™:2010/09/28(ç«) 15:43:14.50 ID:bp+1sqFw0 5å¹´å‰ã«linuxã‚’è‰²ã€…å…¥ã‚ŒãŸã‚Šã—ã¦ã¿ãŸã‚“ã ã‘ã© ä»Šã¯ã©ã‚Œãã‚‰ã„é€²åŒ–ã—ãŸã®ï¼ŸFedoraã¨ã‹ã¾ã ã‚ã‚“ã®ï¼Ÿ 33 :VIPãŒãŠé€ã‚Šã—ã¾ã™:2010/09/28(ç«)
yasu_boy 2011/02/17
ã»ï½žãã‚“ãªä¸–ç•ŒãŒã‚ã‚‹ã®ã‹ã€‚ã‚µãƒ¼ãƒãƒ¼ã¨ã—ã¦ä½¿ã†ã‚‚ã‚“ã ã¨æ€ã£ã¦ãŸã€‚ä»®æƒ³åŒ–ã§ä½¿ã†ï¼Ÿ

ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ

mysql

PHP

perl
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
yasu_boy 2011/01/07
ã˜ã‚‡ã„ã‚“

mysql

å‚è€ƒ
ãƒªãƒ³ã‚¯
PHP & MySQL - phpspot
PHPã¨åŒæ™‚ã«ã‚ˆãä½¿ã‚ã‚Œã‚‹MySQLã®ä½¿ã„æ–¹ã«ã¤ã„ã¦ã®èª¬æ˜Žã§ã™ã€‚ ä¸»ã«UNIXã§ã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³æ“ä½œã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ MySQL4.1ã§ã®æ–‡å—åŒ–ã‘å¯¾ç–ã«ã¤ã„ã¦ã‚‚ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã®è¨˜äº‹ã¯MySQL4.1ã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦è¨˜è¿°ã•ã‚Œã¦ã„ã¾ã™ã€‚ æœ€æ–°ç‰ˆã¯5.5ç³»ã«ãªã‚Šã¾ã™ã®ã§ã”æ³¨æ„(2010/12) SQLãŒè‰¯ãåˆ†ã‹ã‚‰ãªã„æ–¹ã¯ã“ã¡ã‚‰ PHP+MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œ 1. ï¼³ï¼±ï¼¬å®Ÿè¡Œ 2. ãƒ‡ãƒ¼ã‚¿ã‚’æ¤œç´¢ 3. æ¤œç´¢ã—ãŸãƒ‡ãƒ¼ã‚¿ã®ä»¶æ•°ã‚’å¾—ã‚‹ 4. prepareã¨executeã§DBæ“ä½œ MySQLåŸºæœ¬(UNIXä¸Šã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§ã®æ“ä½œ) 1. MySQLã‚µãƒ¼ãƒã‚’èµ·å‹•ã™ã‚‹ 2. MySQLã‚µãƒ¼ãƒã‚’åœæ¢ã™ã‚‹ 3. ã‚µãƒ¼ãƒã®èµ·å‹•ã‚’ç¢ºèªã™ã‚‹ 4. ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§æ“ä½œ 1. MySQLã®çŠ¶æ…‹ã‚’è¡¨ç¤º 2. ä½¿ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ‡æ›¿ 3. SQLã®å®Ÿè¡Œã‚’ã‚ãƒ£ãƒ³ã‚»ãƒ« 4. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸€è¦§è¡¨ç¤º 5. ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§è¡¨ç¤º
yasu_boy 2010/12/27
php mysql

mysql

ãƒ†ãƒ¼ãƒ–ãƒ«

php

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ãƒªãƒ³ã‚¯
æœˆé¡500å††ã»ã©ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã‚’æ¯”è¼ƒã—ã¦ã¿ãŸ: æˆåŠŸã™ã‚‹ãƒ“ã‚¸ãƒã‚¹æ›¸è©•
æœˆé¡500å††ã»ã©ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã‚’æ¯”è¼ƒã—ã¦ã¿ãŸ å‰å›žã®æœˆé¡1500å††ã»ã©ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã‚’æ¯”è¼ƒã¨ã„ã†è¨˜äº‹ã«ç¶šã„ã¦æ–™é‡‘æœˆé¡500å††ã»ã©ã§æ¯”è¼ƒã—ã¦ã¿ã¾ã—ãŸã€‚ï¼ˆä¸€ã¤ã ã‘945å††ã®ã‚‚ï¼‰ â—†ã¾ãšã¯æœˆé¡æ–™é‡‘æ¯”è¼ƒï¼ ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®ã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ãƒ»ãƒ»500å††ãƒšãƒ¼ãƒ‘ãƒ¼ãƒœãƒ¼ã‚¤ã®ãƒã‚«ãƒƒãƒ‘ãƒ»ãƒ»525å††ãƒãƒƒãƒˆã‚ªã‚¦ãƒ«ã®ãƒ•ã‚¡ã‚¤ã‚¢ãƒ¼ãƒãƒ¼ãƒ‰ãƒ»ãƒ»525å††ã€€ï¼ˆãƒã‚¤ãƒ³ãƒˆä½¿ç”¨ã§æœ€å¤§393å††ï¼ï¼‰ã‚¢ã‚¤ãƒ«ã®InfinitoPLUSï¼ˆiNP-01ï¼‰ãƒ»ãƒ»945å††ã€€(735å†† 12ãƒ¶æœˆå¥‘ç´„ã®å ´åˆ) â—†å®¹é‡æ¯”è¼ƒã€€ï¼ˆä½•GBï¼Ÿï¼‰ ã•ãã‚‰ã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ãƒ»ãƒ»ãƒ»ï¼‘ï¼GBãƒšãƒ‘ãƒœã®ãƒã‚«ãƒƒãƒ‘ãƒ»ãƒ»ãƒ»15GBãƒãƒƒãƒˆã‚ªã‚¦ãƒ«ã®ãƒ•ã‚¡ã‚¤ã‚¢ãƒ¼ãƒãƒ¼ãƒ‰ãƒ»ãƒ»ãƒ»ï¼•ï¼GBï¼ ï¼ˆå¢—ãˆãŸã‚Šã—ã¦ã‚‹ï¼é ‘å¼µã£ã¦ã¾ã™ãï¼ï¼‰ InfinitoPLUSï¼ˆiNP-01ï¼‰ãƒ»ãƒ»ãƒ»40GB â—†åˆæœŸè²»ç”¨æ¯”è¼ƒ ã•ãã‚‰ã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ãƒ»ãƒ»ãƒ»1000å††ã€€å®‰ã„ï¼ãƒã‚«ãƒƒãƒ‘ãƒ»ãƒ»ãƒ»2010å††ãƒ•ã‚¡ã‚¤ã‚¢ãƒãƒ¼ãƒ‰ãƒ»ãƒ»ãƒ»2100
yasu_boy 2010/12/20
ãƒ–ãƒã‚°è¨˜äº‹æ›¸ãã¾ã—ãŸï½žï½žï¼ˆï¼¾ãƒ¼ï¼¾ï¼‰ï¼ãµã†ç–²ã‚ŒãŸãƒ»ãƒ»

ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼

ãƒãƒªãƒãƒƒãƒ—

ã•ãã‚‰

mysql

ãƒ‰ãƒ¡ã‚¤ãƒ³

ç‹¬è‡ªãƒ‰ãƒ¡ã‚¤ãƒ³

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

æ¯”è¼ƒ
ãƒªãƒ³ã‚¯
http://www.cpa-lab.com/tech/046
yasu_boy 2010/12/16
phpã®SQLiteã‚’ä½¿ã†ã¨mysqlãªã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒä½¿ãˆãªã„æ‰€ã§ã‚‚ã€ãã‚Œã£ã½ã„ã‚‚ã®ãŒä½¿ãˆã‚‹ã¨ã„ã†ã“ã¨ã‹ãªã€€ã„ã„ãªã“ã‚Œ

mysql

ã‚µãƒ¼ãƒ

ãƒ‡ãƒ¼ã‚¿

sqlite
ãƒªãƒ³ã‚¯
AutoMySQLBackupã‚’å°Žå…¥
WordPressã‚’å°Žå…¥ã™ã‚‹ã«ã‚ãŸã‚Šã€ã‚„ã¯ã‚Šè‡ªå‰ã‚µãƒ¼ãƒã«ãƒ‡ãƒ¼ã‚¿ãŒè“„ç©ã•ã‚Œã‚‹ã®ã¯å¤–éƒ¨blogã‚’åˆ©ç”¨ã™ã‚‹ã®ã«æ¯”ã¹ã€ãƒ‡ãƒ¼ã‚¿æ¶ˆå¤±ã®ãƒªã‚¹ã‚¯ã¯é«˜ã„ã€‚ ã¨ã„ã†ã“ã¨ã§ã€ãã®ãƒªã‚¹ã‚¯ã‚’å°‘ã—ã§ã‚‚æ¸›ã‚‰ã™ãŸã‚ã«ãƒ‡ãƒ¼ã‚¿ã®å®šæœŸçš„ãªãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨é€€é¿ã‚’æ¤œè¨Žã—ãŸã€‚ GIGAZINEã§ç´¹ä»‹ã•ã‚Œã¦ã„ãŸAutoMySQLBackupã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã«ã—ãŸã€‚ å°Žå…¥ã¯è‡³ã£ã¦ç°¡å˜ã§ã€ ã“ã“ã‹ã‚‰ automysqlbackup.sh ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ (ç§ã¯/opt ã«ç½®ã„ãŸ) rootã§å‹•ã‹ã™ã®ã§ã€# chmod 700 automysqlbackup.sh.2.5 ãƒ•ã‚¡ã‚¤ãƒ«å†…ã®ã€USERNAME, PASSWORD, DBNAMES, BACKUPDIR ã‚’å¤‰æ›´ USERNAME = root PASSWORD = è¨å®šæ¸ˆã¿ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ DBNAMES = â€œallâ€ â€»å˜åœ¨ã™ã‚‹å…¨ã¦ã®DBã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚ŠãŸã„å ´åˆã¯allã‚’æŒ‡å®šã™
yasu_boy 2010/08/07
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—çš†ã•ã‚“ã©ã†ã—ã¦ã‚‹ã‚“ã§ã™ã‹ãã€‚æ‰‹å‹•ã§ã™ã‹ï¼Ÿè‡ªå‹•ã§ã™ã‹ï¼Ÿ

mysql
ãƒªãƒ³ã‚¯
XAMPP for Windows
å«ã‚€: Apache 2.4.58, MariaDB 10.4.32, PHP 8.0.30, phpMyAdmin 5.2.1, OpenSSL 3.1.3, XAMPP Control Panel 3.2.4, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 8.5.96 (with mod_proxy_ajp as connector), Strawberry Perl 5.32.1.1 Porta ble å«ã‚€: Apache 2.4.58, MariaDB 10.4.32, PHP 8.1.25, phpMyAdmin 5.2.1, OpenSSL 3.1.3, XAMPP Control Panel 3.2.4, Webalizer 2.23-04
yasu_boy 2010/07/31
php perl mysql apache ãªã©ä¸€å¼ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ã“ã¡ã‚‰ã‚‚ãƒã‚§ãƒƒã‚¯ã€‚

PHP

mysql

apache
ãƒªãƒ³ã‚¯
Apache/PHP/MySQLãªã©ã‚’Windowsã«ä¸€ç™ºã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹ã€ŒVertrigoServã€ - GIGAZINE
Apache/PHP/MySQL/SQLite/SQLiteManage/PhpMyAdmin/Zend Optimizerã‚’Windowsã«ã¾ã¨ã‚ã¦ã‚ªãƒ¼ãƒ«ã‚¤ãƒ³ãƒ¯ãƒ³ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã®ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§é–‹ç™ºã•ã‚Œã¦ã„ã‚‹ã“ã®ã€ŒVertrigoServã€ã€‚ ã“ã‚Œã‚‰ã®å„ã‚½ãƒ•ãƒˆã«ã¤ã„ã¦ç°¡å˜ã«è¨å®šã‚’å¤‰æ›´ã§ãã‚‹ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒ‘ãƒãƒ«ã£ã½ã„ã‚‚ã®ãŒã‚¿ã‚¹ã‚¯ãƒˆãƒ¬ã‚¤ã‹ã‚‰ä¸€ç™ºã§å‘¼ã³å‡ºã›ã‚‹ã‚ˆã†ã«ãªã£ã¦ãŠã‚Šã€éžå¸¸ã«è¨å®šãŒç°¡å˜ã§ã™ã€‚ã¾ãŸã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã¯æ—¥æœ¬èªžåŒ–ã•ã‚Œã¦ã„ã‚‹ã®ã§å®‰å¿ƒã§ã™ã€‚ å®Ÿéš›ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ãªã©ã¯ä»¥ä¸‹ã‹ã‚‰ã€‚ VertrigoServ http://vertrigo.sourceforge.net/ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸã‚‰å®Ÿè¡Œã—ã¾ã™ ã€ŒOKã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€Œæ¬¡ã¸ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€ŒåŒæ„ã™ã‚‹ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€Œæ¬¡ã¸ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã•ã‚‰ã«ã€Œæ¬¡ã¸ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€Œã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä¸â€¦â€¦
yasu_boy 2010/07/28
ä¸€æ‹¬ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹ã®ã‚‚ã‚ã‚‹ã¿ãŸã„ã ã‘ã©ãƒ»ãƒ»ã“ã‚Œã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ãŸã€‚

mysql

PHP

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

ã“ã‚Œã¯ä¾¿åˆ©
ãƒªãƒ³ã‚¯
ãƒ•ãƒªãƒ¼ã§ä½¿ãˆã‚‹PHPï¼‹MySQLã§æ§‹ç¯‰ã•ã‚ŒãŸã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã‚«ãƒ¼ãƒˆã‚·ã‚¹ãƒ†ãƒ ã€ŒZeuscartã€:phpspoté–‹ç™ºæ—¥èªŒ
Zeuscart ? Free GPL Ecommerce Shopping Cart Software | Ecommerce Solutions | Online PHP Shopping Carts | Storefront Software ãƒ•ãƒªãƒ¼ã§ä½¿ãˆã‚‹PHPï¼‹MySQLã§æ§‹ç¯‰ã•ã‚ŒãŸã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã‚«ãƒ¼ãƒˆã‚·ã‚¹ãƒ†ãƒ ã€ŒZeuscartã€ã€‚ Amazonã£ã½ã„ECã‚µã‚¤ãƒˆã®æ§‹ç¯‰ãŒã§ãã‚‹ä¸Šã«ç®¡ç†ç”»é¢ã‚‚ãªã‹ãªã‹å……å®Ÿã—ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ æ§‹ç¯‰ã•ã‚ŒãŸã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã‚µã‚¤ãƒˆã€‚UIã‚‚ãªã‹ãªã‹ã‚«ãƒƒã‚³ã„ã„ã€‚ å®Ÿéš›ã«è¦‹ã¦ã¿ã‚‹å ´åˆã¯ã“ã¡ã‚‰ å•†å“è©³ç´°ãƒšãƒ¼ã‚¸ ç®¡ç†ç”»é¢ã§ã¯å£²ã‚ŒãŸã‚‚ã®ã®ã‚°ãƒ©ãƒ•æç”»æ©Ÿèƒ½ãªã‚“ã‹ãŒã¤ã„ã¦ã‚‹ã‚ˆã†ã§ã™ã€‚ ã‚¢ã‚¤ãƒ†ãƒ ç®¡ç†ç”»é¢ ï¼‘ã¤ã®é¸æŠžè‚¢ã¨ã—ã¦è¦šãˆã¦ãŠã„ã¦ã‚ˆã•ãã†ã§ã™ãã€‚ é–¢é€£ã‚¨ãƒ³ãƒˆãƒª PHPã§æ›¸ã‹ã‚ŒãŸæ¬¡ä¸–ä»£ã®ã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã‚«ãƒ¼ãƒˆã‚·ã‚¹ãƒ†ãƒ ã€ŒTomatoCartã€ ã‚«ãƒ¼ãƒˆãŒç›®ç«‹ãŸãšã€ã„ã„æ„Ÿã˜ã«ã‚¹ãƒ©ã‚¤ãƒ‰ã—ã¦ãã‚Œ
yasu_boy 2010/07/14
PHP

software

mysql

Amazon
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
å¹³ç´ ã‚ˆã‚Šã€ŒPHPãƒ—ãƒï¼ã€ã‚’ã”æ„›é¡§ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ 2006å¹´ã‚ˆã‚Šé‹å–¶ã—ã¦ã¾ã„ã‚Šã¾ã—ãŸã€ŒPHPãƒ—ãƒï¼ã€ã§ã™ãŒã€ã‚µãƒ¼ãƒ“ã‚¹ã®åˆ©ç”¨çŠ¶æ³ã‚’é‘‘ã¿ã¾ã—ã¦ã€2018å¹´9æœˆ25æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã•ã›ã¦ã„ãŸã ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã¾ã—ã¦ã€2018å¹´8æœˆ28æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’æŒã¡ã¾ã—ã¦ã€æ–°è¦ä¼šå“¡ç™»éŒ²ãªã‚‰ã³ã«Q&AæŽ²ç¤ºæ¿ã¸ã®æ–°ãŸãªè³ªå•ã€å›žç”ã®æŠ•ç¨¿ã‚’åœæ¢ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ãªãŠã€ã”ç™»éŒ²ã„ãŸã ã„ãŸçš†æ§˜ã®å€‹äººæƒ…å ±ã«ã¤ãã¾ã—ã¦ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†å¾Œã€å¼Šç¤¾ãŒè²¬ä»»ã‚’ã‚‚ã£ã¦æ¶ˆåŽ»ã„ãŸã—ã¾ã™ã€‚ ã“ã‚Œã¾ã§å¤šãã®çš†æ§˜ã«ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ã¦ã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã€çš†æ§˜ã«ã¯ã”ä¸ä¾¿ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ã“ã¨ã€å¿ƒã‚ˆã‚ŠãŠè©«ã³ç”³ã—ä¸Šã’ã¾ã™ã€‚ æœ¬ä»¶ã«é–¢ã™ã‚‹ãŠå•ã„åˆã‚ã›ã¯ã“ã¡ã‚‰ã‚ˆã‚ŠãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
yasu_boy 2010/07/08
phpãªã‚‰ã“ã‚Œã‚’ä½¿ãˆã°ã„ã„ã‚‰ã—ã„ã‘ã©perlãªã‚‰ã©ã†ã—ãŸã‚‰ã„ã„ã‚“ã ã‚ã†ï¼Ÿ

mysql

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
MySQL æ–‡å—åŒ–ã‘ã«ã¤ã„ã®ã¦ã¾ã¨ã‚ - æ±äº¬ãƒžãƒ¼ãƒ–ãƒ« ãƒ–ãƒã‚°æ”¯åº—
MySQLã®æ–‡å—åŒ–ã‘ã«é–¢ã—ã¦ã€ãƒãƒƒãƒˆã¨ã‹ã«æ•£ã‚‰ã°ã£ã¦ã„ã‚‹æƒ…å ±ã‚’ã‹ãé›†ã‚ãŸã‚Šã—ãŸè‡ªåˆ†ç”¨ãƒ¡ãƒ¢ã€‚ ï¼‘ï¼Žæ–‡å—åŒ–ã‘ã«é–¢ã‚ã‚‹ä½•ã‹ MySQL4.1ã‚’å¢ƒã« è¿½åŠ ãƒ»å¤‰æ›´ã•ã‚ŒãŸå¹¾ã¤ã‹ã®æ©Ÿèƒ½ã«ã‚ˆã£ã¦ç™ºç”Ÿã—ã‚„ã™ããªã£ãŸã‚‰ã—ã„ã€‚ ãƒ»[æ–°è¦]Unicode(utf-8ãŠã‚ˆã³ucs2)ã®ã‚µãƒãƒ¼ãƒˆ ãƒ»[æ–°è¦]æ–‡å—ã‚³ãƒ¼ãƒ‰ã®è‡ªå‹•å¤‰æ›æ©Ÿèƒ½ã®è¿½åŠ ãƒ»[å¤‰æ›´]ã‚«ãƒ©ãƒ ,ãƒ†ãƒ¼ãƒ–ãƒ«,ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å˜ä½ã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆæŒ‡å®š â– MySQLã®ã‚µãƒãƒ¼ãƒˆã™ã‚‹æ—¥æœ¬èªžæ–‡å—ã‚³ãƒ¼ãƒ‰ Shift-JIS EUC-JP Unicode 4.0 sjis ujis 4.1 sjis/cp932 ujis utf8/ucs2 5.0 sjis/cp932 ujis/eucjpms utf8/ucs2 â€»4.1->5.0 ã®å¤‰æ›´ã§ï¼’ç¨®é¡žã‹ã‚‰ï¼–ç¨®é¡žã«æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒå¢—ãˆãŸ æ•æ‰ï¼‘ï¼‰ cp932(IANAç™»éŒ²å:Windows-31J) ã‚·ãƒ•ãƒˆJISã‚’æ‹¡å¼µã—ãŸWindo
yasu_boy 2010/07/08
ã‚ˆãã¾ã¨ã¾ã£ã¦ã‚‹ã‚ˆã†ãªæ°—ãŒã™ã‚‹ã€‚

æ–‡å—ã‚³ãƒ¼ãƒ‰

mysql

UTF-8
ãƒªãƒ³ã‚¯
MySQL æ–‡å—åŒ–ã‘å•é¡Œã‚’æœ¬æ°—ã§ç›´ã™
mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 Connection id: 36 Current database: staff2006 Current user: maiha@localhost SSL: Not in use Current pager: lv Using outfile: '' Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client char
yasu_boy 2010/07/07
ãªã‚‹ã»ã©ã€€show variables like "char%"ã“ã‚Œã‚„ã£ã¦ã¿ã‚ˆ

mysql

æ–‡å—ã‚³ãƒ¼ãƒ‰

tips

æ–‡å—åŒ–ã‘
ãƒªãƒ³ã‚¯
ï¼»MySQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬36å›ž æ–‡å—åŒ–ã‘ã®ãƒ¡ã‚«ãƒ‹ã‚ºãƒ
æ–‡å—ã‚³ãƒ¼ãƒ‰ã®å¤šæ§˜åŒ–ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‚„ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ-ã‚µãƒ¼ãƒãƒ¼ãªã©ã®åˆ†æ•£ç’°å¢ƒã®æ™®åŠã«ã‚ˆã£ã¦ï¼Œæ–‡å—åŒ–ã‘ãƒˆãƒ©ãƒ–ãƒ«ã®é »åº¦ãŒé£›èºçš„ã«æ‹¡å¤§ã—ãŸã€‚ç‰¹ã« Webã‚·ã‚¹ãƒ†ãƒ ã§ã¯ï¼ŒWebãƒ–ãƒ©ã‚¦ã‚¶ã¨Webã‚µãƒ¼ãƒãƒ¼ï¼Œãƒ—ãƒã‚°ãƒ©ãƒ (ã‚¹ã‚¯ãƒªãƒ—ãƒˆ)è¨€èªžï¼Œãã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨æ–‡å—åŒ–ã‘ãŒç™ºç”Ÿã™ã‚‹è¦å› ãŒæ•°å¤šãå˜åœ¨ã™ã‚‹ã€‚ Webã‚µãƒ¼ãƒãƒ¼å´ã®æ–‡å—åŒ–ã‘ã¯ï¼Œä»–ã®ã‚³ãƒ©ãƒ ã«ãŠä»»ã›ã™ã‚‹ã“ã¨ã¨ã—ã¦ï¼Œä»Šå›žã¯MySQLã®æ–‡å—åŒ–ã‘ã«é–¢ã—ã¦è§£èª¬ã™ã‚‹ã€‚ æ–‡å—åŒ–ã‘ã®ä»•çµ„ã¿ æ–‡å—åŒ–ã‘ã¯é–‹ç™ºè€…ã«ã¨ã£ã¦æ‚©ã¿ã®ç¨®ã§ã‚ã‚‹ã€‚ã—ã‹ã—ï¼Œæ–‡å—åŒ–ã‘ã®ä»•çµ„ã¿ã‚’å°‘ã—ã§ã‚‚çŸ¥ã£ã¦ã„ã‚Œã°ï¼Œæ„å¤–ã¨ç°¡å˜ã«è§£æ±ºã§ãã‚‹ã‚‚ã®ã ã€‚ã“ã®ã‚³ãƒ©ãƒ ã§ï¼Œãœã²ãã®çŸ¥è˜ã‚’å¦ã‚“ã§ã»ã—ã„ã€‚ MySQL 4.1ã®å¤‰æ›´ç‚¹ ã•ã¦ï¼ŒMySQLã«ãŠã„ã¦ã¯ï¼Œãƒãƒ¼ã‚¸ãƒ§ãƒ³4.1ã®ãƒªãƒªãƒ¼ã‚¹ã‚’å¢ƒã«æ–‡å—åŒ–ã‘ãŒèµ·ãã‚‹ã“ã¨ãŒéžå¸¸ã«å¤šããªã£ãŸã€‚ã§ã¯ï¼Œãƒãƒ¼ã‚¸ãƒ§ãƒ³4.1ã¯ï¼Œãã‚Œä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ä½•ãŒå¤‰ã‚ã£ãŸã®ã ã‚ã†ã‹ã€‚ãã“ã«æ–‡å—åŒ–ã‘ã‚’è§£æ±ºã™ã‚‹ãƒ’ãƒ³ãƒˆ
yasu_boy 2010/07/07
MySQL 4.1ã«ã€Œæ–‡å—ã‚³ãƒ¼ãƒ‰ã®è‡ªå‹•å¤‰æ›æ©Ÿèƒ½ã€ãŒæè¼‰ã€‚5.0ã¨ã®é•ã„ã¯ï¼Ÿ

mysql

ã‚µãƒ¼ãƒãƒ¼

æ–‡å—ã‚³ãƒ¼ãƒ‰

æ–‡å—åŒ–ã‘
ãƒªãƒ³ã‚¯
ã€ŽQ&Aãªã†ã€ã®é–‹ç™ºã‚’æ‰‹ä¼ã£ã¦ãã‚Œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã‚’å‹Ÿé›†ã—ã¾ã™ã€‚ - ãƒ‘ãƒ‘ãƒ‘ãƒ‘
23:24 | ãŸã ã„ã¾ã€ŽQ&Aãªã†ã€ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼å‹Ÿé›†ä¸ï¼ PHPã€MySQLãŒã§ãã‚‹æ–¹ãŒå¿œå‹Ÿæ¡ä»¶ã¨ãªã‚Šã¾ã™ã€‚å”åŠ›ã—ãŸã„ã¨ã„ã†æ–¹ãŒã„ãŸã‚‰ã€ãŠåå‰ã€ã“ã‚Œã¾ã§ã®çµŒæ´ã€æ„æ°—è¾¼ã¿ã‚’æ˜Žè¨˜ã®ä¸Šã€ä¸‹è¨˜ã¾ã§ã”é€£çµ¡ãã ã•ã„ï¼é€£çµ¡å…ˆã¯ã“ã¡ã‚‰ â†’ hajimeataka[ã‚ã£ã¨]gmail.com
yasu_boy 2010/05/25
å‹Ÿé›†ã‹ãƒ»ãƒ»ãŠé‡‘ã¯ã‚‚ã‚‰ãˆã‚‹ã®ã‹ãªï¼ŸãŸã ã®ãƒœãƒ©ãƒ³ãƒ†ã‚£ã‚¢ï¼Ÿ

Q&A

PHP

mysql

é–‹ç™º
ãƒªãƒ³ã‚¯
Site Under Maintenance
We'll be back soon! Our site is currently undergoing maintenance. Please check back later.
yasu_boy 2010/05/19
ã‚ã¨ã§ã€€ã¡ã‚‡ã£ã¨ãªã®ã

mysql

ã‚ã¨ã§èªã‚€

PHP
ãƒªãƒ³ã‚¯
ãƒ‰ç´ äººã«ã‚ˆã‚‹PHPé–‹ç™ºç’°å¢ƒæ§‹ç¯‰ãƒ»ãƒ„ãƒ¼ãƒ«ç´¹ä»‹ï¼ˆMacãƒ»Windowsï¼‰ | é«˜æ©‹æ–‡æ¨¹.com | Webåˆ¶ä½œ
ã“ã®æŠ•ç¨¿ã¯ 15å¹´ å‰ã«å…¬é–‹ã•ã‚Œã¾ã—ãŸã€‚ã„ã¾ã§ã¯ã‚‚ã†ç„¡åŠ¹ã«ãªã£ãŸå†…å®¹ã‚’å«ã‚“ã§ã„ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã“ã¨ã‚’ã”äº†æ‰¿ãã ã•ã„ã€‚ ãƒªãƒ¢ãƒ¼ãƒˆã‚µãƒ¼ãƒç·¨ ä»•äº‹ã§ä½¿ã†ã‚ˆã†ãªã‚µãƒ¼ãƒã¯å¤§ä½“Linuxã§ã™ã€‚ã¨ãã©ãWindowsã‚µãƒ¼ãƒã‚‚ã‚ã‚Šã¾ã™ãŒã€æ™®é€šã¯Linuxã§ã™ã€‚ PHPé–‹ç™ºè€…ã¨ã—ã¦èº«ã‚’ç«‹ã¦ãŸã‹ã£ãŸã‚‰ã€è‡ªåˆ†ã§ã‚µãƒ¼ãƒãã‚‰ã„å€Ÿã‚Šã¾ã—ã‚‡ã†ã€‚ã•ãã‚‰ãŒå®‰ãã¦ã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã€‚æœˆ500å††ãã‚‰ã„ã€‚ Macç·¨ Apacheã€MySQLã€PHPã‚’ä¸€ç™ºã§æ•´ãˆã‚‹æ¥½ãªæ–¹æ³• Xampp for Macï¼ˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ï¼‰ Mampï¼ˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ï¼‰ ã©ã£ã¡ã‚‚å¤§ã—ã¦å¤‰ã‚ã‚Šã¾ã›ã‚“ã€‚åŸºæœ¬çš„ã«è‹±èªžã§ã™ãŒã€å•é¡Œã¯ãã‚Œã»ã©ãªã„ã¨æ€ã„ã¾ã™ã€‚ å…¨éƒ¨è‡ªåˆ†ã§ã‚„ã‚‹å¤§å¤‰ãªæ–¹æ³• Macporsã‚’åˆ©ç”¨ã™ã‚‹ã€‚ã“ã‚Œã¯å°†æ¥çš„ã«ã‚µãƒ¼ãƒãƒ»ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã‚„ä»–è¨€èªžï¼ˆRubyã€Perlã€Pythonã€Objective-Cï¼‰ã§ã®é–‹ç™ºã‚’æ¤œè¨Žã—ã¦ã„ã‚‹æ–¹ã«ãŠã™ã™ã‚ã§ã™ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
yasu_boy 2010/05/01
ã¾ã¨ã¾ã£ã¦ã¦åˆ†ã‹ã‚Šã‚„ã™ã„

PHP

mysql

ã¾ã¨ã‚

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
CakePHPãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã«ã‚ˆã‚‹å¿«é€ŸWEBé–‹ç™º
ã¯ã˜ã‚ã« PHPã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆä»¥ä¸‹ã€DBï¼‰ã¨é€£æºã™ã‚‹é«˜æ©Ÿèƒ½ãªWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®¹æ˜“ã«ä½œæˆã§ãã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã§ã™ã€‚ç¾åœ¨ã€ã•ã‚‰ã«çŸæœŸé–“ã§åŠ¹çŽ‡çš„ãªé–‹ç™ºã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã«ã€ã•ã¾ã–ã¾ãªPHPãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ãŒå…¬é–‹ã•ã‚Œã€é–‹ç™ºç’°å¢ƒãŒæ•´ã„ã¤ã¤ã‚ã‚Šã¾ã™ã€‚ä»Šå›žã¯ç‰¹ã«ã€Ruby On Railsã«è§¦ç™ºã•ã‚Œã¦é–‹ç™ºãŒå§‹ã¾ã‚Šã€ãªãŠã‹ã¤ç‹¬è‡ªã®ç™ºå±•ã‚’é‚ã’ã¦ã„ã‚‹CakePHPï¼ˆã‚±ã‚¤ã‚¯ãƒ»ãƒ”ãƒ¼ãƒ»ã‚¨ã‚¤ãƒãƒ»ãƒ”ãƒ¼ï¼‰ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚PHPã¨ã„ã†è¨€èªžã®é¢ç™½ã•ã‚„ã€ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã«ã‚ˆã‚‹é–‹ç™ºã«èˆˆå‘³ã‚’æŒã£ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ å¯¾è±¡èªè€… PHPã®åŸºç¤ŽçŸ¥è˜ã‚’æŒã¡ã€ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’åˆ©ç”¨ã—ãŸåŠ¹çŽ‡çš„ãªWebé–‹ç™ºã«é–¢å¿ƒã®ã‚ã‚‹æ–¹ã€‚ å¿…è¦ãªç’°å¢ƒ CakePHPã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ã«å¿…è¦ãªç’°å¢ƒã¯æ¬¡ã®ã¨ãŠã‚Šã§ã™ã€‚ Linuxã€Windowsã€Macãªã©ã®å„ç¨®OSç’°å¢ƒ Apacheã€Lighttdãªã©ã®Webã‚µãƒ¼ãƒãƒ¼ MySQLãªã©ã®DBï¼ˆMyS
yasu_boy 2010/04/30
èªã‚€

PHP

é–‹ç™º

mysql

framework

CakePHP
ãƒªãƒ³ã‚¯
ï¼ IT Special PRï¼š600å„„PVã‚‚MySQLã§ï¼ ãƒ¢ãƒã‚²ãƒ¼ã®ã‚¤ãƒ³ãƒ•ãƒ©åº•åŠ›
æºå¸¯å‘ã‘ã‚µã‚¤ãƒˆã€Œãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ã€ã®å‹¢ã„ãŒæ¢ã¾ã‚‰ãªã„ã€‚2010å¹´3æœˆã®ä¼šå“¡æ•°ã¯ç´„1800ä¸‡äººã€æœˆé–“ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ï¼ˆPVï¼‰600å„„ã¨ã„ã†"ãƒ¢ãƒ³ã‚¹ã‚¿ãƒ¼SNS"ã«æˆé•·ã—ã¦ã„ã‚‹ã€‚æ„å¤–ãªã“ã¨ã«ã€ã“ã‚Œã ã‘ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã•ã°ãã®ã«ã€memcachedã‚’ã¯ã˜ã‚ã¨ã™ã‚‹KVSï¼ˆKey-Value Storeï¼‰ç³»ã®ã‚¤ãƒ³ãƒ•ãƒ©ãƒ»ã‚½ãƒ•ãƒˆã¯ã‚ã¾ã‚Šä½¿ã£ã¦ãŠã‚‰ãšã€MySQLã§ååˆ†ã ã¨ã„ã†ã€‚ãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ã®ã‚¤ãƒ³ãƒ•ãƒ©æ‹…å½“è€…ã«è©±ã‚’èžã„ãŸã€‚ ãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ã‚’é‹å–¶ã™ã‚‹DeNAï¼ˆãƒ‡ã‚£ãƒ¼ãƒ»ã‚¨ãƒŒãƒ»ã‚¨ãƒ¼ï¼‰ã¯ã€ã‚‚ã¨ã‚‚ã¨1999å¹´ã«é–‹å§‹ã—ãŸã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã‚µã‚¤ãƒˆã€Œãƒ“ãƒƒãƒ€ãƒ¼ã‚ºã€ã§çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ãã®å¾Œã€ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã«åŠ ãˆã¦ECã‚µã‚¤ãƒˆã‚’é–‹å§‹ã—ã€auã¨ã®ææºã«ã‚ˆã‚Šã€Œauã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ãƒ¢ãƒ¼ãƒ«ã€ãªã©ã§æ€¥é€Ÿã«æˆé•·ã—ãŸã€‚ ãƒ“ãƒƒãƒ€ãƒ¼ã‚ºã ã‘ã§ã‚‚ã€æ•°åƒä¸‡PVè¦æ¨¡ã®å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹ã ãŒã€æœ€è¿‘ã¯ãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ã®æˆé•·ãŒè‘—ã—ã„ã€‚ ã€Œç‰¹ã«2009å¹´9æœˆã‹ã‚‰é †æ¬¡ãƒªãƒªãƒ¼ã‚¹ã—ãŸè‡ªç¤¾è£½ã®ã‚½ãƒ¼ã‚·ãƒ£ãƒ«
yasu_boy 2010/04/27
ã™ã”ã„ãª

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒª

ãƒ¢ãƒã‚²ãƒ¼

DeNA

mysql

memcached
ãƒªãƒ³ã‚¯
1