HAYASHI Kentaro
null+****@clear*****
Fri Dec 21 12:01:12 JST 2012
HAYASHI Kentaro 2012-12-21 12:01:12 +0900 (Fri, 21 Dec 2012) New Revision: d8c4d033e642ec89c4749431dc83f67e28d6879b https://github.com/mroonga/mroonga/commit/d8c4d033e642ec89c4749431dc83f67e28d6879b Log: doc: remove duplicated description Modified files: doc/source/userguide/mroonga_snippet_syntax.inc Modified: doc/source/userguide/mroonga_snippet_syntax.inc (+0 -38) =================================================================== --- doc/source/userguide/mroonga_snippet_syntax.inc 2012-12-21 11:56:36 +0900 (c274df5) +++ doc/source/userguide/mroonga_snippet_syntax.inc 2012-12-21 12:01:12 +0900 (00137d7) @@ -72,41 +72,3 @@ Assume that some keyword such as 'MySQL' and 'search' are associated with 'fullt Here is the schema definition for execution examples:: -.. include:: mroonga_snippet_storage.inc - - CREATE TABLE `snippet_test` ( - `id` int(11) NOT NULL, - `text` text, - PRIMARY KEY (`id`), - FULLTEXT KEY `text` (`text`) - ) ENGINE=mroonga DEFAULT CHARSET=utf8 - -Here is the sample data for execution examples:: - - insert into snippet_test (id, text) values (1, 'An open-source fulltext search engine and column store.'); - insert into snippet_test (id, text) values (2, 'An open-source storage engine for fast fulltext search with MySQL.'); - insert into snippet_test (id, text) values (3, 'Tritonn is a patched version of MySQL that supports better fulltext search function with Senna.'); - -Here is the results of execution examples:: - - mysql> select * from snippet_test; - +----+-------------------------------------------------------------------------------------------------+ - | id | text | - +----+-------------------------------------------------------------------------------------------------+ - | 1 | An open-source fulltext search engine and column store. | - | 2 | An open-source storage engine for fast fulltext search with MySQL. | - | 3 | Tritonn is a patched version of MySQL that supports better fulltext search function with Senna. | - +----+-------------------------------------------------------------------------------------------------+ - 3 rows in set (0.00 sec) - - mysql> select id, text, mroonga_snippet(text, 8, 2, 'ascii_general_ci', 1, 1, '...', '...<br>', 'fulltext', '<span class="w1">', '</span>', 'MySQL', '<span class="w2">', '</span>', 'search', '<span calss="w3">', '</span>') from snippet_test where match(text) against ('fulltext'); - +----+-------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ - | id | text | mroonga_snippet(text, 8, 2, 'ascii_general_ci', 1, 1, '...', '...<br>', 'fulltext', '<span class="w1">', '</span>', 'MySQL', '<span class="w2">', '</span>', 'search', '<span calss="w3">', '</span>') | - +----+-------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ - | 1 | An open-source fulltext search engine and column store. | ...<span class="w1">fulltext</span>...<br>... <span calss="w3">search</span> ...<br> | - | 2 | An open-source storage engine for fast fulltext search with MySQL. | ...<span class="w1">fulltext</span>...<br>... <span calss="w3">search</span> ...<br> | - | 3 | Tritonn is a patched version of MySQL that supports better fulltext search function with Senna. | ...f <span class="w2">MySQL</span> ...<br>...<span class="w1">fulltext</span>...<br> | - +----+-------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ - 3 rows in set (0.00 sec) - -The keyword 'fulltext' and associated keyword 'MySQL' and 'search' has been extracted. -------------- next part -------------- HTML����������������������������...ダウンロード
