Token mismatch when inserting two columns in another mysql table?

1

I have a code that selects two columns in a database:

SELECT DISTINCT ('owner_account'), 'grouped_country'
FROM 'genuine_k_value';

What I have to do is insert values into another table. I have tried to do the following:

INSERT INTO 'genuine_agents' ( 'agent_email', 'agent_country' )
SELECT DISTINCT ('owner_account'), 'grouped_country'
FROM 'genuine_k_value';

But it gives me:

  

Error: Token mismatch

I know that the query has to be in a form:

INSERT INTO tabla (´columna1´, ´columna2´)
VALUES ('valor 1', 'valor 2');

But I can not apply it to my case.

    
asked by Lukas 14.03.2017 в 17:40
source

1 answer

2

This error usually occurs when there are problems with the server cache.

One solution is to restart the server so that this memory is cleaned and the configuration is loaded again.

    
answered by 15.03.2017 / 16:05
source