select version();

>> 5.7.36-google-log

WITH p1 AS (

SELECT '111' as arg1 from dual

)

select * from p1

;

ERROR 1064 : 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 'P1 AS (

select '121' AS arg1 from DUAL) 

select * from p1' at line 1

많은 도움 받고 있는데요. mysql 관련 with 명령 안되는것

같아서요. 버젼 때문인지 문의 드립니다.