SphinxQL referenceΒΆ
SphinxQL is our SQL dialect that exposes all of the search daemon functionality using a standard SQL syntax with a few Manticore-specific extensions. Everything available via the SphinxAPI is also available via SphinxQL but not vice versa; for instance, writes into RT indexes are only available via SphinxQL. This chapter documents supported SphinxQL statements syntax.
- ALTER syntax
- ATTACH INDEX syntax
- BEGIN, COMMIT, and ROLLBACK syntax
- BEGIN syntax
- CALL KEYWORDS syntax
- CALL QSUGGEST syntax
- CALL SNIPPETS syntax
- CALL SUGGEST syntax
- Comment syntax
- CREATE FUNCTION syntax
- CREATE PLUGIN syntax
- DELETE syntax
- DESCRIBE syntax
- DROP FUNCTION syntax
- DROP PLUGIN syntax
- FLUSH ATTRIBUTES syntax
- FLUSH HOSTNAMES syntax
- FLUSH LOGS syntax
- FLUSH RAMCHUNK syntax
- FLUSH RTINDEX syntax
- INSERT and REPLACE syntax
- List of SphinxQL reserved keywords
- Multi-statement queries
- OPTIMIZE INDEX syntax
- RELOAD INDEX syntax
- RELOAD INDEXES syntax
- RELOAD PLUGINS syntax
- REPLACE syntax
- ROLLBACK syntax
- SELECT syntax
- SELECT @@system_variable syntax
- SET syntax
- SET TRANSACTION syntax
- SHOW AGENT STATUS
- SHOW CHARACTER SET syntax
- SHOW COLLATION syntax
- SHOW DATABASES syntax
- SHOW INDEX SETTINGS syntax
- SHOW INDEX STATUS syntax
- SHOW META syntax
- SHOW PLAN syntax
- SHOW PLUGINS syntax
- SHOW PROFILE syntax
- SHOW STATUS syntax
- SHOW TABLES syntax
- SHOW THREADS syntax
- SHOW VARIABLES syntax
- SHOW WARNINGS syntax
- TRUNCATE RTINDEX syntax
- UPDATE syntax