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

pnepne id:pnepne

MySQLã«é–¢ã™ã‚‹pnepneã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ - ä¹…ä¿æ¸…éš†ã®ãƒ–ãƒã‚°
ä»•äº‹ã§MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ã„ã¦ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åˆ†ã‹ã£ã¦ã„ãªã„ã“ã¨ãŒå¤šã‹ã£ãŸã®ã§èª¿ã¹ãŸã“ã¨ã‚’ãƒ¡ãƒ¢ã€‚åŸºæœ¬çš„ãªã¨ã“ã‚ã‹ã‚‰å¦ç¿’ã—ãªãŠã—ãŸã€‚ MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã€ã‚«ãƒ©ãƒ ãŒç‰¹å®šã®å€¤ã‚’ã‚‚ã¤ãƒ¬ã‚³ãƒ¼ãƒ‰ã®è¿…é€Ÿãªæ¤œç´¢ã«ä½¿ç”¨ã•ã‚Œã‚‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã™ã‚Œã°ã€æ•°ç™¾ã¨ã‹æ•°å„„ã‚‚ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå…¥ã£ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ã€ä¸€çµ„ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿…é€Ÿã«è¦‹ã¤ã‘ã¦å–ã‚Šå‡ºã™ã“ã¨ãŒå¯èƒ½ã«ãªã‚‹ã€‚ ã—ã‹ã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯é€Ÿåº¦ã‚’æ”¹å–„ã™ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ãŒã€æŒ¿å…¥ã®é‚ªé”ã«ãªã£ã¦é…ããªã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é©åˆ‡ã«ä½¿ã†ãŸã‚ã«ã€ã¾ãšã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºæœ¬æ¦‚å¿µã‚’ãŠã•ãˆã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ¦‚å¿µ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä»•çµ„ã¿ã‚’ç†è§£ã™ã‚‹ã«ã¯ã€ã¾ãšMySQLãŒã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªã«å¿œç”ã™ã‚‹ã‹ã‚’çŸ¥ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ä¾‹ãˆã°ã€ SELECT * FROM phone_book WHERE last_name = 'Hoge'
pnepne 2010/12/02
MySQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
pnepne 2010/11/16
MySQL

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
PHP: PDO - Manual
Getting Started Introduction A simple tutorial Language Reference Basic syntax Types Variables Constants Expressions Operators Control Structures Functions Classes and Objects Namespaces Enumerations Errors Exceptions Fibers Generators Attributes References Explained Predefined Variables Predefined Exceptions Predefined Interfaces and Classes Predefined Attributes Context options and parameters Su
pnepne 2010/07/24
PDO - PHPãƒžãƒ‹ãƒ¥ã‚¢ãƒ«å†…

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

PHP

MySQL

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ãƒªãƒ³ã‚¯
ADODB Manual
PHPã®ãŸã‚ã®ADOdbãƒ©ã‚¤ãƒ–ãƒ©ãƒª original document ADOdbé–¢é€£æ–‡æ›¸ V4.62 2 Apr 2005 (c) 2000-2005 John Lim (jlim#natsoft.com) ã“ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯BSDã‚¹ã‚¿ã‚¤ãƒ«ã¨LGPLã‚’ä½¿ã„ãƒ‡ãƒ¥ã‚¢ãƒ«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã‚Œã¯ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã•ã‚Œã¦æ‰€æœ‰æ¨©ã®ã‚ã‚‹å¸‚è²©è£½å“ã§ä½¿ãˆã‚‹ã“ã¨ã‚’æ„å‘³ã—ã¦ã„ã¾ã™ã€‚ å½¹ã«ç«‹ã¤ADOdbã®ãƒªãƒ³ã‚¯: Download Â Other Docs åºæ–‡ ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªç‰¹å¾´ ã©ã‚“ãªãµã†ã«äººã€…ã¯ADOdbã‚’ä½¿ã£ã¦ã„ã‚‹ã‹ æ©Ÿèƒ½è¦æœ›ã¨ãƒã‚°å ±å‘Š ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« æœ€å°ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã‚³ãƒ¼ãƒ‰ã®åˆæœŸåŒ–ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®æŽ¥ç¶š ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹åï¼ˆDSNï¼‰ Â æŽ¥ç¶šä¾‹ é«˜é€ŸADOdb - ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°Tips å®‰å…¨ãªADOdbã®ãƒãƒƒã‚ãƒ³ã‚°ã¨å¤‰æ›´ PHP5ã®æ©Ÿèƒ½ foreach i
pnepne 2010/07/24
ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

PHP

MySQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MySQL AB :: MySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
æ¦‚è¦ ã“ã‚Œã¯ MySQL ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã§ã™ã€‚ MySQL 8.0 ã‹ã‚‰ 8.0.25ã€ãŠã‚ˆã³ NDB ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 8.0 ã‹ã‚‰ 8.0.25-ndb-8.0.25 ã«åŸºã¥ã NDB Cluster ãƒªãƒªãƒ¼ã‚¹ã«ã¤ã„ã¦ãã‚Œãžã‚Œèª¬æ˜Žã—ã¾ã™ã€‚ ã¾ã ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ãªã„ MySQL ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®æ©Ÿèƒ½ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒå«ã¾ã‚Œã¦ã„ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®è©³ç´°ã¯ã€ã€ŒMySQL 8.0 ãƒªãƒªãƒ¼ã‚¹ãƒŽãƒ¼ãƒˆã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ MySQL 8.0 ã®æ©Ÿèƒ½. ã“ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã§ã¯ã€MySQL 8.0 ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«ã‚ˆã£ã¦ã¯å«ã¾ã‚Œã¦ã„ãªã„æ©Ÿèƒ½ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ã“ã®ã‚ˆã†ãªæ©Ÿèƒ½ã¯ã€ã”è‡ªèº«ã«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ä»˜ä¸Žã•ã‚Œã¦ã„ã‚‹ MySQL 8.0 ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã¦ã„ãªã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ MySQL 8.0 ã®ä½¿ç”¨ã—ã¦ã„ã‚‹ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã‚‹æ©Ÿèƒ½ã«é–¢ã™ã‚‹è³ªå•ãŒã‚ã‚‹å ´åˆã¯ã€MySQL 8.0
pnepne 2010/04/17
MySQL

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ãƒªãƒ³ã‚¯
MySQLã®charsetã‚’utf8ã«å¤‰æ›´ã™ã‚‹æ–¹æ³•
PHPã¨MySQLã®å‹‰å¼·ã‚’ã™ã‚‹ãŸã‚ã«ã€æ‰‹æŒã¡ã®PCã§XAMPPç’°å¢ƒã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¾ã§ã¯ã‚ˆã‹ã£ãŸãŒã€MySQLã§æ—¥æœ¬èªžãŒæ£ã—ãè¡¨ç¤ºã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãŸã‚æ‰‹ã“ãšã‚Šã¾ã—ãŸã€‚ åŒã˜ã‚ˆã†ã«ãƒãƒžã‚‹äººãŒå‡ºã¦ã“ãªã„ã‚ˆã†ã€æ‰‹é †ã‚’ã¾ã¨ã‚ã¾ã™ã€‚ ãƒ»XAMPP for Windows 1.6.4 ãƒ»MySQL 5.0.45(XAMPP for Windowsã®Webãƒšãƒ¼ã‚¸ã«ã¯5.0.51ã¨æ›¸ã„ã¦ã‚ã‚‹ã®ã ãŒãƒ»ãƒ»ãƒ») ãƒ»WindowsXP HomeEdition SP2 ãµã¤ã†ã«XAMMPã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã§ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã®ã¾ã¾ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ ã“ã®çŠ¶æ…‹ã§MySQLã‚’èµ·å‹•ã™ã‚‹ã¨ ã¨ãªã‚Šã€ã¿ã”ã¨ã«default_charsetã¯latin1ã«ãªã‚Šã¾ã™ã€‚ ã“ã‚Œã¯MySQLã®ãƒã‚¤ãƒŠãƒªä½œæˆæ™‚ã«ã“ã®è¨å®šã«ãªã£ã¦ã„ãŸã®ã§ã—ã‚‡ã†ãŒãªã„ã§ã—ã‚‡ã†ã€‚ ã“ã‚Œã‚’uft8ã«ã—ã¦ã„ãã¾ã™ã€‚
pnepne 2010/04/11
MySQL

UTF-8

PHP

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

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
1