Hi all:

Imagine that I have a table like this one:

---------

The firts column has alphanumeric character and the second one
only has numbers. Let's call it test1. I want to create a table with the
same structure as the previous one which looks like this:

---------

Let's call test2 to this table. The idea is this that:

1) The first column of test2 has the same "objects" in it as test1, but
each one appears only once.

2) For each "object", the number on the second column of test2 is the
sum of all numbers of the second column of test1 which have that
"object" in the first column.

Is it possible to do this within MySQL? I'm not talking about creating
the table, only about filling it up.

Best regards,

Jose Carlos Santos

José Carlos Santos wrote:
Have you ever heard of aggregate functions?
http://dev.mysql.com/doc/refman/5.0/...functions.html

Would this query meet your needs?
select first_column, sum(second_column)
from table_name
group by first_column

It's standard SQL.

ciao
gmax

--
_ _ _ _
(_|| | |(_|>< The Data Charmer
_|
http://datacharmer.org/

On 29-07-2006 16:46, Giuseppe Maxia wrote:

No, I'm a newbie. :-(

I haven't tried it, but it really looks like you solved my problem.
Thanks a lot.

Best regards,

Jose Carlos Santos