VALUES statement

Aikesheng Open Source Community

Mar 25, 2020 · Databases

Using the New TABLE and VALUES DML Statements in MySQL 8.0.19

MySQL 8.0.19 adds two novel DML statements—TABLE for convenient full‑table scans and sub‑query replacements, and VALUES for generating in‑memory row sets—each with clear syntax, practical examples, and execution‑plan insights that help developers quickly adopt these features.