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

hamaco id:hamaco

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

${{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ã§ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‚’UUIDã«ã™ã‚‹å‰ã«çŸ¥ã£ã¦ãŠã„ã¦æ¬²ã—ã„ã“ã¨ | Raccoon Tech Blog [æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ æŠ€è¡“æˆ¦ç•¥éƒ¨ãƒ–ãƒã‚°]
æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢/ãƒ‡ã‚¶ã‚¤ãƒŠãƒ¼ã‹ã‚‰æŠ€è¡“æƒ…å ±ã‚’ã¯ã˜ã‚ã€ä¸–ã®ä¸ã®ãŸã‚ã«ãªã‚‹ã“ã¨ã‚„ç¤¾å†…ã®ã“ã¨ãªã©ã‚’ç™ºä¿¡ã—ã¦ã¾ã™ã€‚ bashãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQLInnoDB DBè¨è¨ˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã“ã‚“ã«ã¡ã¯ã€ç¾½å±±ã§ã™ã€‚ ä»Šå›žã¯ MySQL ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã« UUID ã‚’æŽ¡ç”¨ã™ã‚‹å ´åˆã«èµ·ãã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å•é¡Œã‚’ä»•çµ„ã¿ã‹ã‚‰è§£èª¬ã—ã¾ã™ã€‚ MySQL(InnoDB) & UUID ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¤ã„ã¦ã¯å„æ‰€ã§ã•ã‚“ã–ã‚“è°è«–ãƒ»æ¤œè¨¼ã•ã‚Œã¦ã„ã¾ã™ãŒã€è«–ç†çš„ã«è§£èª¬ã—ãŸè¨˜äº‹ãŒå°‘ãªã‹ã£ãŸã‚Šä¸€éƒ¨ã«ã¯èª¤è§£ã‚’æ‹›ãã‚ˆã†ãªã‚‚ã®ã‚‚ã‚ã‚‹ãŸã‚ã€ã—ã£ã‹ã‚Šã¨ç†ç”±ã‹ã‚‰ç†è§£ã™ã‚‹ãŸã‚ã®æƒ…å ±ã¨ã—ã¦å½¹ç«‹ã¤ã“ã¨ãŒã§ãã‚Œã°ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ UUID ã¨æ¯”è¼ƒã•ã‚Œã‚‹å¤ãè‰¯ãæ˜‡é †/é™é †ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã¯ã¨ã„ã†ã¨ã€ MySQL ã® InnoDB ã«ãŠã„ã¦è‰¯ã„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‡ºã™ãŸã‚ã«ç¸ã®ä¸‹ã®åŠ›æŒã¡ã®ã‚ˆã†ãªåƒãã‚’ã—ã¦ãã‚Œã¦ã„ã‚‹ã‚±ãƒ¼ã‚¹ãŒå®Ÿã¯å°‘ãª
hamaco 2022/02/22
mysql
ãƒªãƒ³ã‚¯
æ—¥ã€…ã®è¦šæ›¸: MySQL 8.0ã§ã¯ã€ŒGROUP BYã«ã‚ˆã‚‹æš—é»™ã®ã‚½ãƒ¼ãƒˆã€ãŒã•ã‚Œãªããªã‚‹ã‚ˆ
GROUP BY implicitly sorts by default (that is, in the absence of ASC or DESC designators), but relying on implicit GROUP BY sorting in MySQL 5.7 is deprecated. $ perl -ML -E 'for (my $n= 1; $n <= 10; $n++) { for (my $m= 1; $m <= 100; $m++) { printf("%d\t%d\n", $n, $m) } }' | sort -R > /tmp/seq mysql80 165> CREATE TABLE t1 (n int, m int); Query OK, 0 rows affected (0.05 sec) mysql80 165> LOAD DATA
hamaco 2018/11/08
æš—é»™ã®ã‚½ãƒ¼ãƒˆçŸ¥ã‚‰ãªã‹ã£ãŸã€‚

mysql
ãƒªãƒ³ã‚¯
MySQLã‚’å‰²ã¨ä¸€äººã§300å°ç®¡ç†ã™ã‚‹æŠ€è¡“
2017/09/05 db tech showcase Tokyo 2017 http://www.db-tech-showcase.com/dbts/tokyo
hamaco 2017/09/07
mysql
ãƒªãƒ³ã‚¯
MySQL 8.0ã§ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æ¿ç‚¹åŠæ¿ç‚¹ã‚’åŒºåˆ¥ã—ãªããªã‚‹ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
4æœˆã«MySQL 8.0ã®Unicodeã¨æ—¥æœ¬èªžå¯¾å¿œã«ã¤ã„ã¦Manyi Luã•ã‚“ã¨ãƒ‡ã‚£ã‚¹ã‚«ãƒƒã‚·ãƒ§ãƒ³ã™ã‚‹ä¼šãŒã‚ã£ã¦ã€ã‹ãªã‚Šã„ã‚ã„ã‚è©±ã—ã¦ã¨ã¦ã‚‚ã‚ˆã„ä¼šã ã£ãŸã€‚ãã®å¾Œã„ã‚ã„ã‚è€ƒãˆã¦æ„Ÿã˜ã¦ã‚‹æ‡¸å¿µã‚’ç«¯çš„ã«æ›¸ãè¨˜ã—ã¦ãŠãã€‚ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®collationãŒutf8mb4_0900_ai_ciã«ãªã£ãŸ ã“ã‚Œã«é–¢ã—ã¦åƒ•ã¯å¼·ã„æ‡¸å¿µã‚’æŒã£ã¦ã„ã‚‹ã€‚MySQL 8.0ä»¥å‰ã«ãŠã„ã¦ã€ãµã¤ã†ã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã©ã§æ—¥æœ¬èªžã‚’æ‰±ã†å ´åˆã€å®Ÿç”¨ä¸Šãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®utf8mb4_general_ciã‹utf8mb4_binã®2æŠžã§ã‚ã£ãŸã¨æ€ã†ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒutf8mb4_general_ciãªã®ã§æ–°ã—ãä½œã‚‰ã‚Œã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯é€šå¸¸ã¯æ¿ç‚¹åŠæ¿ç‚¹ãŒåŒºåˆ¥ã•ã‚Œã‚‹çŠ¶æ…‹ã§ä¸–ã«å‡ºã¦ãã‚‹ã“ã¨ã«ãªã‚‹ã€‚ã‘ã©MySQL 8.0.1ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®utf8mb4_0900_ai_ciã¯æ¿ç‚¹åŠæ¿ç‚¹ã‚’åŒºåˆ¥ã—ãªã„ã®ã§ã€å°†æ¥ãƒ¦ãƒ¼ã‚¶ãƒ¼åã‚’ç™»éŒ²ã™ã‚‹ã¨ã“ã‚ã§ãƒã‚¤
hamaco 2017/06/22
mysql
ãƒªãƒ³ã‚¯
å¯¿å¸ã¨ãƒ“ãƒ¼ãƒ«ã«ã¤ã„ã¦è©±ã—åˆã„ã‚’ã—ã¦ãã¾ã—ãŸ | GREE Engineering
ã“ã‚“ã«ã¡ã‚ã€‚ã›ã˜ã¾ã§ã™ã€‚ ã•ã„ãã‚“ã® kernel ã«ã¤ã„ã¦èª¿ã¹ã¦ãŸã‚‰ã€ä¿„ã« Chromebook ã¸ã®èˆˆå‘³ãŒæ¹§ã„ã¦ããŸã®ã§ã€é…ã¾ããªãŒã‚‰ C302CA ãƒãƒã£ã¦ã¿ã¾ã—ãŸã€‚ã‚ãŸã—ã«ã¨ã£ã¦äººç”Ÿåˆ Core M ã¨ã„ã†ã“ã¨ã‚‚ã‚ã£ã¦ã€æ—©ãå±Šã‹ãªã„ã‹ãªã¨å¿ƒå¾…ã¡ã«ã—ã¦ã„ã‚‹ä»Šæ—¥ã“ã®ã”ã‚ã§ã™ã€‚ ã¯ã˜ã‚ã« MySQL5.7ä»¥å‰ã§ãŠãã‚‰ãæœ€ã‚‚æœ‰åãªå•é¡Œã®ä¸€ã¤ã«ã€Sushi-Beer issue of MySQL with utf8mb4 ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ å¿™ã—ã„äººã®ãŸã‚ã«ä¸‰è¡Œã§ã¾ã¨ã‚ã¾ã™ã¨ MySQL ã¯ character-set ã« utf8mb4 ã‚’æŒ‡å®šã™ã‚‹ã¨ã€å¯¿å¸ã‚„ãƒ“ãƒ¼ãƒ«ãªã©ã®çµµæ–‡å—ã‚’æ‰±ãˆã‚‹ã€‚ ãŸã ã€Collationï¼ˆç…§åˆé †åºï¼‰ ãŒ utf8mb4_general_ci ã‚„ utf8mb4_unicode_ci ã ã¨ã€çµµæ–‡å—ã‚’åŒºåˆ¥ã§ããªã„ï¼ˆå¯¿å¸ã¨ãƒ“ãƒ¼ãƒ«ã®çµµæ–‡å—ã‚’åŒºåˆ¥ã§ããªã„ï¼‰ã€‚ utf8mb
hamaco 2017/04/21
mysql
ãƒªãƒ³ã‚¯
SQLã‚’ç¹°ã‚Šè¿”ã—å®Ÿè¡Œã—ãŸã‚‰æ®µéšŽçš„ã«å¿œç”é€Ÿåº¦ãŒä¸ŠãŒã£ãŸè©± - ãªã‹ã‚‰ãªLife
MySQL Casual Advent Calendar 2016 - Qiitaã®6æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ AdventCalendarè‡ªä½“åˆå‚åŠ ã§ãƒ‰ã‚ãƒ‰ã‚ã€ã—ã¦ãŸã‚‰ã€æˆã‚Šè¡Œãã§2æ—¥é€£ç¶šã€‚ ã‚³ãƒ¬ç”¨ã®ãã‚Œã„ãªã‚¨ãƒ“ãƒ‡ãƒ³ã‚¹å–ã‚Œã‚‹ã‚ˆã†ãªç’°å¢ƒè¦ã—ã¦ã„ãªã‹ã£ãŸã®ã§ã€æ™®æ®µã‚ˆã‚Šè’ã£ã½ã„ã§ã™ãŒã€Casualãªæ„Ÿã˜ã§å¤±ç¤¼ã—ã¾ã™ã€‚ å¤§ããªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç¹°ã‚Šè¿”ã—SELECTã—ã¦ãŸã‚‰ã€æŒ™å‹•ãŒå¤‰ã‚ã£ãŸã‚“ã§ã™ã‚ˆã€‚ ãƒãƒƒãƒ•ã‚¡ã«è¼‰ã£ã¦ã„ã‚‹ãªã‚‰è¼‰ã£ã¦ã„ã‚‹ã§æ—©ã„ã ã‚ã†ã—ã€è¼‰ã£ã¦ã„ã„ãªã‚‰æœ€åˆã‚¬ãƒƒãƒ„ãƒªé…ãã¦ã€æ¬¡ã‹ã‚‰ã‚°ã‚¤ã£ã¨é€Ÿããªã‚‹ã ã‚ã†ã¨æ€ã£ã¦ã„ãŸã‚“ã§ã™ã‚ˆã€‚ ãƒãƒƒãƒ•ã‚¡ã«è¼‰ã‚Šãã‚‰ãªã„ãªã‚‰ã€ä½•å›žã‚„ã£ã¦ã‚‚é…ã„ã ã‚ã†ã¨æ€ã£ã¦ã„ãŸã‚“ã§ã™ã‚ˆã€‚ ã§ã€ã¡ã‚‡ã„ã¨è¨ˆæ¸¬çš„ãªã“ã¨ã‚’ã‚„ã£ã¦ãŸé–¢ä¿‚ã§ã€åŒã˜SQLã‚’ä½•åº¦ã‹å©ã„ã¦å¹³å‡ã€ä¸å¤®ã‚’è¦‹ã‚ˆã†ã¨æ€ã£ã¦ã„ãŸã‚“ã§ã™ã€‚ ãã—ãŸã‚‰ã€ 45.71ç§’ã€44.90ç§’ã€24.44ç§’ã€13.32ç§’ã€13.12ç§’ãƒ»ãƒ»ãƒ» ã¨ã€æ®µéšŽçš„ã«å¿œç”
hamaco 2016/12/07
mysql
ãƒªãƒ³ã‚¯
MySQLã•ã‚“ã‹ã‚‰Column not foundã£ã¦è¨€ã‚ã‚Œã¦ã„ã‚‹ã‘ã©ã€ãƒã‚°ã‚’è¦‹ã‚‹é™ã‚Šãã®ã‚«ãƒ©ãƒ ã¯SQLã®ã©ã“ã«ã‚‚å‡ºç¾ã—ãªã„
ã©ã…ãƒ¼ã‚ã @do_aki MySQL ã•ã‚“ã‹ã‚‰ Column not found ã£ã¦è¨€ã‚ã‚Œã¦ã„ã‚‹ã‘ã©ã€ãƒã‚°ã‚’è¦‹ã‚‹é™ã‚Šãã®ã‚«ãƒ©ãƒ ã¯ SQL ã®ã©ã“ã«ã‚‚å‡ºç¾ã—ãªã„â€¦â€¦ã€‚ãªã‚“ã ã“ã‚Œ 2016-11-08 16:09:58
hamaco 2016/11/08
mysql
ãƒªãƒ³ã‚¯
MySQL 8.0.0 Development Milestone Releaseç™»å ´ï¼ï¼
å…ˆæœˆã€è©³è§£MySQL 5.7ã‚’ç™ºåˆŠã—ãŸã°ã‹ã‚Šã§ã‚ã‚‹ãŒã€MySQL 5.7è‡ªä½“ã¯åŽ»å¹´ã®10æœˆã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹ã€‚ãã‚Œã‹ã‚‰ç´„1å¹´å¼±ã€MySQLã¯é–‹ç™ºã®æ‰‹ã‚’ç·©ã‚ã‚‹ã“ã¨ç„¡ãæ—¥ã€…æ”¹è‰¯ã‚’é‡ãã¦ã„ã‚‹ã€‚ ãã†ã€MySQL 8.0ã®ç™»å ´ã§ã‚ã‚‹ã€‚ ç¾åœ¨ã¯Development Milestone Releaseï¼ˆé€šç§°DMRï¼‰ã¨ã„ã†çŠ¶æ…‹ãªã®ã§ã€ã¾ã æ£å¼ç‰ˆã«ãŠã‘ã‚‹æ©Ÿèƒ½ãŒå›ºã¾ã£ã¦ã„ã‚‹æ®µéšŽã§ã¯ãªã„ã¨ã„ã†ç‚¹ã«ã¯æ³¨æ„ã—ã¦æ¬²ã—ã„ã€‚MySQLã®é–‹ç™ºãƒ—ãƒã‚»ã‚¹ã§ã¯ã€DMRã‚’ãƒªãƒªãƒ¼ã‚¹ã™ã‚‹ã”ã¨ã«ãã®æ®µéšŽã§æˆç†Ÿã—ãŸæ©Ÿèƒ½ã‚’ãƒžãƒ¼ã‚¸ã™ã‚‹ã€‚DMRã‚’ä½•åº¦ã‹ãƒªãƒªãƒ¼ã‚¹ã—ãŸå¾Œã«ã€ã‚ãƒªã®è‰¯ã„ã¨ã“ã‚ã§ãƒªãƒªãƒ¼ã‚¹å€™è£œç‰ˆã¨ãªã£ã¦æ£å¼ç‰ˆã§è¿½åŠ ã•ã‚Œã‚‹æ©Ÿèƒ½ãŒä¸€å¿œç¢ºå®šã—ã€ãã®å¾Œãƒã‚°ä¿®æ£ã‚’çµŒã¦æ£å¼ç‰ˆï¼ˆGAç‰ˆï¼‰ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã‚‹äºˆå®šã¨ãªã£ã¦ã„ã‚‹ã€‚è©³ã—ãã¯MySQLã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’å‚ç…§ã—ã¦æ¬²ã—ã„ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³8.0!!5.7ã®æ¬¡ã¯èª°ã‚‚ãŒ5.8ã ã¨æ€ã£ã¦ã„ãŸã ã‚ã†ãƒ»
hamaco 2016/09/23
mysql
ãƒªãƒ³ã‚¯
ORDER BYã§ã€å˜ç´”ãªæ˜‡é †é™é †ã€Œä»¥å¤–ã€ã§ä¸¦ã¹ã‚‹ï¼ - ãªã‹ã‚‰ãªLife
ã„ã‚„ãƒ¼ã€çŸ¥ã‚‰ãªã„ã£ã¦æ€–ã„ãã€‚ ãªã‚“ã ã“ã®ã‚ãƒ¢ã„SQLã¯ã€ã£ã¦æ€ã£ã¦ã—ã¾ã£ãŸã‘ã©ã€èª¿ã¹ã¦ã„ã‚‹ã‚¦ãƒã«ã€ã“ã‚Œã¡ã‚ƒã‚“ã¨SQLæ§‹æ–‡ã«å‰‡ã£ã¦ã‚‹ï¼ã“ã¡ã‚‰ãŒé–“é•ã£ã¦ãŸï¼ã£ã¦äº‹ãŒã‚ã‹ã£ã¦ã„ãã¾ã—ãŸã€‚ ã‚ãˆã¦ã€çŸ¥ã‚‰ãªã‹ã£ãŸæ‰€ã‹ã‚‰å‹¢ã„ã§æ›¸ã„ã¦ã„ãŸã®ã‚’ã€ãã®ã¾ã¾ã«ã—ã¦ã¿ã¾ã—ãŸã€‚ ã‚ãƒ¢ã„SQLã‚³ãƒ¼ãƒ‰ã‚’å¶ç„¶è¦‹ã¤ã‘ãŸ SQLã«ãŠã‘ã‚‹ORDER BYã£ã¦ã€ãã®å¾Œã«ã‚«ãƒ©ãƒ ï¼ˆãŠã‚ˆã³ãã®ã‚¨ã‚¤ãƒªã‚¢ã‚¹ï¼‰ã‚’ä¸¦ã¹ã¦ã‚½ãƒ¼ãƒˆé †ã¨ã—ã¦ä½¿ç”¨ã™ã‚‹ã‚ã‘ã§ã™ãŒã€MySQLæ¡ˆä»¶ã®ãŠä»•äº‹ã®ä¸ã§å¶ç„¶ã“ã‚“ãªã‚‚ã®ã‚’è¦‹ã¤ã‘ã¦ã€çµµã«æã„ãŸã‚ˆã†ãªäºŒåº¦è¦‹ãƒªã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã—ã¾ã—ãŸã€‚ SELECT * FROM tbl ORDER BY id = 23; -- (1) SELECT * FROM tbl ORDER BY FIELD( id, 23, 234, 543, 23 ); -- (2)ã“ã†ã—ãŸã€ã€ŒORDER BYã«ã€ã‚ãŸã‹ã‚‚WHEREå¥ã§çµžã‚Šè¾¼ã‚€æ¡ä»¶æŒ‡å®šã®ã‚ˆã†ãªä½¿
hamaco 2016/07/28
mysql
ãƒªãƒ³ã‚¯
ãƒ«ãƒ¼ã‚¯ï¼MySQLã§ã¯kamipo TRADITIONALã‚’ä½¿ãˆï¼ | ãŠãã‚‰ãã¯ãã‚Œã•ãˆã‚‚å¹³å‡¡ãªæ—¥ã€…
ã‚ˆãMySQLã¯ã‚†ã‚‹ãµã‚ã ã‹ã‚‰ å€¤ãŒå‹æ‰‹ã«åˆ‡ã‚Šè©°ã‚ã‚‰ã‚Œã‚‹ ã‚¨ãƒ©ãƒ¼ãŒèµ·ããšã«å¤‰ãªå€¤/æ—¥ä»˜ãŒå…¥ã‚‹ ä¸æ£ãªã‚¹ã‚ãƒ¼ãƒžãŒå…¥ã£ã¦ã—ã¾ã† ãªã©è¨€ã‚ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ãŸã ãã‚Œã¯ã€ãã‚‚ãã‚‚ã®è¨å®šãŒæ‚ªã„ã®ã§ã™ã€‚(ç¢ºã‹ã«æ˜”ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒã‚†ã‚‹ãµã‚ãªã®ã¯ã„ã‘ãªã‹ã£ãŸã‚“ã§ã™ãŒ) ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ä¸æ£ãªå€¤ãŒå…¥ã‚‰ãªã„ã‚ˆã†ã«è¨å®šã¯ã¨ã«ã‹ãåŽ³ã—ãã—ã¦ãŠãã®ãŒã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã€‚ ã˜ã‚ƒã‚ã©ã†ã™ã‚‹ã‹ã€‚ MySQLã¯SQL Modeã«ã‚ˆã£ã¦ã€ãã®è¾ºã‚Šã®åˆ¶ç´„ã‚’ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ä»¥å‰ã€MySQLã®sql-modeã§ä¸€ç•ªåŽ³ã—ã„ã‚„ã¤ã¯TRADITIONALã€ã¨ã„ã†ã®ã‚’æ›¸ã„ãŸã®ã§ã™ãŒã€å®Ÿã¯ãã‚Œã ã‘ã§ã¯ä¸ååˆ†ã§ã€TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BYã¨ã™ã‚‹ã®ãŒã‚ˆã‚Šå®‰å¿ƒãªã‚ˆã†ã§ã™ã€‚ ã“ã‚Œã¯kamipoã•ã‚“ã«æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ @songmu TRADITI
hamaco 2016/03/30
mysql
ãƒªãƒ³ã‚¯
é›‘ãªMySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
PostgreSQLã®è¡Œãƒ¬ãƒ™ãƒ«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ SpringAOPã§ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã® ãƒ¦ãƒ¼ã‚¶ãƒ¼é–“æƒ…å ±æ¼æ´©ã‚’é˜²æ¢ã™ã‚‹ (JJUG CCC 2021 Spring)
hamaco 2016/03/16
mysql
ãƒªãƒ³ã‚¯
MySQLã§Grantæ–‡ã§ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã™ã‚‹ã®ã«é•å’Œæ„Ÿã‚’æ„Ÿã˜ã‚‹ Â· DQNEOæ—¥è¨˜
MySQLã®å…¥é–€è¨˜äº‹ã§ã€ã€ŒGRANTæ–‡ã§ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã—ã¾ã™ã€ã¨ã„ã†èª¬æ˜Žã‚’ã‚ˆãè¦‹ã‹ã‘ã¾ã™ã€‚ ã“ã‚“ãªã‚„ã¤ã€‚ GRANT ALL PRIVILEGES ON *.* TO 'ãƒ¦ãƒ¼ã‚¶ãƒ¼å'@'localhost' IDENTIFIED BY 'ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰'; ç¢ºã‹ã«ã“ã‚Œã§ãƒ¦ãƒ¼ã‚¶ä½œæˆã§ãã¾ã™ãŒã€ãªã‚“ã‹é•å’Œæ„Ÿã‚’æ„Ÿã˜ã‚‹ã‚“ã§ã™ã‚ˆãã€‚ ãã®è‹±æ–‡ã‹ã‚‰ãƒ¦ãƒ¼ã‚¶ãŒä½œæˆã•ã‚Œã‚‹ã‚ˆã†ã«ã¯è¦‹ãˆãªã„ è‹±èªžçš„ã«ãªã‚“ã‹ãŠã‹ã—ã„ã€‚ è‹±èªžã®Grant = ã€Œè¨±å¯ã™ã‚‹ã€ã§ã—ã‚‡ï¼Ÿã€ŒæŒ‡å®šã—ãŸãƒ¦ãƒ¼ã‚¶ã«æ¨©é™ã‚’ä¸Žãˆã‚‹ã€ã¿ãŸã„ãªè‹±æ–‡ãªã®ã«ã€ãƒ¦ãƒ¼ã‚¶ã‚’ä½œã£ã¡ã‚ƒã£ã¦ã‚‹ã€‚ãŠã¾ã‘ã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚‚è¨å®šã—ã¡ã‚ƒã£ã¦ã‚‹ã€‚ MySQLã¯ãƒ¦ãƒ¼ã‚¶ã‚’ä½œã‚‹åˆ¥ã®æ–¹æ³•ã¨ã—ã¦ CREATE USER ã¨ã„ã†ã®ã‚‚ã‚ã‚‹ã€‚GRANTã§ãƒ¦ãƒ¼ã‚¶ä½œã‚Œã‚‹ã¨ã—ãŸã‚‰ã€CREATE USERã¯ä½•ã®ãŸã‚ã«ã‚ã‚‹ã®ï¼Ÿã¨MySQLåˆå¿ƒè€…ã®ç§ã¯æ··ä¹±ã—ã¦ã—ã¾ã†ã‚ã‘ã§ã™ã€‚ ãã“ã§å…¬å¼ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’èªã‚“ã§æ•´ç†ã—ã¦ã¿ã¾ã—
hamaco 2016/01/22
mysql
ãƒªãƒ³ã‚¯
å…‰ã®MySQL 5.7
20170622_MySQLæœ€æ–°æƒ…å ± ï½žMySQL 8.0 é–‹ç™ºçŠ¶æ³ã€MySQL InnoDB Clusterã€ãªã©ã®ã”ç´¹ä»‹ï½ž by æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«æ ªå¼ä¼šç¤¾...
hamaco 2015/09/15
mysql
ãƒªãƒ³ã‚¯
MySQL 5.7ã®ç½ ãŒã‚ãªãŸã‚’ç‹™ã£ã¦ã„ã‚‹
2015/08/22 YAPC::Asia Tokyo 2015 Lightning Talk 2016/01/13 update about default_password_lifetime will be 0
hamaco 2015/08/25
yapcasia2015

mysql
ãƒªãƒ³ã‚¯
MySQL 5.7.4ã§å°Žå…¥ã•ã‚ŒãŸdefault_password_lifetimeãŒã˜ã‚ã˜ã‚ãã‚‹ï¼ˆMySQL 5.7.11ã§FIXï¼ï¼ï¼‰
MySQL 5.7.4ã§å°Žå…¥ã•ã‚ŒãŸdefault_password_lifetimeãŒã˜ã‚ã˜ã‚ãã‚‹ï¼ˆMySQL 5.7.11ã§FIXï¼ï¼ï¼‰ ã€2016/01/13 10:12ã€‘ MySQL 5.7.11ã§default_password_lifetimeã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯0ã«å¤‰æ›´ã«ãªã‚Šã¾ã—ãŸï¼ ãã‚Œä»¥é™ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚Œã°ã“ã®è¨˜äº‹ã®å†…å®¹ã¯æ°—ã«ã™ã‚‹å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ æ—¥ã€…ã®è¦šæ›¸: MySQL 5.7.11ã§default_password_lifetimeã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒ0ã«ãªã‚‹ã‚‰ã—ã„ï¼ TL;DR default_password_lifetime= 0 ã‚’ç§˜ä¼ã®my.cnfã«å…¥ã‚Œã¦ãŠãã¤ã‚‚ã‚Šã€‚ MySQL :: MySQL 5.7 Reference Manual :: 5.1.4 Server System Variables ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã®æ„å‘³ã¯èªã‚“ã§å—ã®ã”ã¨ãã€ã€Œæœ€å¾Œã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒæ›´æ–°ã•
hamaco 2015/06/10
mysql
ãƒªãƒ³ã‚¯
MySQL ã¨å¯¿å¸ãƒ“ãƒ¼ãƒ«å•é¡Œ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
MySQL ã¨ Unicode Collation Algorithm (UCA) - ã‹ã¿ã½ã‚ãƒ¼ã‚‹ ã«é–¢é€£ã™ã‚‹ãƒˆãƒ”ãƒƒã‚¯ã§ã€ MySQL ã«ã¯å¯¿å¸ãƒ“ãƒ¼ãƒ«å•é¡Œã¨ã„ã†ã®ãŒã‚ã‚‹ã€‚ å¯¿å¸ãƒ“ãƒ¼ãƒ«å•é¡Œã©ã£ã‹ã§è©³ã—ããŠè©±ã‚’èžãã¹ãã ã‚ˆãªãã€‚ã€‚ã€‚â€” RKajiyama (@RKajiyama) March 18, 2015 ã“ã‚Œã¯ã©ã†ã„ã†å•é¡Œã‹ã¨ã„ã†ã¨ã€ MySQL ã® Unicode ã§ã¯ binary collation ã«ã—ã¦ã‚³ãƒ¼ãƒ‰ãƒã‚¤ãƒ³ãƒˆã§æ¯”è¼ƒã—ãªã„ã¨ðŸ£ã¨ðŸºã«é™ã‚‰ãšçµµæ–‡å—ãŒåŒå€¤åˆ¤å®šã•ã‚Œã‚‹ã¨ã„ã†å•é¡Œã§ã™ã€‚ ã‚ã‚Œï¼Ÿ MySQL ã® utf8mb4 charset ã£ã¦ã€4ãƒã‚¤ãƒˆæ–‡å—åŒå£«ã‚’æ¯”è¼ƒã™ã‚‹ã¨åŒã˜æ–‡å—æ‰±ã„ã•ã‚Œã‚‹ï¼Ÿ SELECT 'ðŸ£'='ðŸº' â†’ 1 MySQLçš„ã«ã¯å¯¿å¸ã¨ãƒ“ãƒ¼ãƒ«ã¯åŒã˜æ‰±ã„ã€‚â€” ã¨ã¿ãŸã¾ã•ã²ã‚ (@tmtms) December 22, 2014 MySQLã§ select
hamaco 2015/03/23
ðŸ£ðŸº

mysql
ãƒªãƒ³ã‚¯
MySQL 5.7ã§çµ¶å¯¾ã«å¿…è¦ã«ãªã‚‹ã¨æ€ã†log_timestampsã®è¨å®š
æ°—ã¥ã‹ãªã‹ã£ãŸã‘ã©ã€ã“ã‚Œ5.7.2ã‹ã‚‰å…¥ã£ã¦ãŸã®ã‹ã€‚ ãƒ•ãƒ„ãƒ¼ã«æ‰±ã†DATETIMEåž‹(ã‚„ãã®è¦ªæˆš)ã¯ time_zone å¤‰æ•°ã«æ”¯é…ã•ã‚Œã‚‹ã‘ã©ã€ãƒã‚°ã«å‡ºåŠ›ã•ã‚Œã‚‹æ™‚åˆ»ã¯ log_timestamps å¤‰æ•°ã«æ”¯é…ã•ã‚Œã‚‹ã€‚ ã“ã®å¤‰æ•°ã®å–ã‚Šã†ã‚‹å€¤ã¯ UTC ã¾ãŸã¯ SYSTEM ã§ã€æš—é»™ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯UTC ã€‚ã€‚ mysql57> SELECT @@version; +---------------+ | @@version | +---------------+ | 5.7.5-m15-log | +---------------+ 1 row in set (0.00 sec) mysql57> SHOW GLOBAL VARIABLES LIKE '%time_zone'; -- ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ã¯ãƒ•ãƒ„ãƒ¼ã«JST +------------------+--------+ | Variable_
hamaco 2015/03/09
ç½ ã„ã€‚

mysql
ãƒªãƒ³ã‚¯
utf8_unicode_ci ã«å¯¾ã™ã‚‹æ—¥æœ¬ã®é–‹ç™ºè€…ã®è¦‹è§£ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
RailsãŒMySQLã®collationã‚’ã‚µãƒ¼ãƒãƒ¼å´ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®utf8_general_ciã‹ã‚‰utf8_unicode_ciã«ã‚ã–ã‚ã–å¤‰ãˆã¦ã‚‹ã®ã©ã†ã›å¤§ã—ãŸç†ç”±ã˜ã‚ƒãªã„ã ã‚ã¨æ€ã£ã¦æŽ˜ã£ã¦ã¿ãŸã‚‰ã‚„ã£ã±ã‚Šå¤§ã—ãŸç†ç”±ã˜ã‚ƒãªã‹ã£ãŸâ€¦ https://t.co/6NeetGhTF0â€” Ryuta Kamizono (@kamipo) April 18, 2014 Railsã§collationã¨ã—ã¦utf8_unicode_ci(Railsã®DEFAULT_COLLATION)ãŒæŽ¡ç”¨ã•ã‚Œã‚‹ã®ã¯charsetãŒæœªæŒ‡å®šã‚‚ã—ãã¯utf8(Railsã®DEFAULT_CHARSET)ã®ã¨ãã ã‘ã§ã€utf8mb4ã«ã™ã‚‹ã“ã¨ã¨ã‹ã¯å…¨ãè€ƒæ…®ã•ã‚Œã¦ãªã„ã€‚â€” Ryuta Kamizono (@kamipo) April 19, 2014 @frsyuki MySQLã®charset utf8ã®ã¨ãã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ
hamaco 2015/03/09
mysql
ãƒªãƒ³ã‚¯
MySQL 5.7ã§æš—é»™ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒå¤‰ã‚ã‚Šãã†ãªã¯ãªã—
Morgan Tocker ã¨ã„ã†MySQLã®ä¸ã®äºº(MySQL Community Teamã®ã²ã¨)ãŒ è‡ªèº«ã®ãƒ–ãƒã‚° ã§ã€MySQL 5.7ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®å¤‰æ›´ã«é–¢ã™ã‚‹æ„è¦‹ã‚’å‹Ÿé›†ã—ã¦ã„ãŸã‚Šã™ã‚‹ã€‚ Proposed MySQL 5.7 defaults. Please send feedback! http://t.co/Uq6c7STXBE â€” morgo (@morgo) 2015, 1æœˆ 23 Proposal to change Replication and InnoDB Settings in MySQL 5.7 http://t.co/gr3AwwmoEv â€” morgo (@morgo) 2015, 1æœˆ 14 ã®ã§ã€ã¡ã‚‡ã£ã¨è§£èª¬ã—ã¦ã¿ã¾ã™ã€‚ã‚ãŸã—ãŒå‹æ‰‹ã«æ€ã£ã¦ã„ã‚‹ã“ã¨ã‚’è¿°ã¹ã¦ã„ã‚‹ã ã‘ãªã®ã§ã€è©³ã—ãã¯åŽŸæ–‡ã‚’ã‚ãŸã£ã¦ãã ã•ã„ã€‚ ã¾ãšã¯ã“ã£ã¡ã€‚ Proposal to chan
hamaco 2015/01/27
mysql
ãƒªãƒ³ã‚¯
MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚ã‚ŠãŒã¡ãª10ã®å•é¡Œ | Yakst
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å•é¡Œã§ã‚ˆãã‚ã‚‹10ãƒ‘ã‚¿ãƒ¼ãƒ³ã€‚ 1) ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ã¿ã§æœ‰åŠ¹ãªãƒã‚¤ãƒŠãƒªãƒã‚° sql_log_bin = 0ã‚’è¨å®šã™ã‚‹ã¨ã€ãã®ã‚»ãƒƒã‚·ãƒ§ãƒ³å†…ã§ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ç„¡åŠ¹ã«ã§ãã‚‹ã€‚ã¤ã¾ã‚Šã€ãƒžã‚¹ã‚¿ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³å†…ã§å®Ÿè¡Œã—ãŸDMLã‚„DDLã¯ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã¯ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã•ã‚Œãªã„ã€‚ ãƒžã‚¹ã‚¿ã§ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ã‚ªãƒ•ã«ã™ã‚‹ã€‚ mysql> set sql_log_bin = 0 ; Query OK, 0 rows affected (0.00 sec) reptestãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¦ã¿ã‚‹(ãƒžã‚¹ã‚¿ä¸Šã§å®Ÿè¡Œ)ã€‚ mysql> create table reptest(ID int) ; Query OK, 0 rows affected (0.01 sec) mysql> show tables ; +-------------------+ | Tables_in_reptest | +-
hamaco 2015/01/04
mysql
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 æ¬¡ã®ãƒšãƒ¼ã‚¸