Forums

I wrote a CTE like this (a simple CTE example to reproduce the problem):
:::sql with c as (select "Hello") select count(1) from c On my local machine (mariadb, identical to mysql), it worked. However here I got this: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c as (select "Hello") select count(1) from c' at line 1

As far as I remember it was introduced in MySQL 8.0, but our servers run on 5.7