DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
use group_concat in concat
SELECT CONCAT(`Name`, ':', GROUP_CONCAT(`Value` SEPARATOR ',')) AS `Name` FROM table GROUP BY `Name`
Source by database.guide #
PREVIOUS
NEXT
Tagged:
#concat
ADD COMMENT
Topic
COMMENT
Name
3+9 =
Submit