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

pinkumohikan id:pinkumohikan

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

${{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ã«æŠ•ã’ã‚‰ã‚ŒãŸã™ã¹ã¦ã®SQLã‚¯ã‚¨ãƒªã‚’ãƒã‚®ãƒ³ã‚°ã™ã‚‹ - ãƒ¢ãƒ’ã‚«ãƒ³ãƒ¡ãƒ¢
æ¦‚è¦ ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ã‚„ORMãŒç”Ÿæˆã™ã‚‹ã‚¯ã‚¨ãƒªã‚’ç¢ºèªã—ãŸã„ãªã©ã®ç†ç”±ã§ã€MySQLã«æŠ•ã’ã‚‰ã‚ŒãŸã‚¯ã‚¨ãƒªã‚’ç¢ºèªã—ãŸããªã‚‹ã“ã¨ãŒã‚ã‚‹ ãã†ã„ã†ã¨ãã¯ã€MySQLã®ã‚¯ã‚¨ãƒªãƒã‚° (general_log) ã¨è¨€ã†è¨å®šã‚’ONã«ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€ã™ã¹ã¦ã®ã‚¯ã‚¨ãƒªã‚’ãƒã‚°ã«åã‹ã›ã‚‹ã“ã¨ãŒã§ãã‚‹ dev.mysql.com 5.2.3 ä¸€èˆ¬ã‚¯ã‚¨ãƒªãƒ¼ãƒã‚° ä¸€èˆ¬ã‚¯ã‚¨ãƒªãƒ¼ãƒã‚°ã¯ã€mysqld ã®å®Ÿè¡Œå†…å®¹ã®ä¸€èˆ¬çš„ãªè¨˜éŒ²ã§ã™ã€‚ã‚µãƒ¼ãƒãƒ¼ã¯ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒæŽ¥ç¶šã¾ãŸã¯æŽ¥ç¶šè§£é™¤ã—ãŸã¨ãã«æƒ…å ±ã‚’ã“ã®ãƒã‚°ã«æ›¸ãè¾¼ã¿ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰å—ã‘å–ã£ãŸå„ SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ãƒã‚°ã«è¨˜éŒ²ã—ã¾ã™ã€‚ä¸€èˆ¬ã‚¯ã‚¨ãƒªãƒ¼ãƒã‚°ã¯ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆå´ã§ã‚¨ãƒ©ãƒ¼ãŒç–‘ã‚ã‚Œã‚‹ã¨ãã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒ mysqld ã«é€ä¿¡ã—ãŸå†…å®¹ã‚’æ£ç¢ºã«çŸ¥ã‚ŠãŸã„å ´åˆã«éžå¸¸ã«å½¹ç«‹ã¤ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã‚„ã£ã¦ã¿ã‚‹ 1. ç¾åœ¨ã®è¨å®šã‚’ç¢ºèªã™ã‚‹ mysql> select version(); +----
pinkumohikan 2019/05/25
general_logã®è©±

mysql
ãƒªãƒ³ã‚¯
MySQL Innovation Day Tokyo ã§ MySQL 8 ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã«ã¤ã„ã¦è©±ã—ãŸ - @tmtms ã®ãƒ¡ãƒ¢
MySQL Innovation Day Tokyo ã«å‚åŠ ã—ã¦10åˆ†ã»ã©å–‹ã£ã¦ãã¾ã—ãŸã€‚ ã²ã•ã³ã•ã«å·¨å¤§ã‚µã‚ãƒ©ã¡ã‚ƒã‚“ç™»å ´ã€‚æœ¬äººæ›°ã5å¹´é–“ã»ã©å€‰åº«ã«éš ã‚Œã¦ãŸãã†ã§ã™ã€‚ æ˜¼ã”ã¯ã‚“ã¯ä»ŠåŠã®ã™ãç„¼å¼å½“ã§ã—ãŸã€‚è±ªè¯ï¼ ä¼šå ´ã®æ§˜åã€‚ç™¾æ•°åäººã§æº€å“¡ã§ã—ãŸ ä»¥ä¸‹ã‚ãŸã—ã®ç™ºè¡¨å†…å®¹ã€‚ã‚¹ãƒ©ã‚¤ãƒ‰ã¯ã“ã¡ã‚‰ https://tmtm.github.io/mysql-innovation-tokyo/ MySQLæ’ä¾‹ã€ŒRCã¨ã¯ã„ã£ãŸã„â€¦ã€æ¡ˆä»¶ utf8ã®æŒ‡å®šã§warningãŒå‡ºã‚‹ã‚ˆã†ã«ãªã£ãŸ mysql> set names utf8; Query OK, 0 rows affected, 1 warning (0.00 sec) Warning (Code 3719): 'utf8' is currently an alias for the character set UTF8MB3, which will be
pinkumohikan 2019/05/18
ã‚¹ãƒ¼ãƒ‘ãƒ¼ãŸã™ã‹ã‚‹ã¾ã¨ã‚

mysql
ãƒªãƒ³ã‚¯
MySQL8ã‚’ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ãŸã‚‰èµ·å‹•ã—ãªããªã£ãŸ - ãƒ¢ãƒ’ã‚«ãƒ³ãƒ¡ãƒ¢
èƒŒæ™¯ å€‹äººãƒ—ãƒãƒ€ã‚¯ãƒˆç”¨ã«MySQL8ã‚’é‹ç”¨ã—ã¦ã„ã¦å®šæœŸçš„ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã‚’è¡Œã£ã¦ã„ã‚‹ 8.0.14 ã‹ã‚‰ 8.0.16 ã«ãƒžã‚¤ãƒŠãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ãŸã¨ã“ã‚MySQLãŒèµ·å‹•ã—ãªããªã£ãŸ ðŸ’€ ãƒ•ã‚¡ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ pic.twitter.com/FrFW5kfi1Kâ€” ã´ã‚“ãã‚‚ã²ã‹ã‚“ (@pinkumohikan) April 25, 2019 èª¿æŸ»ã¨å¯¾å¿œ ãŠã‚‚ã‚€ã‚ã«startã—ã¦ã¿ã‚‹ $ sudo systemctl start mysql Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details. ã§ã™ã‚ˆãã€œã€œã€œ ç´ ç›´ã«processã®ãƒã‚°ã‚’è¦‹ã‚‹
pinkumohikan 2019/05/02
ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ç”¨ã®ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®æ‰€æœ‰æ¨©ãŒãŠã‹ã—ããªã£ã¦ãŸè¬Ž

mysql

mysql8

ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—
ãƒªãƒ³ã‚¯
MySQL5.7ä»¥é™ã§ãƒ¦ãƒ¼ã‚¶ä½œæˆæ™‚ã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãƒãƒªã‚·ãƒ¼ã§æ€’ã‚‰ã‚Œã‚‹ã¨ãã®å›žé¿ç– - ãƒ¢ãƒ’ã‚«ãƒ³ã¯æ£ç¾©
MySQL5.7.8ä»¥é™ã§ã€ã‚†ã‚‹ã„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã§ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã—ã‚ˆã†ã¨ã—ãŸéš›ã«ä¸‹è¨˜ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ã§æ€’ã‚‰ã‚Œã‚‹ mysql> create user "user_name"@"localhost" identified by "some_weak_password"; ERROR 1819 (HY000): Your password does not satisfy the current policy requirements MySQL :: MySQL 5.7 Release Notes :: Changes in MySQL 5.7.8 (2015-08-03, Release Candidate) 5.7.8ä»¥é™ã§ã¯ validate_password ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãŠã‚Šã€ãã®å½±éŸ¿ã§è„†å¼±ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¯ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã«ã‚ˆã£ã¦æ€’ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ ç¾
pinkumohikan 2018/12/22
ãŸã¾ã«å›°ã‚‹ã®ã§æ›¸ã„ãŸ

mysql
ãƒªãƒ³ã‚¯
MySQLã®ã€ŒSending dataã€ã¯ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¸ã®ãƒ‡ãƒ¼ã‚¿è»¢é€ã§ã¯ãªã„ãƒ»ãƒ»ãƒ» - ç§ã®æ´å²ã¨ä»Š
MySQLã®show processlistã§ã€ŒSending dataã€ã¨è¡¨ç¤ºã•ã‚Œã¦ã„ã‚‹å‡¦ç†ã¯ãƒ‡ãƒ¼ã‚¿è»¢é€ã ã¨æ€ã£ã¦ã„ãŸãŒã€ãã†ã§ã¯ãªã‹ã£ãŸãƒ»ãƒ»ãƒ»ã€‚å…ˆå…¥è¦³ã£ã¦æã‚ã—ã„ã€‚ ä»Šæ—¥ã¯ã‚µãƒ¼ãƒãŒé‡ã‹ã£ãŸã®ã§èª¿ã¹ã¦ã¿ãŸã‚‰ã™ã¹ã¦ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒã€ŒSending dataã€ã¨ãªã£ã¦ãŠã‚Šã€å‡¦ç†ã«3åˆ†ä»¥ä¸Šã‹ã‹ã£ã¦ã„ãŸã€‚slow queryã®ãƒã‚°ã‚’è¦‹ã‚‹ã¨ã€Œlimit 1ã€ã®æ¤œç´¢ã°ã‹ã‚Šã€‚è»¢é€ãªã‚“ã¦ã‚ã£ã¨ã„ã†é–“ã®ã¯ãšã€‚ã¨æ€ã£ã¦èª¿ã¹ã¦ã¿ãŸã‚‰ã€ŒSending dataã€ã¯ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¸ã®ãƒ‡ãƒ¼ã‚¿è»¢é€ã§ã¯ãªã‹ã£ãŸã€‚ ã€ŒThis is quite a misleading status. It should be called "reading and filtering data".ã€ â†’ http://stackoverflow.com/questions/10347193/what-does-it-mean-when-
pinkumohikan 2018/03/03
çŸ¥ã‚‰ã‚“ã‹ã£ãŸ

mysql
ãƒªãƒ³ã‚¯
mysqlã®sumã¯è©²å½“ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒãªã„å ´åˆã€nullã‚’è¿”ã™ - é‡Žé³¥æ—¥è¨˜
mysqlã®sumã¯è©²å½“ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒãªã„å ´åˆã€nullã‚’è¿”ã™ è©²å½“ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒãªã„å ´åˆã€countã¯0ã‚’è¿”ã™ã®ã§å‹˜é•ã„ã—ã¦ãŸã€‚ sumã®å ´åˆã¯nullãŒè¿”ã£ã¦ãã‚‹ã€‚ countã¨åŒæ§˜ã«0ã‚’è¿”ã—ã¦ã»ã—ã„ã¨ãã¯ä¸‹è¨˜ã®ã‚ˆã†ã«ã™ã‚‹ã€‚ SELECT IFNULL(SUM(`hoge`), 0) FROM test å‚è€ƒURL http://code.ttsoft.jp/2012/12/mysql-sum-with-ifnull-method.html
pinkumohikan 2017/10/20
ã‚ãƒ¬ãã†

mysql
ãƒªãƒ³ã‚¯
MySQL ã§ utf8 ã¨ utf8mb4 ã®æ··åœ¨ã§èµ·ãã‚‹ã“ã¨ - tmtms ã®ãƒ¡ãƒ¢
MySQL ã‚’ UTF-8 ã§ä½¿ãŠã†ã¨æ€ã£ã¦ãƒãƒžã‚ŠãŒã¡ãªã®ã¯ charset utf8 ã‚’æŒ‡å®šã—ã¦ã—ã¾ã†ã“ã¨ã§ã™ã€‚ MySQL ã® UTF-8 ã«ã¯æ´å²çš„äº‹æƒ…ã«ã‚ˆã‚Š utf8 ã¨ utf8mb4 ã®äºŒã¤ã‚ã‚Šã¾ã™ã€‚ UTF-8 ã¯1ãƒã‚¤ãƒˆã€œ4ãƒã‚¤ãƒˆã§1æ–‡å—ãŒæ§‹æˆã•ã‚Œã‚‹æ–‡å—ã‚³ãƒ¼ãƒ‰ã§ã™ãŒã€MySQL ã® utf8 ã¯4ãƒã‚¤ãƒˆæ–‡å—ã‚’æ‰±ã†ã“ã¨ãŒã§ãã¾ã›ã‚“ã€‚ãƒãƒžã‚ŠãŸããªã‘ã‚Œã° utf8mb4 ã‚’ä½¿ã„ã¾ã—ã‚‡ã†ã€‚ utf8 ã‚’ä½¿ã£ã¦ã—ã¾ã£ãŸå ´åˆã«4ãƒã‚¤ãƒˆæ–‡å—ãŒã©ã®ã‚ˆã†ã«æ‰±ã‚ã‚Œã‚‹ã‹ã€è‡ªåˆ†ã§ã‚‚ã†ã‚è¦šãˆã ã£ãŸã®ã§ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã™ã€‚ ç™»éŒ² æŽ¥ç¶šãŒ utf8mb4 ã§ã‚«ãƒ©ãƒ ãŒ utf8mb4 ã‚ãŸã‚Šã¾ãˆã§ã™ãŒã€ãã®ã¾ã¾ç™»éŒ²ã•ã‚Œã¾ã™ã€‚ mysql> insert into utf8mb4 (c) values ('ç¾Žå‘³ã—ã„ðŸ£ã¨ðŸº'); mysql> select * from utf8mb4; +--------
pinkumohikan 2017/09/06
çµµæ–‡å—å¯¾å¿œã™ã‚‹ã¨ãã¯utf8mb4ã‚’ä½¿ã†ã“ã¨

mysql

utf8mb4
ãƒªãƒ³ã‚¯
1