MySQL 8 CTE и Update?

Question

[Ланселот]

Здравствуйте. А можно ли как то в MySQL 8.0.22 в CTE сделать обновление?

WITH
  tmpCustomer AS (
    SELECT c.customer_id AS id, c.email
    FROM oc_order r
    INNER JOIN oc_customer c ON c.customer_id = r.customer_id
    WHERE r.order_status_id = 6 AND c.customer_group_id < 3
    GROUP BY c.customer_id
    HAVING COUNT(*) > 4
  ),
  tmpCustomerU AS (
    UPDATE oc_customer SET customer_group_id = 3 WHERE customer_id IN (SELECT id FROM tmpCustomer)
  )
  SELECT email FROM tmpCustomer

Comments

[Akina]

Нет, нельзя.

[Daria Motorina]

Что такое СТЕ?

[Slava Rozhnev]

Daria Motorina, Общие табличные выражения Common Table Expression (CTE)

[Akina]

Daria Motorina,

MySQL 8.0 Reference Manual / WITH (Common Table Ex...

[Daria Motorina]

Slava Rozhnev Akina спасибо)