This may be naive as I’m new to manticore search. I’m trying to populate article_search index from an existing table using these commands in terminal:
CREATE TABLE article_search(title text, description text); INSERT INTO article_search(title,description) SELECT title,description FROM blog.article;
but I get:
ERROR 1064 (42000): sphinxql: syntax error, unexpected SELECT, expecting VALUES near 'select (title,description) from blog.article'
What I’m missing here? And how can I correct it?