SQL ERROR in Syntax when using WITH

Question

I want to use a SQL Query with the WITH clause an I get a Syntax Error.

I´m using MySQL Version 5.6.28

Here a simple Code example

WITH alias_test AS (SELECT id, title FROM `tips_locations`)
SELECT id, title
FROM alias_test

Here the error I get in my SQL Tool

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 'alias_test AS (SELECT id, title FROM tips_locations) SELECT id, title FROM ali' at line 1

Can you Help me?

MySQL doesn't support CTEs – Gurwinder Singh Feb 17 '17 at 19:37 — Gurwinder Singh, Feb 17 '17 at 19:37
mysql doesn't do it... I'd advise getting a refund. – Hogan Feb 17 '17 at 19:55 — Hogan, Feb 17 '17 at 19:55
WITH is now supported in MySQL 8 – Geoff Kendall Apr 29 '22 at 08:50 — Geoff Kendall, Apr 29 '22 at 08:50

score 3 · Accepted Answer · answered Feb 17 '17 at 19:40

3

MySQL doesn't support WITH clause or CTE and thus the error. Alternative, you can either use a temporary table or a normal table like

CREATE TEMPORARY TABLE alias_test AS 
SELECT id, title FROM `tips_locations`;

SELECT id, title
FROM alias_test;

answered Feb 17 '17 at 19:40

Rahul

76,197
13
71
125

SQL ERROR in Syntax when using WITH

1 Answers1

Linked

Related