mysql8.0 with as报错了,有没有人遇到过

Question

Error Code: 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 '' at line 1 0.000 sec

Answer 1

好像是因为你没有使用这个子查询部分。去掉分号，下面加条语句任意用这个子查询就可以了
例如：
with tmp as(select * from dept)
select * from tmp