mysql - 如何修复此服务器版本最新版本安装在此位置无效的 WITH 语句

Question

image here MySQL Workbench 告诉我，虽然我已经安装了最新的 SERVER 版本 - 5.7.27，但找不到对此服务器版本有效的 WITH。工作台是 8.0.17

WITH all_customers_and_reps AS 
(
    SELECT customer.customerNumber, customer.salesRepEmployeeNumber
    FROM customer
    WHERE salesRepEmployeeNumber = 1166
)
SELECT * FROM all_customers_and reps;

Answer 1

从 mysql 版本 8.0 开始可用的公共(public)表表达式
你可以用动态/临时表代替，例如:

SELECT * FROM (
    SELECT customer.customerNumber, customer.salesRepEmployeeNumber
    FROM customer
    WHERE salesRepEmployeeNumber = 1166

) all_customers_and reps;