How to populate an index from an existing table?

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?

Manticore doesn’t support INSERT INTO ... SELECT.
It looks like you didn’t read the manual .

And this interactive course may be useful for you.

1 Like