如何重置停止词在MYSQL？ [英] How to reset stop words in MYSQL?

问题描述

我想要在FULLTEXT搜索的mysql中重置停用词列表。我已经安装WAMP服务器在我的系统中有phpmyadmin访问mysql。但我不知道如何重置停止词在phpmyadmin。任何人都可以告诉我如何做。

我也 http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_ft_stopword_file 阅读此链接但不知道何时使用此

解决方案

我假设您使用 WampServer 。

点击托盘图标，选择 MySQL ，然后点击 my.ini 。配置文件将在记事本中打开。转到文件末尾并添加此行（在端口行之后）：

  ft_stopword_file =''
  

可停用停用字词。如果要使用自定义停用词文件，请将该行替换为：

  ft_stopword_file ='path / to / stopword_file.txt '
  

（当然设置禁用词文件的路径）。

设置该行后，保存配置文件（文件 - >保存）。然后单击托盘图标，选择 MySQL ，然后服务，然后单击 code>。

要确保配置正确，请在浏览器中打开 phpMyAdmin 在顶部的变量选项卡上，然后找到 ft stopword file 并查看设置的值。 / p>

I want to reset stop word list in mysql for FULLTEXT search. I have installed WAMP Server in my system which have phpmyadmin to access mysql. But I dont know how to reset stop word in phpmyadmin. Can anyone please tell me how to do that.

I also http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_ft_stopword_file read this link but don't know ho wto use this ???

解决方案

I assume you're using WampServer.

Click the tray icon, select MySQL, then click my.ini. The configuration file will open in notepad. Go to the end of the file and add this line (after the port line):

 ft_stopword_file=''

to disable stop words. If you want to use custom stop-word file, replace that line with:

ft_stopword_file='path/to/stopword_file.txt'

(set the path of the stopword file, of course).

After setting that line, save the configuration file (File -> Save). Then click the tray icon, select MySQL, then Service, then click Restart Service.

To Ensure that your configuration is done correctly, open phpMyAdmin in the browser, click on the Variables tab at the top, then find ft stopword file and see the values that is set to it.

这篇关于如何重置停止词在MYSQL？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！