How to merge empty field with the following value in MySQL?

Question

Possible Duplicate:
Merge two rows in SQL

I have the following values in table:

---------------------
row1 | row2 | row3
---------------------
val1 |      |
     | val2 | 
     |      | val3

How do I merge these rows?

$qu = mysql_query("SELECT * FROM `table`");

while($row = msyql_fetch_assoc($qu)){
$rowone = $row['row1'];
$rowtwo = $row['row2'];
$rowtre = $row['row3'];

echo $rowone." ".$rowtwo." ".$rowtre;
}

I want this to return

val1 val2 val3

I have a theory about how this is possible but I was wondering if there is a more straightforward method.

score 2 · Accepted Answer · answered Sep 29 '12 at 10:01

2

use an aggregate function on all columns.

SELECT MAX(row1), MAX(row2), MAX(row3)
FROM tableName

answered Sep 29 '12 at 10:01

John Woo

258,903
69
498
492

score 0 · Answer 2 · answered Sep 29 '12 at 10:03

0

SELECT concat(col1,col2,col3) as colname
FROM tableName

answered Sep 29 '12 at 10:03

Vikram Jain

5,498
1
19
31

1

He'll get "value1 NULL NULL", "NULL value2 NULL", "NULL NULL value3" – Adriano Repetti Sep 29 '12 at 10:05
SELECT concat(ifnull(col1,''),ifnull(col2,''),ifnull(col3,'')) as colname FROM tableName – Vikram Jain Sep 29 '12 at 10:07

How to merge empty field with the following value in MySQL?

2 Answers2