Section 13.2.10.1, “SELECT ... INTO Statement” Section 13.2.11, “Subqueries” Section 13.2.12, “TABLE Statement” Section 13.2.10.3, “UNION Clause” Section 13.2.14, “VALUES Statement” Section 1.3, “What Is New in MySQL 8.0” Section 13.2.6, “INSERT Statement” Section 13.2.9, “REPLACE Statement” [index top] Section 15.1.1, “Benefits of Using InnoDB Tables” Section 13.6.5, “Flow Control Statements” Section 13.6.5.3, “ITERATE Statement” Section 13.6.5.4, “LEAVE Statement” Section 13.6.2, “Statement Labels” Section 13.6.5.8, “WHILE Statement” Section 13.2.2, “DELETE Statement” Section 8.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization” Section 13.2.10, “SELECT Statement” Section B.3.6.2, “TEMPORARY Table Problems” Section 13.2.13, “UPDATE Statement” Section 1.3, “What Is New in MySQL 8.0” Section 13.2.15, “WITH (Common Table Expressions)” [index top] Section 27.12.7, “Performance Schema Transaction Tables” Section 8.11.4, “Metadata Locking” Section 27.12.7, “Performance Schema Transaction Tables” Section 5.1.8, “Server System Variables” Section 27.12.7.1, “The events_transactions_current Table” Section 2.11.6, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux” Section 13.3.8.2, “XA Transaction States” Section 13.3.8.3, “Restrictions on XA Transactions” VALUES ROW() W WHERE WHILE WITH X XA BEGIN XA COMMIT XA END 5988