源数据有16条, 导入用了group by 后 只能导入2条了 [quote][root@FPDev util]# 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...
... 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> 更新索引时,我又重新跑一次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 w...
这是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 ...