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

cyar id:cyar

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

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

ã€ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã€‘phpMyAdminã‹ã‚‰MySQLã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆãŒå¤±æ•—ï¼ˆã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆï¼Ÿï¼‰ã™ã‚‹ã¨ãã®å¯¾å‡¦æ³• â€“ ysklog
WordPressã‚’ã‚¨ãƒƒã‚¯ã‚¹ã‚µãƒ¼ãƒãƒ¼ã‹ã‚‰ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã«ç§»è»¢ã™ã‚‹éš›ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆMySQLï¼‰ã‚’phpMyAdminã‹ã‚‰ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ã‚ˆã†ã¨ã—ãŸã®ã§ã™ãŒã€ä½•åº¦ã‚„ã£ã¦ã‚‚å¤±æ•—ï¼ˆã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã®ã‚¨ãƒ©ãƒ¼ï¼Ÿï¼‰ã«ãªã‚Šã¾ã—ãŸã€‚ ã“ã“ã§ã¯ã“ã®ã¨ãã«å¯¾å‡¦ã—ãŸæ–¹æ³•ã‚’ãƒ¡ãƒ¢ã—ã¦ãŠããŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ããªã‹ã£ãŸåŽŸå› ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®phpMyAdminã‚’ä½¿ã£ã¦ãªãœã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ã«MySQLã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ããªã‹ã£ãŸã®ã‹ï¼Ÿã«ã¤ã„ã¦ã§ã™ãŒã€å˜ç´”ã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆå¯¾è±¡ã®MySQLã®å®¹é‡ãŒå¤§ãã™ãŽãŸã‹ã‚‰ã§ã™ï¼ˆ42.3MBã‚‚ã‚ã‚Šã¾ã—ãŸï¼‰ã€‚ ãã®ãŸã‚ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã¨ãªã£ã¦ã‚¤ãƒ³ãƒãƒ¼ãƒˆãŒã†ã¾ãã„ã‹ãšã€ä½•åº¦ã‚„ã£ã¦ã‚‚phpMyAdminã®ãƒã‚°ã‚¤ãƒ³ãƒšãƒ¼ã‚¸ã«ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã•ã‚Œã¾ã—ãŸï¼ˆå®¹é‡ãŒå°ã•ã„ã‚‚ã®ã¯å•é¡Œãªãã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ããŸï¼‰ã€‚ ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã«ãªã‚‰ãªã„æ–¹æ³• ã‚¿
cyar 2018/04/23
mysql
ãƒªãƒ³ã‚¯
è¶…å·¨å¤§ãª MySQL ã®ãƒ‡ãƒ¼ã‚¿ã‚’å…±ç”¨ã‚µãƒ¼ãƒãƒ¼ã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ãã‚‹ BigDump ã®ä½¿ã„æ–¹
æ•°GBã®ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ãŸãã¦ã‚‚å…±ç”¨ã‚µãƒ¼ãƒãƒ¼ã®å ´åˆã§ã™ã¨æ•°åMBã«åˆ¶é™ã•ã‚Œã¦ã„ã‚‹ã“ã¨ãŒå¤šãã¦å…¥ã‚Œã‚‰ã‚Œã¾ã›ã‚“ã€‚VPS ã‚„å°‚æœ‰ã‚µãƒ¼ãƒãƒ¼ã®å ´åˆã¯è¨å®šã‚’å¤‰æ›´ã—ã¦ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã§ãã‚‹æœ€å¤§ã‚µã‚¤ã‚ºã‚’å¤‰æ›´ã™ã‚‹æ–¹æ³•ã‚‚ã‚ã‚Šã¾ã™ãŒã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºãŒå¢—ãˆã‚‹ãŸã³ã«å¤‰æ›´ã™ã‚‹ã®ã¯å¤§å¤‰ã§ã™ã€‚ ã—ã‹ã— BigDump ã‚’ä½¿ãˆã°å·¨å¤§ãª SQL ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚µãƒ¼ãƒãƒ¼ã«åˆã‚ã›ã¦åˆ†å‰²ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ã¦ãã‚Œã‚‹ã®ã§ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºãŒå¤§ãããªã£ã¦ã‚‚ã‚µãƒ¼ãƒãƒ¼ã®è¨å®šã‚’å¤‰æ›´ã—ãªãã¦ã‚‚è‰¯ã„ã§ã™ã—ã€å…±ç”¨ã‚µãƒ¼ãƒãƒ¼ã§ã‚‚å·¨å¤§ãªãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã“ã§ã¯ BigDump ã‚’ä½¿ã£ãŸ SQL ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆã‚’èª¬æ˜Žã—ã¾ã™ã€‚èª¬æ˜Žã«ã‚ãŸã£ã¦ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸ãŒå‚è€ƒã«ãªã‚Šã¾ã—ãŸã®ã§ã“ã¡ã‚‰ã‚‚å¾¡è¦§ãã ã•ã„ã€‚ WikiCookRecipeæ—¥è¨˜: MySQLã‚¤ãƒ³ãƒãƒ¼ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ãŒã§ã‹ã™ãŽã‚‹æ™‚ã«ã¯ BigDump ã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ï¼ MySQL ã®ãƒ‡ãƒ¼
cyar 2018/04/23
mysql
ãƒªãƒ³ã‚¯
åˆ¥ã®ã‚µãƒ¼ãƒãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã—ãŸã„
MySQLï¼ˆãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ï¼‰ã¯ã€TCX DataKonsultABç¤¾ãªã©ãŒé–‹ç™ºã™ã‚‹RDBMSï¼ˆãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ )ã§ã™ã€‚ä¸–ç•Œã§æœ€ã‚‚äººæ°—ã®é«˜ã„ã‚·ã‚¹ãƒ†ãƒ ã§ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã¯ã€é«˜é€Ÿæ€§ã¨ä¿¡é ¼æ€§ãŒã‚ã‚Šã€Linuxã€UNIXã€Windowsãªã©ã®è¤‡æ•°ã®ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§å‹•ä½œã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ PHPã¯ã€Webã‚µã‚¤ãƒˆæ§‹ç¯‰ã«ç‰¹åŒ–ã—ã¦é–‹ç™ºã•ã‚ŒãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã™ã€‚å¤§ããªç‰¹å¾´ã®ã²ã¨ã¤ã¯ã€HTMLã«ç›´æŽ¥ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’åŸ‹ã‚è¾¼ã‚€ã“ã¨ãŒã§ãã‚‹ã¨ã„ã†ç‚¹ã§ã™ã€‚PHPã‚’ç”¨ã„ã‚‹ã“ã¨ã§ã€HTMLã‚’å‹•çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¨ã—ã¦å‡ºåŠ›ã§ãã¾ã™ã€‚HTMLãŒãã®ã¾ã¾ãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ã®ã«å¯¾ã—ã€PHPãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã‚µãƒ¼ãƒå´ã§å®Ÿè¡Œã•ã‚ŒãŸçµæžœãŒãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ãŸã‚ã€PHPã‚¹ã‚¯ãƒªãƒ—ãƒˆã¯ã€Œã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚¹ã‚¯ãƒªãƒ—ãƒˆã€ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚
cyar 2018/04/16
å¤–éƒ¨æŽ¥ç¶šè¨±å¯

mysql
ãƒªãƒ³ã‚¯
Google
ä¸–ç•Œä¸ã®ã‚ã‚‰ã‚†ã‚‹æƒ…å ±ã‚’æ¤œç´¢ã™ã‚‹ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã‚’æä¾›ã—ã¦ã„ã¾ã™ã€‚ã•ã¾ã–ã¾ãªæ¤œç´¢æ©Ÿèƒ½ã‚’æ´»ç”¨ã—ã¦ã€ãŠæŽ¢ã—ã®æƒ…å ±ã‚’è¦‹ã¤ã‘ã¦ãã ã•ã„ã€‚
cyar 2018/04/15
å¤–éƒ¨æŽ¥ç¶šè¨±å¯

mysql
ãƒªãƒ³ã‚¯
ã€MySQLã€‘ãƒ¦ãƒ‹ãƒ¼ã‚¯åˆ¶ç´„ã®å‰Šé™¤ - pospomeã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æ—¥è¨˜
ãƒ¦ãƒ‹ãƒ¼ã‚¯åˆ¶ç´„ã‚’å‰Šé™¤ã—ã‚ˆã†ã¨ã—ã¦ã€ ALTER TABLE CHANGE , ALTER TABLE MODIFY ã‚’å®Ÿè¡Œã—ãŸã‘ã©ã€ å‰Šé™¤ã§ããªã„ãƒ»ãƒ»ãƒ»ã€‚ ãƒ¦ãƒ‹ãƒ¼ã‚¯åˆ¶ç´„ã‚’è¿½åŠ ã™ã‚‹ã¨ã€ è‡ªå‹•çš„ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã§ãã‚‹ã‚‰ã—ããƒ»ãƒ»ãƒ»ã€‚ ãã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å‰Šé™¤ã™ã‚‹ã“ã¨ã§ãƒ¦ãƒ‹ãƒ¼ã‚¯åˆ¶ç´„ãŒå‰Šé™¤ã§ãã‚‹ã‚‰ã—ã„ã€‚ ã¨ã„ã†ã“ã¨ã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ç¢ºèªã™ã‚‹ã€‚ SHOW INDEX FROM tb_test; ãã®ä¸ã§è©²å½“åˆ—ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å‰Šé™¤ã™ã‚‹ã€‚ ALTER TABLE tb_test DROP INDEX em ail; ã“ã‚Œã§OKã€‚
cyar 2018/03/16
ãƒ¦ãƒ‹ãƒ¼ã‚¯ã‚ãƒ¼ã®å‰Šé™¤

mysql
ãƒªãƒ³ã‚¯
PHPã§ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½¿ã£ã¦SQLã‚’ç™ºè¡Œã™ã‚‹æ–¹æ³•ã€œPDOã®ä½¿ã„æ–¹ | Webæ´»ãƒ¡ãƒ¢å¸³
æœ¬æ—¥PHPã§ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ï¼ˆSQLã‚’ç™ºè¡Œã™ã‚‹éš›ã«å¾Œã‹ã‚‰å€¤ã‚’æŒ‡å®šã™ã‚‹æ–¹æ³•ï¼‰ã®ã‚„ã‚Šæ–¹ã‚’èžã‹ã‚ŒãŸã®ã§ãƒ–ãƒã‚°ã§ã‚‚ã‚·ã‚§ã‚¢ã€‚ PHPã§ã¯PDOã‚’ä½¿ã†äº‹ã§ç°¡å˜ã«ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã‚ˆã€‚ ä»¥ä¸‹ã®ã‚µã‚¤ãƒˆã‚’å‚è€ƒã«ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚æ„Ÿè¬ï¼ PDOã§æŽ¥ç¶šã€SELECTã€ãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¨ã¯ï¼ˆPHPã§MySQLã«æŽ¥ç¶šï¼‰ PHPã§PDOã‚’ä½¿ã£ã¦MySQLã«æŽ¥ç¶šã€INSERTã€UPDATEã€DELETEã€COUNTã€SUM â€“ Qiita ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã¨ã¯ å®Ÿéš›ã«ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½¿ã£ãŸä¾‹ã‚’è¦‹ã¦ã¿ã¾ã—ã‚‡ã† $sth = $dbh->prepare('SELECT name, color, calories FROM fruit WHERE calories < ? AND color = ?'); $sth->execute(array(150, 'red')); ã“ã®ã€Œ?ï¼ˆãƒãƒ†ãƒŠï¼‰ã€è¨˜å·ãŒ
cyar 2018/03/07
mysql

sqlã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
PHP ã§ã® SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã¯ã©ã®ã‚ˆã†ã«è¡Œã„ã¾ã™ã‹ï¼Ÿ
å‰æ ã¾ãšã€SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã‚’å«ã‚ã€è„†å¼±æ€§å¯¾ç–ã®å‰æã¨ã—ã¦ãªã‚‹ã¹ãæ–°ã—ã„å®‰å®šç‰ˆã® PHP ã‚’åˆ©ç”¨ã™ã‚‹ã‚ˆã†ã«ã—ã¦ãã ã•ã„ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã«ã‚ˆã‚Šè„†å¼±æ€§ãŒè§£æ¶ˆã—ãŸã‚Šã€ã‚ˆã‚Šå®‰å…¨ã«ãªã£ã¦ã„ã¾ã™ã€‚ ãªãŠã€ä»¥ä¸‹ã®æ–¹æ³•ã¯ PHP 5.3.7 ä»¥ä¸Šã§å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚ï¼ˆPHP 5.3.6 ã§ã‚‚å¯¾å¿œã—ã¦ã„ã¾ã™ãŒã€Windowsã®å®Ÿè£…ãŒä¸å®Œå…¨ã§ã™ï¼‰ ãŸã ã—ã€PHP 5.3 ç³»ã¯ 2014/8/14 ã§ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚µãƒãƒ¼ãƒˆãŒçµ‚äº†ã—ã¦ã„ã¾ã™ã€‚ PDO + é™çš„ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ç”¨ã„ãŸ SQL æ–‡ç™ºè¡Œ PDO ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã€ä»¥ä¸‹ã®ãƒã‚¤ãƒ³ãƒˆã‚’æŠ¼ã•ãˆã‚‹ã“ã¨ã§å®‰å…¨ã«åˆ©ç”¨å‡ºæ¥ã¾ã™ã€‚ 1.æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’æŒ‡å®šã™ã‚‹ 2.é™çš„ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ç”¨ã„ã‚‹ 3.ãƒã‚¤ãƒ³ãƒ‰æ™‚ã«åž‹ã‚’æŒ‡å®šã™ã‚‹ ãã‚Œãžã‚Œã«ã¤ã„ã¦ã€ä»¥ä¸‹ã«å®Ÿè£…æ–¹æ³•ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ 1. æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’æŒ‡å®šã™ã‚‹ æœŸå¾…ã—ãŸæ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã¨ã—ã¦å‹•ä½œã™ã‚‹ã‚ˆã†ã€
cyar 2018/03/07
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³

MySQL

PDO

PHP
ãƒªãƒ³ã‚¯
PHP: æ–‡å—ã‚»ãƒƒãƒˆ - Manual
æ–‡å—ã‚»ãƒƒãƒˆ é©åˆ‡ãªæ–‡å—ã‚»ãƒƒãƒˆã‚’ã‚µãƒ¼ãƒãƒ¼ãƒ¬ãƒ™ãƒ«ã§è¨å®šã—ã¦ãŠãã®ãŒç†æƒ³ã§ã‚ã‚Šã€MySQL ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã® Â»Â Character Set Configuration ã«ã‚‚ãã†ã™ã‚‹ã‚ˆã†æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã—ã‹ã—ãã‚Œä»¥å¤–ã«ã‚‚ã€å„ MySQL API ã«ã¯å®Ÿè¡Œæ™‚ã«æ–‡å—ã‚»ãƒƒãƒˆã‚’æŒ‡å®šã™ã‚‹æ–¹æ³•ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ è¦å‘Š æ–‡å—ã‚»ãƒƒãƒˆã¨æ–‡å—ã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ— æ–‡å—ã‚»ãƒƒãƒˆã¯ãã¡ã‚“ã¨ç†è§£ã—ã¦è¨å®šã—ã¦ãŠã‹ãªã„ã¨ã„ã‘ã¾ã›ã‚“ã€‚ ã™ã¹ã¦ã®æ“ä½œã«å½±éŸ¿ãŒåŠã³ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®å•é¡Œã‚’å¼•ãèµ·ã“ã™å¯èƒ½æ€§ãŒã‚ã‚‹ã‹ã‚‰ã§ã™ã€‚ ãŸã¨ãˆã°ã€æ–‡å—åˆ—ã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ— (mysqli ãªã‚‰ mysqli_real_escape_string()ã€ PDO_MySQL ãªã‚‰ PDO::quote()) ã¯æ–‡å—ã‚»ãƒƒãƒˆã®è¨å®šã«å¾“ã£ãŸå‹•ãã‚’ã—ã¾ã™ã€‚ ã“ã‚Œã‚‰ã®é–¢æ•°ã¯ã€ã‚¯ã‚¨ãƒªã§è¨å®šã—ãŸæ–‡å—ã‚»ãƒƒãƒˆã¯ä½¿ã‚ãªã„ã“ã¨ã‚’çŸ¥ã£ã¦ãŠãã“ã¨ãŒå¤§åˆ‡ã§ã™ã€‚ ãŸã¨ãˆã°æ¬¡ã®ä¾‹ã®ã‚ˆã†ãªè¨å®šã‚’ã—ã¦ã‚‚
cyar 2018/03/07
mysql
ãƒªãƒ³ã‚¯
PDOã§mysqlã«æŽ¥ç¶šã™ã‚‹æ™‚ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ | Bamboo lath æ—¥ã€…ã®è¨˜éŒ²
ä¹…ã—ã¶ã‚Šã«ãƒ¡ãƒ¢ã€‚ é–‹ç™ºç’°å¢ƒã§PDOã‹ã‚‰mysqlã«ã¤ãªã„ã§ãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚ŒãŸã‚Šã—ã¦ãŸã®ã« æœ¬ç•ªã‚µãƒ¼ãƒã«è¨ç½®ã—ãŸé€”ç«¯ã«ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰å…¥ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãŒæ–‡å—åŒ–ã‘ã—ãŸã€‚ mysql> show variables like 'character_set%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | bina
cyar 2018/03/07
mysql

PDO
ãƒªãƒ³ã‚¯
PDOã§æŽ¥ç¶šã€SELECTã€ãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¨ã¯ï¼ˆPHPã§MySQLã«æŽ¥ç¶šï¼‰ - Qiita
PDOã£ã¦ä½•ãªã‚“ã ã€‚ PDOã¯ã€ŒPHP Data Objectsã€ã®é æ–‡å—ã‚’ã¨ã£ãŸåç§°ã§ã™ã€‚ ã£ã¦è¨€ã‚ã‚Œã¦ã‚‚ã€Œä½•ãŒã©ã†ãªã£ã¦ã‚“ã®ï¼Ÿã€ã¨æ€ã„ã€ãªã‹ãªã‹åˆ†ã‹ã‚‰ãªã‹ã£ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹æŠ½è±¡åŒ–ãƒ¬ã‚¤ãƒ¤ã¨ã‹è¨€ã‚ã‚Œã¦ã‚‹ã‘ã©ã€ã€Œã„ã‚„ã€ã ã‹ã‚‰ã‚½ãƒ¬ä½•ï¼Ÿã€ã£ã¦æ„Ÿã˜ã§ã™ã€‚ èª¿ã¹ãŸã®ã§è§£èª¬ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹æŠ½è±¡åŒ–ãƒ¬ã‚¤ãƒ¤ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨DBMSï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼‰ã®é–“ã«å…¥ã£ã¦DBMSã®é•ã„ã‚’æ„è˜ã›ãšã«ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã™ã‚‹ã‚‚ã®ã€‚ è¦ã™ã‚‹ã«ã€Œè‰²ã‚“ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒã‚ã‚‹ã‘ã©ã€åŒã˜æ§˜ã«æ›¸ã„ã¦ã‚‚å…¨éƒ¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾å¿œã—ã¦ã¾ã™ã‚ˆã€ã£ã¦äº‹ã§ã™ã€‚ï¼ˆè‹¥å¹²ã®å·®ç•°ã¯ã‚ã‚‹ã‚‰ã—ã„ï¼‰ ã¤ã¾ã‚ŠPDOã£ã¦â€¦ ãã®ãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹æŠ½è±¡åŒ–ãƒ¬ã‚¤ãƒ¤ã®ä¸€ã¤ã§ã€PHP5.1ã‹ã‚‰ãƒãƒ³ãƒ‰ãƒ«ã•ã‚Œã¦ã‚‹ï¼ˆæ¨™æº–ã§ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ã¦ã‚‹ï¼‰ãƒ¤ãƒ„ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é€”ä¸ã§å¤‰æ›´ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„éš›ãªã©ã‚’è€ƒãˆã‚‹ã¨ä½¿ã„ã‚„ã™ã„ã€‚ ãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã§çµæ§‹å‹•
cyar 2018/03/07
PDO

mysql
ãƒªãƒ³ã‚¯
ä½¿ç”¨å¯èƒ½ï¼ˆæœ‰åŠ¹ï¼‰ãªæ–‡å—ã‚³ãƒ¼ãƒ‰ã®ä¸€è¦§ã‚’èª¿ã¹ã‚‹ - MySQL é€†å¼•ããƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
MySQL ã§ä½¿ç”¨å¯èƒ½ãªæ–‡å—ã‚³ãƒ¼ãƒ‰ã®ä¸€è¦§ã¯ SHOW CHARACTER SET ã§èª¿ã¹ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ SHOW CHARACTER SET Windows7 + MySQL5.6.21 ã§å®Ÿè¡Œã—ã¦ã¿ãŸçµæžœã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ mysql> SHOW CHARACTER SET; +----------+-----------------------------+---------------------+--------+ | Charset | Description | Default collation | Maxlen | +----------+-----------------------------+---------------------+--------+ | big5 | Big5 Traditional Chinese | big5_chinese_ci | 2
cyar 2018/03/06
mysql
ãƒªãƒ³ã‚¯
PDOã‚’ä½¿ã£ãŸPHPã§ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŸºæœ¬æ“ä½œ - Qiita
PHPã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹æ–¹æ³•ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ç°¡æ˜“ãªè§£èª¬ãªã®ã§ã€ãƒ—ãƒã‚°ãƒ©ãƒ ã®æ—¥ãŒæµ…ã„äººã¯ç†è§£ã§ããªã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚å¾©ç¿’ç”¨ã¨ã—ã¦ãŠä½¿ã„ãã ã•ã„ã€‚ PHPã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹å ´åˆã¯ã€ã¾ãšPDOã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ç”Ÿæˆã—ã¾ã™ã€‚ã“ã®æ™‚ã¯ã‚³ãƒ³ã‚¹ãƒˆãƒ©ã‚¯ã‚¿ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æƒ…å ±ã‚’è¨å®šã—ã¦ãŠãã¾ã™ã€‚ å¾Œã¯ã€ãã®PDOã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒ¡ã‚½ãƒƒãƒ‰ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ã ã‘ã§ã™ã€‚ä»Šå›žã¯ã€$dbhã¨ã„ã†å¤‰æ•°ã§PDOã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ç®¡ç†ã—ã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã«å¿…è¦ãªæƒ…å ± ã¾ãšã¯ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã§ã™ã€‚ <?php define('DB_HOST', 'DBã®å ´æ‰€'); define('DB_NAME', 'DBã®åå‰'); define('DB_USER', 'ãƒ¦ãƒ¼ã‚¶ãƒ¼å'); define('DB_PASSWORD', 'ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰'); // æ–‡å—åŒ–ã‘å¯¾ç– $options = array(PDO::MYSQL
cyar 2018/03/06
PHP

mysql
ãƒªãƒ³ã‚¯
PHPã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ã¨ãã®ã¾ã¨ã‚ - Qiita
ã€2021/10/15 è¿½è¨˜ã€‘ ã“ã®è¨˜äº‹ã¯æ›´æ–°ãŒåœæ¢ã•ã‚Œã¦ã„ã¾ã™ã€‚ç¾åœ¨ã§ã¯ç†è€…ã®æ€æƒ³ãŒå¤‰åŒ–ã—ã¦ã„ã‚‹é¢ã‚‚ã‚ã‚Šã¾ã™ã®ã§ï¼ŒéŽåŽ»ã®è¨˜äº‹ã¨ã—ã¦å‚è€ƒç¨‹åº¦ã«ã”è¦§ãã ã•ã„ã€‚PDO ã«é–¢ã—ã¦ã¯å¤§ããå¤‰ã‚ã£ã¦ã„ãªã„éƒ¨åˆ†ãŒå¤šã„ã¨ã¯æ€ã„ã¾ã™ãŒï¼Œ PHP 8.x ä»¥é™ã§ã®å‹•ä½œä¿è¨¼ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã‚ã‚‰ã‹ã˜ã‚èªã‚“ã§ãŠããŸã„è¨˜äº‹ Qiita - ã€PHPè¶…å…¥é–€ã€‘ã‚¯ãƒ©ã‚¹ï½žä¾‹å¤–å‡¦ç†ï½žPDOã®åŸºç¤Ž by @7968 åˆå¿ƒè€…ãŒã‚„ã‚ŠãŒã¡ãªãƒŸã‚¹ ä»¥ä¸‹ã®ã©ã‚Œã‹ã«1ã¤ã§ã‚‚å½“ã¦ã¯ã¾ã‚‹ã‚³ãƒ¼ãƒ‰ã¯è¦‹ç›´ã™å¿…è¦ãŒã‚ã‚Šã¾ã™ï¼Žä»˜éŒ²ã«ãƒªãƒ³ã‚¯ã‚’è²¼ã£ã¦ãŠãã¾ã—ãŸã®ã§ï¼Œã€Œè©²å½“ã™ã‚‹ã‹ã‚‚ï¼Ÿã€ã¨ã„ã†äººã¯ã‚¯ãƒªãƒƒã‚¯ã—ã¦é£›ã‚“ã§èªã‚“ã§ãã ã•ã„ï¼Žå¤ªå—ã«ã—ã¦ã‚ã‚‹ã‚‚ã®ã¯è„†å¼±æ€§ã«ç›´çµã™ã‚‹å±é™ºåº¦ã®é«˜ã„ã‚‚ã®ã§ã™ï¼Ž mysql_query ãªã©ã®éžæŽ¨å¥¨é–¢æ•°ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ SET NAMES ã‚ã‚‹ã„ã¯ SET CHARACTER SET ãªã©ã§æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã—ã¦ã„ã‚‹ ãã‚‚ãã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
cyar 2018/03/06
php

mysql
ãƒªãƒ³ã‚¯
WordPressã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®‰å…¨ã«ä½¿ã†ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ #WordPressï½œCodeIQ MAGAZINE
WordPressã¯MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚è‡ªä½œãƒ—ãƒ©ã‚°ã‚¤ãƒ³ç‰ã‹ã‚‰ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã‚¢ã‚¯ã‚»ã‚¹å¯èƒ½ã§ã™ã€‚ãã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ã‚¯ã‚¨ãƒªã‚’ç™ºè¡Œã™ã‚‹æ™‚ã€WordPressã§ç”¨æ„ã•ã‚Œã¦ã„ã‚‹å‹•çš„ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½¿ãˆã°ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚’é˜²ãã“ã¨ãŒã§ãã¾ã™ã€‚ ã—ã‹ã—ã€ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã¯é©åˆ‡ã«ä½¿ã‚ãªã„ã¨æ„å‘³ãŒã‚ã‚Šã¾ã›ã‚“ã€‚æ£ã—ã„ä½¿ã„æ–¹ã‚’å¦ã³ã¾ã—ã‚‡ã†ã€‚ by ãƒ¬ã‚¹ã‚ãƒ¥ãƒ¼ãƒ¯ãƒ¼ã‚¯æ ªå¼ä¼šç¤¾ã€€æ°´é‡Žå²åœŸ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†å ´åˆã€ä¸æ£ãªæ–‡å—åˆ—ã‚’å…¥åŠ›ã•ã‚Œã¦ã—ã¾ã†ã“ã¨ã«æ³¨æ„ã—ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸æ£ãªæ–‡å—åˆ—ã‚’é©åˆ‡ã«å‡¦ç†ã—ãªã‹ã£ãŸå ´åˆã€æƒ³å®šå¤–ã®SQLãŒå®Ÿè¡Œã•ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã‚’æ›¸ãæ›ãˆã‚‰ã‚ŒãŸã‚Šã€å…¨ã¦æ¶ˆã•ã‚Œã¦ã—ã¾ã£ãŸã‚Šã€ã¨ã„ã£ãŸè¢«å®³ãŒç™ºç”Ÿã™ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ã“ã®ã‚ˆã†ãªæ”»æ’ƒã‚’SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨å‘¼ã³ã¾ã™ã€‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã™ã‚‹å ´åˆã¯ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ãŒèµ·ããªã„
cyar 2018/01/25
ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€

mysql
ãƒªãƒ³ã‚¯
ã€Railsã€‘URLã‚’ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å¯èƒ½ãªå½¢ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿å˜ã™ã‚‹æ–¹æ³• - Qiita
ã¯ã˜ã‚ã« URLã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ¦ãƒ‹ãƒ¼ã‚¯ã«ä¿å˜ã—ãŸããªã‚‹æ™‚ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ URLã¯ä»•æ§˜ã¨ã—ã¦ã¯é•·ã•ã®ä¸Šé™ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã‚¯ã‚¨ãƒªãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã‚„ãƒ•ãƒ©ã‚°ãƒ¡ãƒ³ãƒˆã‚’å«ã‚ãŸé•·ã„URLã¯ã€stringåž‹ã§ã¯ä¿å˜ã§ããštextåž‹ã§ä¿å˜ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã—ã‹ã—ã€textåž‹ã¯ã”å˜çŸ¥ã®é€šã‚ŠMySQLã‚„PostgreSQLã§ã¯ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚Œã¾ã›ã‚“ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒè²¼ã‚Œãªã‘ã‚Œã°ã€UNIQUEã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚‚è²¼ã‚Œãªã„ã®ã§ã€é‡è¤‡ãƒ‡ãƒ¼ã‚¿ãŒæŒ¿å…¥ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ ã¾ãŸã€ã™ã§ã«ä¿å˜ã•ã‚ŒãŸURLã‚’æ¤œç´¢ã™ã‚‹ã®ã«ã‚‚ä¸åˆ©ã§ã™ã€‚ ãã“ã§ã€railsã‚’ä½¿ã£ã¦ã€URLã‚’stringåž‹ã§ã€ãƒ¢ãƒ‡ãƒ«ã¨ã—ã¦ä¿å˜ã™ã‚‹æ–¹æ³•ã‚’è€ƒãˆã¾ã—ãŸã€‚ ãƒãƒƒã‚·ãƒ¥ã‚’åˆ©ç”¨ã™ã‚‹ã‘ã©ãƒ»ãƒ»ãƒ» é•·ã„æ–‡å—åˆ—ã‚’ä¿å˜ã™ã‚‹ãŸã‚ã®æ–¹æ³•ã¨ã—ã¦ã€ãƒãƒƒã‚·ãƒ¥é–¢æ•°ã‚’åˆ©ç”¨ã—ã¾ã™ã€‚ ã”å˜çŸ¥ã®é€šã‚Šã€ãƒãƒƒã‚·ãƒ¥é–¢æ•°ã‚’åˆ©ç”¨ã™ã‚Œã°ã©ã‚“ãªã«é•·ã„æ–‡å—åˆ—ã‚‚çŸã„æ–‡å—åˆ—ã«ä¸€æ„ã«å¤‰æ›ã§ãã¾ã™ã€‚ ãƒãƒƒã‚·ãƒ¥é–¢æ•°
cyar 2018/01/20
mysql
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒ‡ãƒ¼ã‚¿ã‚’MySQLã«ç§»è¡Œã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
cyar 2017/10/24
mysql

postgresql
ãƒªãƒ³ã‚¯
1