"Unrecognized statement type. (near "WITH" at position 0)" mysql

Question

My query structure is like below.

WITH cte1 AS (SELECT a, b FROM table1) SELECT * FROM cte1;

but it comes with below error

Unrecognized statement type. (near "WITH" at position 0)

I have checked my MySQL version with mysql --version command and my MySQL version is mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper

It's an issue with the "with" keyword.

Can you please help me with this concern?

MySQL prior to version 8.0 doesn't support the WITH clause https://stackoverflow.com/questions/1382573/how-do-you-use-the-with-clause-in-mysql — ScaisEdge, Apr 06 '19 at 11:30
@scaisEdge It works with V 8.0. https://www.db-fiddle.com/f/2f7NEPo72tUM7zLHBX2GXQ/0 — Rav's Patel, Apr 06 '19 at 11:33
I'm on `mysql Ver 8.0.22-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu))` and get the same error ! I don't understand. — Meloman, Jan 07 '21 at 10:28
In fact, PHPMyAdmin doesn't like the statement WITH and returns an error in SQL query window but it executes the query anyway. — Meloman, May 18 '21 at 12:54

score 3 · Accepted Answer · answered Apr 06 '19 at 12:50

3

Use MySQL version 8+, or MariaDB 10.2+, if you need common table expressions.

answered Apr 06 '19 at 12:50

O. Jones

103,626
17
118
172

"Unrecognized statement type. (near "WITH" at position 0)" mysql

1 Answers1