MySQueaL Resources

resources for mysql admins and developers who are squealing for help

More Resources

Main Doc Pages
Privileges Required
  • ALTER ROUTINE
Comments
MySQL columns: everywhere I look are tables and columns; life is filled with databases of information to be ordered and grouped. (Ca'Grande, Milan, Italy)

SET SQL_LOG_BIN Statement

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

hits past month: 15 ;  last updated: may 4, 2009 - 2:34am ;  parent: MySQL Replication

Syntax

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.

Return to MySQL Replication page of our MySQL Documentation