博客 -- 2




求按天内去重后结果有一个表 A:表 A 结构及数据time_strremote_host2015-02-17 21:25:53112.142.97.542015-02-17 21:25:52128.9.1.22015-02-17 19:13:43133.09.12.382015-02-17 18:44:10128.9.1.22015-02-16 23:27:36136.22.15.992015-02-16 23:27:19136.22.15.992015-02-17 21:25:08128.9.1.22015-02-16 23:30:24136.22.15.992015-02-16 23:28:2644.52.142.72015-02-16 23:28:06112.142.97.542015-02-17 20:50:26133.09.12.382015-02-17 19:59:35112.142.97.542015-02-17 20:50:32133.09.12.382015-02-16 23:30:28136.22.15.992015-02-17 18:43:54133.09.12.382015-02-17 18:43:46112.142.97.542015-02-16 23:32:42112.142.97.542015-02-16 23:32:38127.09.18.
#技术帖    #mysql    #sql    #技术分享   
# # Minimal Sphinx configuration sample (clean, simple, functional) # source src_all { type = mysql sql_host = localhost sql_user = root sql_pass = zeyu2032 sql_db = zeyu_blog sql_port = 3306 # optional, default is 3306 sql_query = \ SELECT article_id, lower(draft) FROM article; sql_attr_uint = article_id } index all { source = src_all path = /usr/local/sphinx/var/data/zeyu_blog/all mlock = 0 morphology = none docinfo = extern min_word_len = 1 html_strip = 0 #stopwords = /path/to/stowords.txt的位置 charset_type = zh_cn.utf-8 ngram_len
#技术帖    #linux    #配置文件    #mysql   



京ICP备15018585号