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

nilab id:nilab

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

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

Galeraãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã« Primary Key ãŒå¿…è¦ãªç†ç”± | ã‚¹ãƒžãƒ¼ãƒˆã‚¹ã‚¿ã‚¤ãƒ« TECH BLOG
ã¯ã˜ã‚ã« Galera Clusterï¼ˆãŠã‚ˆã³ãã®ãƒ–ãƒ©ãƒ³ãƒï¼‰ã«ã¯ã€ã€Œå…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã«Primary KeyãŒè¨å®šã•ã‚Œã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚‹ã€ã¨ã„ã†åˆ¶ç´„äº‹é …ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯ä»¥ä¸‹ã®ã‚ˆã†ã«å…¬å¼ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã§ã‚‚æ˜Žè¨€ã•ã‚Œã¦ã„ã¾ã™ã€‚ DIFFERENCES FROM A STANDALONE MYSQL SERVER Do not use tables without a primary key. MariaDB Galera Cluster â€“ Known Limitations All tables should have a primary key (multi-column primary keys are supported). ç‰¹ã« Percona XtraDB Clusterï¼ˆä»¥ä¸‹ã€PXCï¼‰ã®å ´åˆã€PXC5.7ã§ã€ŒPXC Strict Modeã€ã¨ã„ã†æ©Ÿèƒ½ã‚’å®Ÿè£…ã—ã€PKãŒãªã„ãƒ†ãƒ¼ãƒ–ãƒ«ãŒ
nilab 2018/10/12
ã€ŒPercona XtraDB Clusterã€ã€ŒPXC Strict Modeã€ã€ã€ŒMySQLã§ã‚‚ã€ŒROW-based replication ã§ã¯ã€PKã®è¨å®šãŒæŽ¨å¥¨ã€ã€Œãƒ¬ã‚³ãƒ¼ãƒ‰ã®é †ç•ªãŒã€å„ãƒŽãƒ¼ãƒ‰é–“ã§ç•°ãªã£ã¦ã—ã¾ã†ã€ã€Œä¸è¦ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ãŒå®Ÿè¡Œã•ã‚Œã€å¤§å¹…ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é…å»¶ã€

mysql
ãƒªãƒ³ã‚¯
utf8_general_ciã¨utf8_unicode_ci - æŠ€è¡“ãƒ¡ãƒ¢å¸³
æŠ€è¡“ãƒ¡ãƒ¢å¸³ é–‹ç™ºã™ã‚‹ã†ãˆã§èª¿ã¹ãŸã“ã¨ã€çŸ¥ã£ãŸã“ã¨ã‚’å‚™å¿˜éŒ²ã¨ã—ã¦ãƒ¡ãƒ¢ãƒ¡ãƒ¢ï¼ ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ãƒšãƒ¼ã‚¸ä¸€è¦§ãƒ¡ãƒ³ãƒãƒ¼æŽ²ç¤ºæ¿ç·¨é›† Ã— utf8_general_ciã¨utf8_unicode_ci æœ€çµ‚æ›´æ–°ï¼š clever_nextÂ 2012å¹´07æœˆ27æ—¥(é‡‘) 13:50:19å±¥æ´ Tweet utf8_general_ciã¨utf8_unicode_ci utf8_general_ciã¨utf8_unicode_ciã®é•ã„ã¯ä¸»ã«ä»¥ä¸‹ã€‚ utf8_general_ci è‹±å—ã®å¤§æ–‡å—å°æ–‡å—ã¯åŒºåˆ¥ã—ãªã„ã€‚ å…¨è§’åŠè§’ã¯åŒºåˆ¥ã™ã‚‹ã€‚ utf8_unicode_ci è‹±å—ã®å¤§æ–‡å—å°æ–‡å—ã¯åŒºåˆ¥ã—ãªã„ã€‚ å…¨è§’åŠè§’ã‚‚åŒºåˆ¥ã—ãªã„ã€‚ ã•ã‚‰ã«æ¿éŸ³ã€åŠæ¿éŸ³ã€ã²ã‚‰ãŒãªã€ã‚«ã‚¿ã‚«ãƒŠã‚‚åŒºåˆ¥ã—ãªã„ã€‚ ã€Œã¯ã€ã§æ¤œç´¢ã™ã‚‹ã¨ã€Œã¯ã€ã€Œã°ã€ã€Œã±ã€ã€Œãƒã€ã€Œãƒã€ã€Œãƒ‘ã€ã€Œï¾Šã€ãŒãƒ’ãƒƒãƒˆã™ã‚‹ã€‚ ã¡ãªã¿ã«å…¨ã¦ã‚’åŒºåˆ¥ã—ãŸã„å ´åˆã¯utf8_binã‚’ä½¿ç”¨ã™ã‚Œã°ã‚ˆã„
nilab 2018/02/13
utf8_general_ciã€Œè‹±å—ã®å¤§æ–‡å—å°æ–‡å—ã¯åŒºåˆ¥ã—ãªã„ã€‚å…¨è§’åŠè§’ã¯åŒºåˆ¥ã™ã‚‹ã€ / utf8_unicode_ci ã€Œè‹±å—ã®å¤§æ–‡å—å°æ–‡å—ã¯åŒºåˆ¥ã—ãªã„ã€‚å…¨è§’åŠè§’ã‚‚åŒºåˆ¥ã—ãªã„ã€‚ã•ã‚‰ã«æ¿éŸ³ã€åŠæ¿éŸ³ã€ã²ã‚‰ãŒãªã€ã‚«ã‚¿ã‚«ãƒŠã‚‚åŒºåˆ¥ã—ãªã„ã€

mysql
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQL/MariaDBã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒãƒƒã‚¯ã®é–¢ä¿‚ï¼‹ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã«ã¤ã„ã¦ - interdbâ€™s diary
ã‚ˆã„æ©Ÿä¼šãªã®ã§ã¾ã¨ã‚ã¦ãŠãã€‚å¯¾è±¡ã¯MySQL5.6ä»¥ä¸‹ã¨MariaDB10.0ä»¥ä¸‹ã€‚ (2014.12.3è¿½è¨˜ï¼šä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚è¨˜è¿°ã—ãŸã€‚) è¦æ—¨ MySQL/MariaDBã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã«ã¤ã„ã¦ã€ç›¸å¤‰ã‚ã‚‰ãšã€ŒInnoDBã•ãˆä½¿ã£ã¦ã„ã‚Œã°ã€FLUSH TABLES WITH READ LOCKã¯ä¸è¦ã€‚ã‚ˆã£ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ä¸ã«æ›´æ–°ä¸å¯ã«ãªã‚‹ã“ã¨ã¯ãªã„ï¼ã€ã¨ã®ä¸»å¼µãŒç¹°ã‚Šè¿”ã•ã‚Œã¦ã„ã‚‹ãŒã€å°‘ãªãã¨ã‚‚5.6/10.0ã¾ã§ã¯ãã‚“ãªã“ã¨ã¯ãªã„ã€‚ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã«é–¢ã™ã‚‹ãƒãƒƒã‚¯ã®æ£ç¢ºãªè¨˜è¿° ã‚ˆã‚Šæ£ç¢ºã«è¨€ãˆã°ã€Œå…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é ˜åŸŸã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹å ´åˆã«ã¯ã€FLUSH TABLES WITH READ LOCKã¯å¿…é ˆã€‚ç‰¹å®šã®InnoDBã ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹éš›ã¯ã€ã“ã®é™ã‚Šã§ã¯ãªã„ã€ã€‚ ãªã®ã ãŒã€å…¨é ˜åŸŸã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã—ãŸã„äººã«å¯¾ã—ã¦ãƒãƒƒã‚¯ä¸è¦èª¬ã‚’å¹ãè¾¼ã‚€äººãŒæœªã ã«ã„ã‚‹ã€‚ ãƒãƒƒã‚¯ã®å¿…è¦
nilab 2018/02/07
ã€Œå…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é ˜åŸŸã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹å ´åˆã«ã¯ã€FLUSH TABLES WITH READ LOCKã¯å¿…é ˆã€‚ç‰¹å®šã®InnoDBã ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹éš›ã¯ã€ã“ã®é™ã‚Šã§ã¯ãªã„ã€

mysql
ãƒªãƒ³ã‚¯
PHPerã«çŸ¥ã£ã¦ã»ã—ã„RDBãªäº‹
PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2016ï¼ åŒ—æµ·é“ã®è³‡æ–™ã§ã™ http://phpcon.sapporo-php.net/2016/
nilab 2016/04/17
PHPerã«çŸ¥ã£ã¦ã»ã—ã„RDBãªäº‹ // Speaker Deck

dbms

mysql
ãƒªãƒ³ã‚¯
1æ—¥ã«100ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰å¢—ãˆã‚‹å ´åˆã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆ
MySQLï¼ˆãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ï¼‰ã¯ã€TCX DataKonsultABç¤¾ãªã©ãŒé–‹ç™ºã™ã‚‹RDBMSï¼ˆãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ )ã§ã™ã€‚ä¸–ç•Œã§æœ€ã‚‚äººæ°—ã®é«˜ã„ã‚·ã‚¹ãƒ†ãƒ ã§ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã¯ã€é«˜é€Ÿæ€§ã¨ä¿¡é ¼æ€§ãŒã‚ã‚Šã€Linuxã€UNIXã€Windowsãªã©ã®è¤‡æ•°ã®ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§å‹•ä½œã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ PHPã¯ã€Webã‚µã‚¤ãƒˆæ§‹ç¯‰ã«ç‰¹åŒ–ã—ã¦é–‹ç™ºã•ã‚ŒãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã™ã€‚å¤§ããªç‰¹å¾´ã®ã²ã¨ã¤ã¯ã€HTMLã«ç›´æŽ¥ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’åŸ‹ã‚è¾¼ã‚€ã“ã¨ãŒã§ãã‚‹ã¨ã„ã†ç‚¹ã§ã™ã€‚PHPã‚’ç”¨ã„ã‚‹ã“ã¨ã§ã€HTMLã‚’å‹•çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¨ã—ã¦å‡ºåŠ›ã§ãã¾ã™ã€‚HTMLãŒãã®ã¾ã¾ãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ã®ã«å¯¾ã—ã€PHPãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã‚µãƒ¼ãƒå´ã§å®Ÿè¡Œã•ã‚ŒãŸçµæžœãŒãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ãŸã‚ã€PHPã‚¹ã‚¯ãƒªãƒ—ãƒˆã¯ã€Œã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚¹ã‚¯ãƒªãƒ—ãƒˆã€ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚
nilab 2015/11/05
1æ—¥ã«100ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰å¢—ãˆã‚‹å ´åˆã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆ(18942)ï½œteratail

mysql
ãƒªãƒ³ã‚¯
MySQLã®å…¨æ–‡æ¤œç´¢ã«é–¢ã™ã‚‹ã‚ã‚Œã‚„ã“ã‚Œã‚„
é€Ÿç¿’ï¼è«–ç†ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ï½žåŸºç¤Žã‹ã‚‰æœ€æ–°å‹•å‘ã¾ã§ï½žï¼ˆPostgreSQL Conference Japan 2022 ç™ºè¡¨è³‡æ–™ï¼‰
nilab 2015/10/13
MySQLã®å…¨æ–‡æ¤œç´¢ã«é–¢ã™ã‚‹ã‚ã‚Œã‚„ã“ã‚Œã‚„

mysql

full_text_search
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/mysql/post/innodb-%E5%85%A8%E6%96%87%E6%A4%9C%E7%B4%A2-n-gram-parser/
nilab 2015/10/13
InnoDB å…¨æ–‡æ¤œç´¢ : N-gram Parser | MySQL Server Blog

full_text_search

mysql
ãƒªãƒ³ã‚¯
MySQL 5.7.6ã®InnoDBæ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ ngram
æ—¥ã€…ã®è¦šæ›¸: ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ "MySQL 5.7.6ã®InnoDBæ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ MeCab Plugin"Â ã«å¼•ãç¶šãã€ä»Šåº¦ã¯ngramãªãƒˆãƒ¼ã‚¯ãƒŠã‚¤ã‚¶ãƒ¼ã€‚ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯ ã“ã“ ã€‚ MeCab Pluginã¨é•ã£ã¦ç‰¹ã«INSTALL PLUGINã¨ã‹ã›ãšã«å³ä½¿ãˆã‚‹ã€‚ mysql> ALTER TABLE articles ADD FULLTEXT KEY (title, content) WITH PARSER ngram; Query OK, 0 rows affected (6 hours 25 min 20.67 sec) Records: 0 Duplicates: 0 Warnings: 0 ( Ð´ ) ï¾Ÿ ï¾Ÿ 6æ™‚é–“åŠï¼ï¼Ÿ ã—ã‚‡ã†ãŒãªã„ã¨ã¯ã„ãˆã€MeCabã®ã¨ãã¯1æ™‚é–“åŠã§ãŠé‡£ã‚ŠãŒæ¥ã¦ãŸã®ã«ã¨æ€ã†ã¨ã¡ã‚‡ã£ã¨ã—ã‚‡ã‚“ã¼ã‚Šã€‚ æ™‚é–“ã‚‚ã•ã‚‹ã“ã¨ãªãŒã‚‰ã€ã“ã®ã‚„ã‚Šæ–¹(ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ã¦ã‹ã‚‰
nilab 2015/10/13
æ—¥ã€…ã®è¦šæ›¸: MySQL 5.7.6ã®InnoDBæ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ ngram

full_text_search

mysql
ãƒªãƒ³ã‚¯
MySQLã§æ›¸ã„ã¦ã‚ã‚‹DBã‚’Node.jsã‹ã‚‰åˆ©ç”¨ã™ã‚‹ - Qiita
var mysql = require('mysql'); var connection = mysql.createConnection({ host : 'localhost', //æŽ¥ç¶šå…ˆãƒ›ã‚¹ãƒˆ user : 'hoge', //ãƒ¦ãƒ¼ã‚¶ãƒ¼å password : 'piyopiyo', //ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ database : 'piyo_db' //DBå }); //SQLæ–‡ã‚’æ›¸ã var sql = 'SELECT * FROM piyotable WHERE UserNO = ?;'; //ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã«å·®ã—è¾¼ã‚€ãƒ‡ãƒ¼ã‚¿ var userId = '012345678'; //æŽ¥ç¶šã—ã¾ã™ connection.connect(); //ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ãƒ¼ä½¿ã£ã¦SQLç™ºè¡Œ var query = connection.query(sql, [userId]); //ã‚ã¨ã¯ã‚¤ãƒ™ãƒ³ãƒˆç™ºç”Ÿ
nilab 2015/04/16
MySQLã§æ›¸ã„ã¦ã‚ã‚‹DBã‚’Node.jsã‹ã‚‰åˆ©ç”¨ã™ã‚‹ - Qiita

node.js

mysql
ãƒªãƒ³ã‚¯
Express 4 ã§ MySQL ã«æŽ¥ç¶š - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
nilab 2015/04/16
Node.js - Express 4 ã§ MySQL ã«æŽ¥ç¶š - Qiita

node.js

mysql
ãƒªãƒ³ã‚¯
mysql
mysql Table of Contents Install Introduction Contributors Sponsors Community Establishing connections Connection options SSL options Connection flags Terminating connections Pooling connections Pool options Pool events acquire connection enqueue release Closing all the connections in a pool PoolCluster PoolCluster options Switching users and altering connection state Server disconnects Performing
nilab 2015/04/16
$ npm install mysql : require('mysql') : createConnection : connect : query : end

node.js

mysql
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é‹ç”¨ã«ã¤ã„ã¦è‰²ã€…
ã€BS13ã€‘ãƒãƒ¼ãƒ é–‹ç™ºãŒã“ã‚“ãªã«ã‚‚å¿«é©ã«ï¼ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚‚ãƒ‡ãƒãƒƒã‚°ã‚‚ GitHub ä¸Šã§ã€‚ GitHub Codespaces ã§å¶ãˆã‚‰ã‚Œã‚‹ã‚·ãƒ¼ãƒ ãƒ¬ã‚¹ãªé–‹ç™º
nilab 2015/03/01
MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é‹ç”¨ã«ã¤ã„ã¦è‰²ã€…

mysql

backup
ãƒªãƒ³ã‚¯
[ãƒ…] MySQL + Java ã§ UTF-8 ã®4ãƒã‚¤ãƒˆæ–‡å—ã«å¯¾å¿œ (utf8mb4) (2015-02-28)
nilab 2015/02/28
_[ãƒ…] MySQL + Java ã§ UTF-8 ã®4ãƒã‚¤ãƒˆæ–‡å—ã«å¯¾å¿œ (utf8mb4) (2015-02-28)

mysql

java

unicode
ãƒªãƒ³ã‚¯
Rails4 ã§ MySQL ã® utf8mb4 ã‚’æ‰±ã† - xyk blog
ç’°å¢ƒï¼š MySQL Server version: 5.6.19 Rails 4.1.5 iPhone ã®çµµæ–‡å—ã‚’ MySQL ã«ç™»éŒ²ã—ã‚ˆã†ã¨ã—ãŸã‚‰Mysql2::Error: Incorrect string value:...ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸã€‚3ãƒã‚¤ãƒˆã«åŽã¾ã‚‰ãªã„4ãƒã‚¤ãƒˆUTF-8ã‚’æ‰±ã†ã«ã¯ MySQL 5.5.3 ä»¥ä¸Šã§ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã‚’utf8mb4ã«ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ database.yml ã® encoding ã‚’ utf8 ã‹ã‚‰ utf8mb4 ã«å¤‰æ›´ã—ãŸã€‚ config/database.yml ä¿®æ£å‰ï¼š default: &default adapter: mysql2 encoding: utf8 pool: 5 username: root password: socket: /tmp/mysql.sock development: <<: *default dat
nilab 2015/02/27
Rails4 ã§ MySQL ã® utf8mb4 ã‚’æ‰±ã† - xykã®ãƒ–ãƒã‚°

mysql

unicode
ãƒªãƒ³ã‚¯
MySQL :: Download Connector/J
MySQL Connector/J is the official JDBC driver for MySQL. MySQL Connector/J 8.0 and higher is compatible with all MySQL versions starting with MySQL 5.7. Additionally, MySQL Connector/J 8.0 and higher supports the new X DevAPI for development with MySQL Server 8.0 and beyond. Online Documentation: MySQL Connector/J Installation Instructions Documentation MySQL Connector/J X DevAPI Reference Change
nilab 2015/02/27
MySQL :: Download Connector/J : "MySQL Connector/J is the official JDBC driver for MySQL."

mysql

java

lib
ãƒªãƒ³ã‚¯
UTF-8 ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã•ã‚ŒãŸçµµæ–‡å—ã‚’ MySQL / JDBC ã§å–ã‚Šæ‰±ã†ã«ã¯ï¼Ÿ
2013.06.08 è¿½è¨˜ï¼šJDBC æŽ¥ç¶šæ–‡å—åˆ—ã§ characterEncoding / connectionCollation ã‚’æŒ‡å®šã™ã‚‹ã¨æ€ã£ãŸé€šã‚Šã®æŒ™å‹•ã‚’ã—ã¦ãã‚Œãªã„ã‚ˆã†ãªã®ã§ã€åˆ¥ã®æ–¹æ³• (å¤šåˆ†ã“ã‚ŒãŒæ£ã—ã„æ–¹æ³•) ã‚’è¨˜è¼‰ã—ã¾ã—ãŸã€‚ Unicode ã«ãŠã‘ã‚‹ã€ã“ã‚“ãª æ„Ÿã˜ã®çµµæ–‡å—ã€ã„ã‚ã‚†ã‚‹ Unicode ã® è¿½åŠ é¢ ã®æ–‡å—ã€Java ã§è¨€ãˆã°ã‚µãƒã‚²ãƒ¼ãƒˆãƒšã‚¢ã§ã®è¡¨ç¾ãŒå¿…è¦ã¨ãªã‚‹æ–‡å—ã‚’ã€JDBC çµŒç”±ã§ UTF-8 ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã—ã¦ MySQL ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»ã‚«ãƒ©ãƒ ã«æ ¼ç´ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã€ä»¥ä¸‹ã®ä¾‹å¤–ãŒç™ºç”Ÿã™ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x81 h...' for column 'col_name' at row 1 at com.mysql.jdbc.S
nilab 2015/02/27
blog.k11i.biz: UTF-8 ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã•ã‚ŒãŸçµµæ–‡å—ã‚’ MySQL / JDBC ã§å–ã‚Šæ‰±ã†ã«ã¯ï¼Ÿ

java

mysql

unicode
ãƒªãƒ³ã‚¯
ç¬¬6å›žã€€[å®ŸéŒ²] MySQLå‘ã‘å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒTritonnã€ã‹ã‚‰ã€Œmroongaã€ã¸ã®ç§»è¡Œã‚¬ã‚¤ãƒ‰ï¼ˆ1ï¼‰ | gihyo.jp
mroongaã®N-gramã«ã¤ã„ã¦ã¯ã€bigramã ã‘ã§ãªãã€uni-gramã‚„tri-gramã®ä»–ã€å¤šæ•°ã®æ´¾ç”ŸN-gramã§ã®ãƒˆãƒ¼ã‚¯ãƒŠã‚¤ã‚¶ã«å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚ã•ã‚‰ã«2013å¹´5æœˆæœ«ãƒªãƒªãƒ¼ã‚¹ã®mysql-mroonga-3.04ã«ã¦ã€å¾…æœ›ã®Wãƒ—ãƒ©ã‚°ãƒžã«å¯¾å¿œã—ã¾ã—ãŸã€‚ã“ã‚Œã«ã‚ˆã‚Šã€Tritonnã‹ã‚‰mroongaã¸ç§»è¡Œã™ã‚‹éš›ã®éšœå£ã¯Eãƒ—ãƒ©ã‚°ãƒžã®ã¿ã«ãªã£ãŸã¨è¨€ãˆã¾ã™ã€‚ Tritonnã‹ã‚‰ä¹—ã‚Šæ›ãˆã‚‹ãªã‚‰ã°ã€mroongaã®1æŠžã§ã™ãã€‚ Tritonnã‹ã‚‰mroongaã¸ç§»è¡Œã™ã‚‹7ã¤ã®ãƒ¡ãƒªãƒƒãƒˆ ãã‚Œã§ã¯æ—©é€Ÿã€Tritonnã‹ã‚‰mroongaãƒ˜ç§»è¡Œã™ã‚‹ãƒ¡ãƒªãƒƒãƒˆã‚’è¦‹ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ MySQL 5.6å¯¾å¿œã§ã‚ã‚‹ã“ã¨ ã‚‚ã¯ã‚„ãƒ¬ã‚¬ã‚·ãƒ¼ã¨ãªã£ãŸMySQL 5.0ã¨ã„ã†ç¸›ã‚ŠãŒãªããªã‚‹ã“ã¨ã§ã€MySQL 5.1ä»¥é™ã®å…ˆé€²çš„ãªæ©Ÿèƒ½ã‚’å–ã‚Šå…¥ã‚Œã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ç‰¹ã«MySQL 5.6ã§ã¯ãã®é€²åŒ–ãŒç”šã ã—ãã€æ¬¡ã®ç‚¹ã‚’å§‹ã‚ã¨
nilab 2014/10/06
ç¬¬6å›žã€€[å®ŸéŒ²] MySQLå‘ã‘å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒTritonnã€ã‹ã‚‰ã€Œmroongaã€ã¸ã®ç§»è¡Œã‚¬ã‚¤ãƒ‰ï¼ˆ1ï¼‰ï¼šéš”é€±é€£è¼‰groongaï½œgihyo.jp â€¦ æŠ€è¡“è©•è«–ç¤¾ : ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’MyISAMã‹ã‚‰InnoDBã¸åˆ‡ã‚Šæ›¿ãˆã‚‹éš›ã®æ³¨æ„

mysql
ãƒªãƒ³ã‚¯
MySQLã§MyISAMã‹ã‚‰InnoDBã«ä¹—ã‚Šæ›ãˆã‚‹éš›ã«çŸ¥ã‚‰ãªã„ã¨ãƒãƒžã‚‹ã€æ€–ã„è©± - Y-Ken Studio
photo by byte MySQLã¨ã„ãˆã°ã€å··ã§ã¯InnoDBã°ã‹ã‚Šæ³¨ç›®ã•ã‚Œã€MyISAMã®åœ°ä¸‹ã‚¢ã‚¤ãƒ‰ãƒ«åŒ–ãŒã«ã‚ã‹ã«èªžã‚‰ã‚Œã‚‹ä»Šæ—¥ã“ã®é ƒã€çš†æ§˜ã„ã‹ãŒãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ã€‚ ã¾ã‚ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’å¤‰æ›ã™ã‚‹ã ã‘ã§æ¸ˆã‚€ãªã‚‰ã€ç°¡å˜ãªã®ã§ã™ã€‚ -- legacy_my_tableã‚’InnoDBã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«å¤‰æ›ã™ã‚‹ ALTER TABLE legacy_my_table ENGINE=InnoDB; ã‚ˆã—çµ‚ã‚ã£ãŸï¼ã•ã‚ãƒ©ãƒ³ãƒã‚¿ã‚¤ãƒ ã ï¼ ãƒ»ãƒ»ãƒ»ã¨ç‰‡ä»˜ã‘ã¦ã—ã¦ã—ã¾ã†ã¨ã€æ‚²åŠ‡ãŒèµ·ã“ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚(>o<;) ãã‚Œã§ã¯æœ¬æ—¥ã€MyISAMã‹ã‚‰InnoDBã¸ç§»è¡Œã™ã‚‹ãªã‚‰çŸ¥ã£ã¦ãŠããŸã„æ„å¤–ãªè½ã¨ã—ç©´ã¨Tipsã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ AUTO INCREMENTã®æŒ™å‹•ãŒé•ã†è½ã¨ã—ç©´ ä»¥ä¸‹ã«è©²å½“ã™ã‚‹ã‚¯ã‚¨ãƒªã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹å ´åˆã«ã¯ã€æ³¨æ„ãŒå¿…è¦ã§ã™ã€‚ç§ã¯ãƒãƒžã‚Šã¾ã—ãŸã€‚ INSERT IGNORE INTO
nilab 2014/10/06
MySQLã§MyISAMã‹ã‚‰InnoDBã«ä¹—ã‚Šæ›ãˆã‚‹éš›ã«çŸ¥ã‚‰ãªã„ã¨ãƒãƒžã‚‹ã€æ€–ã„è©± - Y-Ken Studio : AUTO INCREMENTã®æŒ™å‹•ãŒé•ã† : key_buffer_size ã¨ innodb_buffer_pool_size ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

mysql
ãƒªãƒ³ã‚¯
å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³Mroonga_ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‹‰å¼·ä¼š20140418
Embulk, an open-source plugin-based parallel bulk data loader
nilab 2014/10/06
å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³Mroonga_ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‹‰å¼·ä¼š20140418

mysql
ãƒªãƒ³ã‚¯
Mroongaã®ãƒ©ãƒƒãƒ‘ãƒ¼ãƒ¢ãƒ¼ãƒ‰ã§InnoDBã‚’ä½¿ã†è½ã¨ã—ç©´
Mroonga(ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ¢ãƒ¼ãƒ‰)ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³éžå¯¾å¿œã ã‹ã‚‰ã€ãƒ©ãƒƒãƒ‘ãƒ¼ãƒ¢ãƒ¼ãƒ‰ã§InnoDBã«ã—ã¦ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³â€¦ã¨ã‹è€ƒãˆã¦ã„ã‚‹ã¨ãƒãƒžã‚‹(ã‹ã‚‚ã—ã‚Œãªã„)è½ã¨ã—ç©´ã€‚ Mroongaã®ãƒ©ãƒƒãƒ‘ãƒ¼ãƒ¢ãƒ¼ãƒ‰ã¯ã€Œãƒ‡ãƒ¼ã‚¿ã¯ä»»æ„ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã€ã€Œè»¢ç½®ç´¢å¼•ã¯Groongaä¸Šã«ã€ä½œã‚‹ãƒ¢ãƒ¼ãƒ‰ã§ã‚ã£ã¦ã€é£½ãã¾ã§Groongaä¸Šã§ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯åˆ©ãã¾ã›ã‚“ã€‚ã¤ã¾ã‚Šã€ã“ã†ã„ã†ã“ã¨ãŒèµ·ã“ã‚‹ã€‚ mysql56> CREATE TABLE t1 (num int, val varchar(32), primary key(num), fulltext key(val)) Engine= Mroonga COMMENT= 'engine "innodb"'; Query OK, 0 rows affected (0.09 sec) mysql56> INSERT INTO t1 VALUES (1, 'yoku
nilab 2014/10/06
æ—¥ã€…ã®è¦šæ›¸: Mroongaã®ãƒ©ãƒƒãƒ‘ãƒ¼ãƒ¢ãƒ¼ãƒ‰ã§InnoDBã‚’ä½¿ã†è½ã¨ã—ç©´ : ã€ŒMroongaã®ãƒ©ãƒƒãƒ‘ãƒ¼ãƒ¢ãƒ¼ãƒ‰ã¯ã€Œãƒ‡ãƒ¼ã‚¿ã¯ä»»æ„ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã€ã€Œè»¢ç½®ç´¢å¼•ã¯Groongaä¸Šã«ã€ä½œã‚‹ãƒ¢ãƒ¼ãƒ‰ã€

mysql
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 10 æ¬¡ã®ãƒšãƒ¼ã‚¸