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.
Kalle Saarinen wrote:
>
> 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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
