Home IT Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ MySQL group_con cat_max_Len     - Installing software on Ubuntu: apt-get and dpkg difference (Linux)

- Zabbix monitors the status of TCP connections (Server)

- Use of the storage-level replication technology will quickly clone a ASM database to the target environment (Database)

- Python: Finding meet the conditions specified in the file directory (Programming)

- High-performance JavaScript loops and flow control (Programming)

- 6 common PHP security attacks (Linux)

- Use LKM change the default linux security level (Linux)

- ORA-01839 error caused by incorrect system date setting (Database)

- C ++ in the elimination Wunused (Programming)

- The traffic monitoring system: cacti (Linux)

- Using Java program determines whether it is a leap year (Programming)

- About DataGuard three protected mode test (Database)

- LogStash log analysis display system (Linux)

- Linux server disk expansion and Oracle tablespace file migration operations (Database)

- Oracle GoldenGate encryption (Database)

- Puppet installation and testing (Server)

- in no backup ex: error: Xin Tourou ah backup child process has Singles DAT / US person / bin / in no backup ex (Database)

- Upgrading to Debian 7.6 glibc 2.15 (Linux)

- Configuring Allatori code confusion when developing general Java applications in NetBeans (Programming)

- Android using SVG vector graphics to create cool animation effects (Programming)

  MySQL group_con cat_max_Len
  Add Date : 2018-11-21      
  MySQL provides group_concat function can splice a field value to a string, such as select group_concat (user_name) from sys_user, the default separator is a comma, that "" if you need custom delimiter can be used SEPARATOR

Such as: select group_concat (user_name SEPARATOR '_') from sys_user

However, if the length of the byte string user_name splicing more than 1024 will be truncated.

The command "show variables like 'group_concat_max_len'" to see group_concat default length:

mysql> show variables like 'group_concat_max_len';
+ -------- + ------- +
| Variable_name | Value |
+ -------- + ------- +
| Group_concat_max_len | 1024 |
+ -------- + ------- +
1 row in set

Add disposed MySQL configuration file: group_concat_max_len = -1 (-1 maximum or according to actual demand set the length), you need to restart MySQL after the configuration service to view as follows:

mysql> show variables like 'group_concat_max_len';
+ ---------------------- + ------------ +
| Variable_name | Value |
+ ---------------------- + ------------ +
| Group_concat_max_len | 4294967295 |
+ ---------------------- + ------------ +
1 row in set

If this is a production environment, can not be allowed to restart the MySQL service, you can set the scope group_concat by statements such as:

 SET GLOBAL group_concat_max_len = -1;

 SET SESSION group_concat_max_len = -1;
- Setting up Linux machine through a proxy firewall (Linux)
- GitLab upgrade to 8.2.0 (Linux)
- Installation and deployment of MariaDB under CentOS (Database)
- Linux at command (Linux)
- C ++ hash function (Programming)
- Use CutyCapt to convert HTML pages to png images on Linux (Linux)
- ElasticSearch - Basic Concepts (Server)
- Android WebView use layman (Programming)
- Oracle PLS-00231 error analysis (Database)
- Android imageView in the Src and Background (Programming)
- Java Foundation - The relationship between abstract classes and interfaces (Programming)
- Linux virtual machines to solve end MySQL database can not remote access (Database)
- Linux screen command (Linux)
- Kubernetes Cluster Setup problems encountered and solutions (Server)
- using the ssh command to check the socket / Network Connections (Linux)
- Add your own kernel and ramfs based on an existing Linux LiveCD (Linux)
- How VirtualBox and VMware virtual machine conversion (Linux)
- How to troubleshoot error java.lang.NoSuchMethodError (Programming)
- installation and configuration of the PHP environment (Apache2) under Linux (Server)
- Squid proxy server (Server)
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.