MySQL: Group Concatenation

One of those small thing that are not essential but yet very helpful - GROUP_CONCAT which returns grupped rows as one string with selected separator (comma by default). EG:

SELECT GROUP_CONCAT(ID), type FROM `User` GROUP BY type;

This will return something like:
1,2,4,12 | admin
3,5,6,7,8,9,10,11 | user
SELECT GROUP_CONCAT(DISTINCT County ORDER BY Country SEPARATOR '; '), type FROM `User` GROUP BY type;

The result may be like this:
Ukraine; Russia; USA | admin
Russia; Canada; USA | user

Referenced from : http://www.soel.org.ua/programming/databases/mysql-group-concatenation

Comments

Post a Comment

Popular posts from this blog

How to create unicode files using VBA?

Image
Using the Scripting Runtime library you can create a unicode text file and write to it like: Sub test() 'set reference to Microsoft Scripting Runtime lib Dim strFile As String, strRange1 As String, strRange2 As String Dim fso As FileSystemObject Dim txtStrm As TextStream strFile = "Y:\Work\MyFile.htm" 'amend as appropriate strRange1 = Range("A1").Value strRange2 = Range("A2").Value Set fso = New FileSystemObject Set txtStrm = fso.CreateTextFile(strFile, Overwrite:=True, Unicode:=True) With txtStrm .WriteLine strRange1 .WriteLine strRange2 .Close End With End Sub You must set a reference within the VBE via Tools>References to the Microsoft Scripting Runtime lib.
Read more

JAVA: Set filename using setHeader()

Image
Using the response.setHeader() method you can easy set the filename and extention as you like. response.setContentType("image/jpeg"); response.setHeader( "Content-Disposition", "attachment;filename=MyFilename.jpg;" ); If you are serving other fileformats, remember to change the content type.
Read more