Data Definition Statements 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 This chapter describes the syntax for the SQL statements supported by MySQL. 13.1 Data Definition Statements 13.1.1 Atomic Data Definition Statement Support 2464