Sql

SELECT GROUP_CONCAT(
	CONCAT(
		'{ID:',	ID,
        ',ParentID:', ParentID,
        '}'          
	) SEPARATOR ","
) FROM table

SELECT
    CONCAT(`Name`, ':', GROUP_CONCAT(`Value` SEPARATOR ',')) AS `Name`
FROM table
GROUP BY `Name`

PREVIOUS	NEXT

Code Example
Sql :: postgres float to int
Sql :: pl/sql cursor
Sql :: mariadb alter table add column if not exists example
Sql :: postgres list all triggers
Sql :: oracle create table auto generated primary key
Sql :: change auto increment mysql
Sql :: concat using laravel
Sql :: enable sql server full text indexing
Sql :: Get the Db column names from a SqlDataReader
Sql :: rename column sql
Sql :: run sql file in terminal
Sql :: sql declare table variable
Sql :: how to export only procedures mysql
Sql :: username sql
Sql :: mysql remove html tag
Sql :: get number of table colums in sql query
Sql :: oracle sql select all days between two dates except weekends
Sql :: how to check table exists or not in postgresql
Sql :: change mysql version to 5.7 in ubuntu
Sql :: sql select duplicates based on two columns
Sql :: laravel jwt
Sql :: varchar vs nvarchar sql
Sql :: sum query in sql
Sql :: insensitive case match sqlalchemy
Sql :: run postgresql dump to csv
Sql :: sql change date format
Sql :: mysql group by date
Sql :: xampp mysql version
Sql :: inner join distinct
Sql :: how to get the date diff of 2 dates in the same fieldin sql server