我使用JDBC/SphinxQL (Sphinx version2.01Beta)执行以下查询
使用WHERE子句:
ResultSet res = stmt.executeQuery("SELECT * FROM myindex WHERE MATCH('name')");不带WHERE子句
ResultSet res = stmt.executeQuery("SELECT * FROM myindex");但在这两种情况下,我都得到了以下相当大的错误:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
sphinxql: syntax error, unexpected WHERE, expecting $end near
'WHERE Variable_name ='language' OR Variable_name =
'net_write_timeout' OR Variable_name = 'interactive_timeout'
OR Variable_name = 'wait_timeout' OR Variable_name =
'character_set_client' OR Variable_name = 'character_set_connection'
OR Variable_name = 'character_set' OR Variable_name
= 'character_set_server' OR Variable_name = 'tx_isolation'
OR Variable_name = 'transaction_isolation' OR Variable_name
= 'character_set_results' OR Variable_name = 'timezone'
OR Variable_name = 'time_zone' OR Variable_name =
'system_time_zone' OR Variable_name = 'lower_case_table_names'
OR Variable_name = 'max_allowed_packet' OR
Variable_name = 'net_buffer_length' OR Variable_name =
'sql_mode' OR Variable_name = 'query_cache_type'
OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect''我不理解all...help的错误,我很欣赏!
发布于 2011-06-17 10:01:20
您的MATCH谓词的格式不正确。
更改:
SELECT * FROM myindex WHERE MATCH('name')至
SELECT * FROM myindex WHERE MATCH(some_column) AGAINST ('name')https://stackoverflow.com/questions/6378439
复制相似问题