...l/Indexer.php --rebuild --source=mysql://root:123456@localhost/test --sql="SELECT * FROM documents" --project=demo 开始重建索引 ... 初始化数据源 ... mysql://root:123456@localhost/test [XSException] [color=#FF0000]../data/web/sftest/php/util/XSDataSource.class.php(826): SQLSTATE[HY0...
...oot@localhost ~]# Indexer.php --source=mysql://xxx@localhost/phpcms --sql="SELECT a.id,a.title,a.url,a.catid,FROM_UNIXTIME (inputtime,'%Y%m%d' ) as inputtime,ad.content,c.catname,c.url as caturl FROM v9_dede_article AS a LEFT JOIN v9_dede_article_data as ad on a.id=ad.id LEFT JOIN v9_category as...
...dexer.php --rebuild --source=mys ql://root:123456@192.168.1.1/shop --sql="select * from search_products1" --project=demo 成功！ Indexer.php --rebuild --source=mys ql://root:123456@192.168.1.1/shop --sql="select * from search_products2" --project=demo 再次导入另外1个表，这时候...
...下很火的lbs搜索呢？ sphinx配置： [code] sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `fandian` sql_query = SELECT `id`,`type`, `name`, RADIANS(`lat`) AS `latitude`, RADIANS(`lon`) AS `longitude` FROM `fandian` WHERE (`id` >= $start AND `id` SetServer("loc...
这是mysql查询的结果 mysql> select group_concat(game_tag.tag__id) as tag__id,t.id as id from m as t left join game_tag on t.game__id = game_tag.game__id group by t.game__id; +-----------------------------------------------------------------------------+-----+ | tag__id ...
...'LIMIT 1' at line 1 #0 XSDataSource.class.php(454): XSDatabasePDO->query('select LIMIT 1') #1 XSDataSource.class.php(213): XSDatabase->query1('select') #2 XSDataSource.class.php(33): XSDatabaseDataSource->init() [hr] --sql="select * from sj_union " --project=demo
...'LIMIT 1' at line 1 #0 XSDataSource.class.php(454): XSDatabasePDO->query('select LIMIT 1') #1 XSDataSource.class.php(213): XSDatabase->query1('select') #2 XSDataSource.class.php(33): XSDatabaseDataSource->init() [hr] --sql="select * from sj_union " --project=demo
...表进行多表链接，并建立了索引， 比如我的sql如下： select * from goods as g left join order as o on g.gid = o.gid left join comment as c on g.gid = c.gid where ..... group by g.gid 然后，用$index->add($doc), 一条条加入 2> 更新索引时，我又重新跑一...
... [code] util/Indexer.php --source=mysql://root:pwd@localhost/dede --sql="SELECT ID, title, content FROM dede_article" --project=search [/code] 结果显示成功索引556752条数据 3、测试搜索 [code]util/Quest.php search NBA[/code] 显示： [code]在 181，298条数据中，大约有 3880 ...
...l://数据库用户名:数据库密码@数据库地址/数据库名 --sql="select t.tid as tid, t.fid as fid, t.author as author, t.authorid as authorid, t.postdate as postdate, t.subject as subject, tm.content as content from pw_threads t left join pw_tmsgs tm on t.tid = tm.tid where t.ifcheck = 1 ...