Is this update possible in MySQL?

[Fagyal Csongor]

Hi,
I have a table that looks like this:
table events:
id : INT
remoteid: INT
type : enum ('a','b','c')
value: INT
when: DATE
For each 'remoteid' and 'when', there are 3 rows with type=a,b,c 
respectively. (Bad table design that is...) I would like to shorten this 
table so it will look like this:
id : INT
remoteid: INT
value_a: INT
value_b: INT
value_c: INT
when: DATE

My idea is to dump this table (it is a quite big table with 10M+ rows), 
write a perl script to "concatenate" corresponding 'when'+'remoateid' 
fields, and load the resulting file into another table.

Just fo curiosity: can this processing be written in pure MySQL?
Thank you,
- Csongor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]