Question

sphinx配置文件 sql_query从mysql读数据，建索引一直是 total 0 reads,total 0 writes

这是我sphinx.conf 的内容
source src1
{
type = mysql

sql_host = localhost
sql_user = root
sql_pass = ******
sql_db = fangxinjia_sku
sql_port = 3306 # optional, default is 3306

sql_query_pre = SET NAMES utf8
sql_query_pre = SET SESSION query_cache_type=OFF

sql_query = \
SELECT product_attribute_id \
FROM product_attribute

sql_attr_uint = product_attribute_id
}

这是我建立索引的命令 /usr/local/sphinx/bin/indexer --config /usr/local/sphinx/etc/sphinx.conf --all
执行完 一直是这个结果，

Sphinx 2.2.10-id64-release (2c212e0)
Copyright (c) 2001-2015, Andrew Aksyonoff
Copyright (c) 2008-2015, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/usr/local/sphinx/etc/sphinx.conf'...
skipping non-plain index 'product_attribute'...
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg

求教有什么问题，感谢
mysql库中有文件，索引执行命运也没有报错，但就是没数据

Answer 1

SQL code?12SELECT product_attribute_id \ FROM product_attribute

确定表里有数据？

sql_query = \
SELECT product_attribute_id \
FROM product_attribute

为什么加这两个\