Skip to content
Advertisement

MySQL Workbench reports “is not valid at this position for this server version” error

For the following SQL query:

SELECT 
CONCAT( customers.name, '   ', customers.familyname ) As Name,

I receive the following error message:

“SELECT” is not valid at this position for this server version, expecting: ‘(‘, WITH

I Have tried to run the query deleting the space between and other format but the SELECT error still remains.

could anyone help me, please?

Advertisement

Answer

The query SELECT CONCAT( customers.name, ' ', customers.familyname ) As Name parses with no errors for me, but with the trailing comma it shows the mentioned error.

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement