I believe views in Oracle (SQL Server? Sybase?) can do this if you need it.
> -----Original Message----- > From: Andy Jackman [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 12:36 PM > To: MySQL > Subject: Re: dbase calculations > > > 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/mysql?> [EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
