Hi People. SQL problem:

given a table where each column is a number, let's say that I wish to
create a second table where columns are the sum of specific columns of the
first, i.e.:

col_1 + col_2 + col_3 + col_4     ---->  col_1 of second table
col_5 + col_6 + col_7 + col_8     ---->  col_2 of second table
col_9 + col_10 + col_11 + col_12  ---->  col_3 of second table
....                                     .....

In Oracle I could create a view from the initial table, what about MySQL?
Do I really have to loop through each row to build the second table?

Thanks in advance



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to