SET SQL_LOG_BIN

This MySQL statement enables or disables binary logging of SQL statements for the current connection.

Syntax

Below is the syntax for this command. Text within square brackets (i.e, [ and ] ) are optional. Choices are separated by bars (i.e, | ). Ellipses preceded by a comma indicates a repeating pattern. Ellipses before or after syntax are used to highlight a relevant except from the larger syntax. Text displayed in italic letters represent text that should be replaced with the specific names related to the database (e.g., column with the name of the column).

SET SQL_LOG_BIN = {0|1}

Explanation

This MySQL statement enables or disables binary logging of statements for the current connection to MySQL. It does not affect logging for the activities of other threads and is reset to the default value when the connection is closed. This statement requires SUPER privileges. A value of 0 disables binary logging; 1 enables it.

Examples

Below is an example of this MySQL statement:

SET SQL_LOG_BIN = 0;

This statement is generally used with conjunction with replication.