kalles

Hello

I'm rather new when it comes to databases and I was hoping that someone
could help me out! I was just wondering is it possible to make a field in
MySQL dbase wich is a total of two other fields.

ie.

field_XX is a sum of field_1 and field2

Thanks

-Kalle


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

ajackman

Kalle,
The usual way to do this is to create the table with the 2 real fields
and then use a query to 'create' the sum field at run time. For example
assume you have this table:

create table my_table (
field_1 int(9),
field_2 int(9)
);

then you can write this query:
SELECT field_1, field_2, (field_1 + field_2) AS my_sum FROM my_table;

This print 3 'fields', the third one is called my_sum and contains the
sum of the other two (the AS keyword gives a field a name).

Hope this helps,
Andy.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw