MySQL :: MySQL 5.7 Reference Manual :: FLUSH Syntax

MySQL :: MySQL 5.7 Reference Manual :: FLUSH Syntax Contact MySQL  |  Login  |  Register The world's most popular open source database MySQL.com Downloads Documentation Developer Zone Developer Zone Downloads MySQL.com Documentation MySQL Server MySQL Enterprise Workbench Router Utilities/Fabric MySQL NDB Cluster Connectors More MySQL.com Downloads Developer Zone Section Menu:   Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax Data Definition Statements ALTER DATABASE Syntax ALTER EVENT Syntax ALTER FUNCTION Syntax ALTER INSTANCE Syntax ALTER LOGFILE GROUP Syntax ALTER PROCEDURE Syntax ALTER SERVER Syntax ALTER TABLE Syntax ALTER TABLE Partition Operations ALTER TABLE Online Operations in MySQL Cluster ALTER TABLE and Generated Columns ALTER TABLE Examples ALTER TABLESPACE Syntax ALTER VIEW Syntax CREATE DATABASE Syntax CREATE EVENT Syntax CREATE FUNCTION Syntax CREATE INDEX Syntax CREATE LOGFILE GROUP Syntax CREATE PROCEDURE and CREATE FUNCTION Syntax CREATE SERVER Syntax CREATE TABLE Syntax CREATE TABLE Statement Retention Files Created by CREATE TABLE CREATE TABLE ... LIKE Syntax CREATE TABLE ... SELECT Syntax Using FOREIGN KEY Constraints Silent Column Specification Changes CREATE TABLE and Generated Columns Secondary Indexes and Generated Columns Setting NDB_TABLE Options in Table Comments CREATE TABLESPACE Syntax CREATE TRIGGER Syntax CREATE VIEW Syntax DROP DATABASE Syntax DROP EVENT Syntax DROP FUNCTION Syntax DROP INDEX Syntax DROP LOGFILE GROUP Syntax DROP PROCEDURE and DROP FUNCTION Syntax DROP SERVER Syntax DROP TABLE Syntax DROP TABLESPACE Syntax DROP TRIGGER Syntax DROP VIEW Syntax RENAME TABLE Syntax TRUNCATE TABLE Syntax Data Manipulation Statements CALL Syntax DELETE Syntax DO Syntax HANDLER Syntax INSERT Syntax INSERT ... SELECT Syntax INSERT DELAYED Syntax INSERT ... ON DUPLICATE KEY UPDATE Syntax LOAD DATA INFILE Syntax LOAD XML Syntax REPLACE Syntax SELECT Syntax SELECT ... INTO Syntax JOIN Syntax UNION Syntax Subquery Syntax The Subquery as Scalar Operand Comparisons Using Subqueries Subqueries with ANY, IN, or SOME Subqueries with ALL Row Subqueries Subqueries with EXISTS or NOT EXISTS Correlated Subqueries Subqueries in the FROM Clause Subquery Errors Optimizing Subqueries Rewriting Subqueries as Joins UPDATE Syntax Transactional and Locking Statements START TRANSACTION, COMMIT, and ROLLBACK Syntax Statements That Cannot Be Rolled Back Statements That Cause an Implicit Commit SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Syntax LOCK TABLES and UNLOCK TABLES Syntax Interaction of Table Locking and Transactions LOCK TABLES and Triggers Table-Locking Restrictions and Conditions SET TRANSACTION Syntax XA Transactions XA Transaction SQL Syntax XA Transaction States Replication Statements SQL Statements for Controlling Master Servers PURGE BINARY LOGS Syntax RESET MASTER Syntax SET sql_log_bin Syntax SQL Statements for Controlling Slave Servers CHANGE MASTER TO Syntax CHANGE REPLICATION FILTER Syntax MASTER_POS_WAIT() Syntax RESET SLAVE Syntax SET GLOBAL sql_slave_skip_counter Syntax START SLAVE Syntax STOP SLAVE Syntax SQL Statements for Controlling Group Replication START GROUP_REPLICATION Syntax STOP GROUP_REPLICATION Syntax Prepared SQL Statement Syntax PREPARE Syntax EXECUTE Syntax DEALLOCATE PREPARE Syntax Compound-Statement Syntax BEGIN ... END Compound-Statement Syntax Statement Label Syntax DECLARE Syntax Variables in Stored Programs Local Variable DECLARE Syntax Local Variable Scope and Resolution Flow Control Statements CASE Syntax IF Syntax ITERATE Syntax LEAVE Syntax LOOP Syntax REPEAT Syntax RETURN Syntax WHILE Syntax Cursors Cursor CLOSE Syntax Cursor DECLARE Syntax Cursor FETCH Syntax Cursor OPEN Syntax Condition Handling DECLARE ... CONDITION Syntax DECLARE ... HANDLER Syntax GET DIAGNOSTICS Syntax RESIGNAL Syntax SIGNAL Syntax Scope Rules for Handlers The MySQL Diagnostics Area Database Administration Statements Account Management Statements ALTER USER Syntax CREATE USER Syntax DROP USER Syntax GRANT Syntax RENAME USER Syntax REVOKE Syntax SET PASSWORD Syntax Table Maintenance Statements ANALYZE TABLE Syntax CHECK TABLE Syntax CHECKSUM TABLE Syntax OPTIMIZE TABLE Syntax REPAIR TABLE Syntax Plugin and User-Defined Function Statements CREATE FUNCTION Syntax for User-Defined Functions DROP FUNCTION Syntax INSTALL PLUGIN Syntax UNINSTALL PLUGIN Syntax SET Syntax SET Syntax for Variable Assignment SET CHARACTER SET Syntax SET NAMES Syntax SHOW Syntax SHOW BINARY LOGS Syntax SHOW BINLOG EVENTS Syntax SHOW CHARACTER SET Syntax SHOW COLLATION Syntax SHOW COLUMNS Syntax SHOW CREATE DATABASE Syntax SHOW CREATE EVENT Syntax SHOW CREATE FUNCTION Syntax SHOW CREATE PROCEDURE Syntax