Thanks ----- Original Message ----- From: "Adam Nelson" <[EMAIL PROTECTED]> To: "'Andy Jackman'" <[EMAIL PROTECTED]>; "'MySQL'" <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2003 12:26 AM Subject: RE: dbase calculations
> 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]