Global Variables « Command MySQL « SQL / MySQL






  1. SQL / MySQL
  2. Command MySQL
  3. Global Variables
1.View the current setting for the global transaction isolation level by using the @@global.tx_isolation system variable
2.Returns the isolation level for the current session and the maximum permitted size of the binary log file
3.SET @@session.character_set_client
4.SET @@session.character_set_results
5.SET @@character_set_connection
6.SELECT @@COLLATION_DATABASE
7.Change the @@STORAGE_ENGINE
8.Determine the isolation level of a connection
9.Determining the Communication Forms Supported by the MySQL Server




10.Change the value of the SQL_MODE parameter to PIPES_AS_CONCAT.