Change the value of the SQL_MODE parameter to PIPES_AS_CONCAT. : Global Variables « Command MySQL « SQL / MySQL






  1. SQL / MySQL
  2. Command MySQL
  3. Global Variables

Change the value of the SQL_MODE parameter to PIPES_AS_CONCAT.

      
mysql>
mysql> SET @@SQL_MODE = 'PIPES_AS_CONCAT';
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>








Related examples in the same category

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