If you use MySQL workbench, you might or already have encountered an error such as “Select is not valid at this position for this server version”.
If you ever come across this error, then this definitely means that the SQL query you are executing has some syntax error, that is, some keywords are wrongly placed.
Example,
Suppose there are two tables customers and orders between which we want to apply a JOIN operation on columns id
and customerid
of tables customers and orders respectively.
SQL Query for the JOIN operation should be
SELECT * FROM customers JOIN orders ON customers.id = orders.customerid;
Now if you mistakenly place the ON keyword just after JOIN keyword and insert a WHERE before the condition, which makes the query as
SELECT * FROM customers JOIN ON orders WHERE customers.id = orders.customerid;
You are most likely to get the above error as shown below.
Do not forget to hit the clap button.