...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个表，这时候...
这是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 ...
...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...
...eption('Not specified any query SQL or db table'); } $sql = 'SELECT * FROM ' . $param['table']; } elseif (preg_match('/ limit\s+(\d+)(?:\s*,\s*(\d+)|\s+offset\s+(\d+))?\s*$/i', $sql, $match)) { if (isset($match[3])) { // LIMIT xxx OFFSET yyy $this->offset = intval...
...下很火的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...
...'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> 更新索引时，我又重新跑一...
...l]# php Indexer.php --rebuild --source=mysql://root:@localhost/shop --sql="select g.goods_id,g.cat_id,g.goods_name,g.en_goods_name,g.goods_short_name,g.en_goods_short_name,g.brand_id,g.shop_price,g.goods_brief,g.en_goods_brief,g.goods_img,CONCAT(ga.attr_id,'_',ga.attr_value) as attr_value from fp_go...