Top "Group-concat" questions

MySQL GROUP_CONCAT with Nulls

Is there an option to make MySQL's Group_Concat function include nulls? Consider the following example from my source table: …

mysql group-concat

Using COUNT in GROUP_CONCAT

This is my table: id | fk_company ------------------- 1 | 2 2 | 2 3 | 2 4 | 4 5 | 4 6 | 11 7 | 11 8 | 11 9 | 12 The result I want should be string "3, 2, 3, 1" (count of items that belong …

mysql sql count group-concat

MySQL group_concat with where clause

I got this problem with Group_Concat and a where filter. In my table i got module names which are …

mysql sql where group-concat clause

MySQL GROUP_CONCAT escaping

(NOTE: This question is not about escaping queries, it's about escaping results) I'm using GROUP_CONCAT to combine multiple rows …

mysql escaping group-concat

LEFT JOIN after GROUP BY?

I have a table of "Songs", "Songs_Tags" (relating songs with tags) and "Songs_Votes" (relating songs with boolean like/…

mysql join group-by group-concat

SELECT with GROUP_CONCAT, GROUP BY, HAVING

I Have table with odd_id and i want to select combinations for different ticket_id's. Here's my query: SELECT …

mysql select group-by group-concat having

mysql workbench "Lost connection to mysql server"

First I need to indicate that I ran the sql file for the Wikipedia dump on my machine, and to …

mysql timeout group-concat

What is the opposite of GROUP_CONCAT in MySQL?

I seem to come against this problem a lot, where I have data that's formatted like this: +----+----------------------+ | id | …

mysql csv format pivot group-concat

Multiple GROUP_CONCAT on different fields using MySQL

I have a query like this: SELECT product.id, GROUP_CONCAT(image.id) AS images_id, GROUP_CONCAT(image.title) …

mysql group-concat

Presto equivalent of MySQL group_concat

I'm new to Presto and looking to get the same functionality as the group_concat function in MySQL. Are the …

mysql presto group-concat trino