MySQL 8.0 Reference Manual xv 13.2.3 DO Statement .................................................................................................... 2625 13.2.4 HANDLER Statement ......................................................................................... 2626 13.2.5 IMPORT TABLE Statement ................................................................................ 2628 13.2.6 INSERT Statement ............................................................................................. 2630 13.2.7 LOAD DATA Statement ...................................................................................... 2639 13.2.8 LOAD XML Statement ........................................................................................ 2651 13.2.9 REPLACE Statement .......................................................................................... 2658 13.2.10 SELECT Statement .......................................................................................... 2661 13.2.11 Subqueries ....................................................................................................... 2682 13.2.12 TABLE Statement ............................................................................................. 2699 13.2.13 UPDATE Statement .......................................................................................... 2702 13.2.14 VALUES Statement .......................................................................................... 2705 13.2.15 WITH (Common Table Expressions) .................................................................. 2708 13.3 Transactional and Locking Statements ........................................................................... 2720 13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Statements .......................... 2720 13.3.2 Statements That Cannot Be Rolled Back ............................................................. 2723 13.3.3 Statements That Cause an Implicit Commit ......................................................... 2723 13.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements ................................................................................................................... 2724 13.3.5 LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements ............... 2725 13.3.6 LOCK TABLES and UNLOCK TABLES Statements ............................................. 2726 13.3.7 SET TRANSACTION Statement .......................................................................... 2732 13.3.8 XA Transactions ................................................................................................. 2734 13.4 Replication Statements .................................................................................................. 2740 13.4.1 SQL Statements for Controlling Source Servers ................................................... 2740 13.4.2 SQL Statements for Controlling Replica Servers .................................................. 2743 13.4.3 SQL Statements for Controlling Group Replication ............................................... 2784 13.5 Prepared Statements ..................................................................................................... 2789 13.5.1 PREPARE Statement ......................................................................................... 2793 13.5.2 EXECUTE Statement ......................................................................................... 2795 13.5.3 DEALLOCATE PREPARE Statement .................................................................. 2795 13.6 Compound Statement Syntax ........................................................................................ 2796 13.6.1 BEGIN ... END Compound Statement .................................................................. 2796 13.6.2 Statement Labels ............................................................................................... 2796 13.6.3 DECLARE Statement ......................................................................................... 2797 13.6.4 Variables in Stored Programs ............................................................................. 2797 13.6.5 Flow Control Statements ..................................................................................... 2799 13.6.6 Cursors .............................................................................................................. 2804 13.6.7 Condition Handling ............................................................................................. 2806 13.6.8 Restrictions on Condition Handling ...................................................................... 2834 13.7 Database Administration Statements .............................................................................. 2834 13.7.1 Account Management Statements ....................................................................... 2834 13.7.2 Resource Group Management Statements .......................................................... 2882 13.7.3 Table Maintenance Statements ........................................................................... 2886 13.7.4 Component, Plugin, and Loadable Function Statements ....................................... 2900 13.7.5 CLONE Statement .............................................................................................. 2904 13.7.6 SET Statements ................................................................................................. 2905 13.7.7 SHOW Statements ............................................................................................. 2911 13.7.8 Other Administrative Statements ......................................................................... 2969 13.8 Utility Statements .......................................................................................................... 2982 13.8.1 DESCRIBE Statement ........................................................................................ 2982 13.8.2 EXPLAIN Statement ........................................................................................... 2982 13.8.3 HELP Statement ................................................................................................ 2986 13.8.4 USE Statement .................................................................................................. 2988