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
`
PREVIOUS
NEXT
Tagged:
#concat
ADD COMMENT
Topic
COMMENT
Name
5+8 =
Submit