Syntax error: 'with' (with) is not valid input at this position

Question

It is said that "MySQL will support CTE's in version 8". But with MySQL server upgraded to 8.0.12, I am still getting this Syntax error for using 'with' clause. The SQL statement I was using is pretty simple

With t1 as (select name, price from product) select name from t1

Can anyone point out what is the problem with this line of code?

Not sure about MySQl, but in sql-server its recommend to start CTE with semicolon https://stackoverflow.com/questions/6938060/common-table-expression-why-semicolon — Vinit, Aug 01 '18 at 00:36
@Aaron_Geng . . . You probably have some back-compatibility level set. — Gordon Linoff, Aug 01 '18 at 01:22
@GordonLinoff but, all connection, schema and table are created after server was upgraded to 8.0 — Aaron_Geng, Aug 01 '18 at 02:24

score -1 · Answer 1 · answered Oct 16 '18 at 09:22

-1

MySQL doesn't support common table expressions and WITH syntax until version 8.0.1.

answered Oct 16 '18 at 09:22

vanquan223

139
2
5

1

What you say might be true, but Op has installed 8.0.12. I have same problem with 8.0.18. – Dec 12 '19 at 03:27

Syntax error: 'with' (with) is not valid input at this position

1 Answers1