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