Yasuhiro Horimoto 2018-12-26 22:49:51 +0900 (Wed, 26 Dec 2018) Revision: 1aacca88be729884c8d77d2e05746dccdc2c4ab6 https://github.com/mroonga/mroonga.github.com/commit/1aacca88be729884c8d77d2e05746dccdc2c4ab6 Message: blog: fix a wrong example Modified files: en/_posts/2017-10-29-mroonga-7.08.md ja/_posts/2017-10-29-mroonga-7.08.md Modified: en/_posts/2017-10-29-mroonga-7.08.md (+2 -1) =================================================================== --- en/_posts/2017-10-29-mroonga-7.08.md 2018-12-18 11:21:34 +0900 (86453a3) +++ en/_posts/2017-10-29-mroonga-7.08.md 2018-12-26 22:49:51 +0900 (837da17) @@ -41,7 +41,8 @@ Here is how to specify `KEY_LARGE`. id INT PRIMARY KEY AUTO_INCREMENT, content VARCHAR(255), FULLTEXT INDEX (content) - ) ENGINE = Mroonga COMMENT = 'engine "InnoDB"' DEFAULT CHARSET utf8 flags "TABLE_HASH_KEY|KEY_LARGE"; + ) ENGINE = Mroonga COMMENT = 'engine "InnoDB", flags "TABLE_HASH_KEY|KEY_LARGE"' + DEFAULT CHARSET=utf8; ``` In addition, you can specify `TABLE_HASH_KEY`, `TABLE_PAT_KEY`, and `TABLE_DAT_KEY` table options. Modified: ja/_posts/2017-10-29-mroonga-7.08.md (+8 -5) =================================================================== --- ja/_posts/2017-10-29-mroonga-7.08.md 2018-12-18 11:21:34 +0900 (834ef86) +++ ja/_posts/2017-10-29-mroonga-7.08.md 2018-12-26 22:49:51 +0900 (3483001) @@ -26,11 +26,14 @@ description: Mroonga 7.08をリリースしました! `KEY_LARGE` の指定方法は以下の通りです。 - CREATE TABLE diaries ( - id INT PRIMARY KEY AUTO_INCREMENT, - content VARCHAR(255), - FULLTEXT INDEX (content) - ) ENGINE = Mroonga COMMENT = 'engine "InnoDB"' DEFAULT CHARSET utf8 flags "TABLE_HASH_KEY|KEY_LARGE"; +```sql + CREATE TABLE diaries ( + id INT PRIMARY KEY AUTO_INCREMENT, + content VARCHAR(255), + FULLTEXT INDEX (content) + ) ENGINE = Mroonga COMMENT = 'engine "InnoDB", flags "TABLE_HASH_KEY|KEY_LARGE"' + DEFAULT CHARSET=utf8; +``` `flags` に指定できる各フラグの詳細は[Groonga v7.0.8ドキュメント - 7.3.59.4.2.1.flags](http://groonga.org/ja/docs/reference/commands/table_create.html#flags)を確認してください。 -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://lists.osdn.me/mailman/archives/groonga-mysql-commit/attachments/20181226/213011bc/attachment.html>