About two years ago I published a blog post about Generated (Virtual) Columns in MySQL 5.7. Since then, it’s been one of my favorite features in the MySQL 5.7 release. The reason is simple: with the ...

GROUP_CONCAT, LISTAGG or some other name, depending on the SQL dialect, is an aggregation function which takes values from several rows and lists them in a single string, separated by some pre-defined ...