CODEWITHSUNDEEP
mysqlsql
Chia Yong
Chia Yong

Reputation: 1

Merging two rows into one row with MYSQL

ID        Column1        Column2        Column3
1         data1                         data3
1                        data2

from table above, may I perform a single query to get this? :

ID        Column1        Column2        Column3
1         data1          data2          data3

Upvotes: 0

Views: 94

Answers (2)

Richard Inglis
Richard Inglis

Reputation: 5958

SELECT
  GROUP_CONCAT(Column1) AS Column1,
  GROUP_CONCAT(Column2) AS Column2,
  GROUP_CONCAT(Column3) AS Column3
FROM table
GROUP BY ID

Upvotes: 1

Dan Grossman
Dan Grossman

Reputation: 52372

SELECT
  MAX(Column1) AS Column1,
  MAX(Column2) AS Column2,
  MAX(Column3) AS Column3
FROM
  table
GROUP BY
  ID

Upvotes: 2

Related Questions