Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL function: group_concat () function     - How to install Linux Kernel 4.0 On CentOS 7 system (Linux)

- Close Pycharm spell check (Programming)

- Adding SSH to Github (Linux)

- Present Situation and Development Trend of firewall products (Linux)

- ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [] (Database)

- Java, boolean operators & =, | = ^ = use (Programming)

- XenServer virtual machines installed in dual-card configuration (Server)

- CentOS 6.x and CentOS7 install MPlayer (Linux)

- Java memory model subclasses (Programming)

- Three strategies to teach you to release the device memory (Linux)

- OpenStack image production in the CentOS 6.2 (Linux)

- The development environment to build Nodejs under Ubuntu 14.04 (Linux)

- Linux disk and File System Concepts (Linux)

- Linux, modify / etc / profile file (Linux)

- Arduino UNO simulation development environment set up and run simulation (Linux)

- Using Linux strace command trace / debug a program commonly used options (Linux)

- Use Tails 1.4 Linux system to protect the privacy and anonymity (Linux)

- How to build a custom exclusive Ubuntu Live CD (Linux)

- Python console achieve progress bar (Programming)

- MyCAT separate read and write to achieve MySQL Practice (Database)

 
         
  MySQL function: group_concat () function
     
  Add Date : 2018-11-21      
         
         
         
  GROUP_CONCAT (expr)
This function will merge non-null column values ​​in accordance with the grouping condition and eventually returned. If a null value is returned is empty, the complete syntax is as follows:
GROUP_CONCAT ([DISTINCT] expr [, expr ...]
            [ORDER BY {unsigned_integer | col_name | expr}
                [ASC | DESC] [, col_name ...]]
            [SEPARATOR str_val])
Example Column 1:
SELECT
    EMP_ID,
    SUM (VALUE1),
    SUM (VALUE2),
    SUM (VALUE3),
    GROUP_CONCAT (REAS_1 SEPARATOR ';'),
    GROUP_CONCAT (REAS_2),
    GROUP_CONCAT (REAS_3)
FROM
    ACT_GP_TEST
GROUP BY
    EMP_ID

Column 2:

SELECT
    EMP_ID,
    SUM (VALUE1),
    SUM (VALUE2),
    SUM (VALUE3),
    GROUP_CONCAT (REAS_1, REAS_2, REAS_3 SEPARATOR ';')
FROM
    ACT_GP_TEST
GROUP BY
    EMP_ID

The above column 1 and column 2 the difference is that the column 2 is the field REAS_1, REAS_2, REAS_3 field one by one as a complete merger.
The maximum length of the receive function group_concat_max_len environment variables defined, it defaults to 1024, of course, can be set higher. At the same time the effective maximum length is returned by the max_allowed_packet constraints.
Group_concat_max_len running is to modify the following syntax:
SET [GLOBAL | SESSION] group_concat_max_len = val;

The result returned is a binary or non-binary character, depending on the value of the function within the field itself. Usually when group_concat_max_len < = 512, in order to VARCHAR or VARBINARY, when the value is greater than the TEXT and BLOB.
     
         
         
         
  More:      
 
- Oracle metadata Reconstruction experiments (Database)
- CoreOS use register mirror to build private warehouse (Linux)
- CentOS 6.x and CentOS7 installation RPMforge (Linux)
- Let Git variety of colors and custom log format output (Linux)
- Elaborate .NET Multithreading: Using Task (Programming)
- CoreOS Linux introduces Kubernetes kubelet (Server)
- hexdump Linux command (Linux)
- Oracle database file path changes (Database)
- Java to achieve local fileCopy (Programming)
- Redhat Close SELinux correct step (Linux)
- Ubuntu / Fedora / CentOS system how to install Plex Media Server 0.9.9 (Linux)
- Convert MySQL date string to a NULL value exception handling (Database)
- Ruby and Python simple comparison (Programming)
- The file name is garbled or deleted files with special characters under Linux (Linux)
- To set up the printer use Nagios Monitoring Server (Server)
- OpenWrt modify flash size (Linux)
- Elaborate .NET Multithreading: Thread Pool (Programming)
- Volatile keyword in C language understanding (Programming)
- Linux settings Java_home (Linux)
- Two strokes to improve development productivity Struts2 (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.