Everyone,

Im trying to INSERT the SUM of the two data from table TEMP_IN and TEMP_OUT

TEMP_IN data

select * from temp_in limit 15
--------------

+--------------+
| cal          |
+--------------+
| 000000014.45 |
| 000000013.95 |
| 000000015.95 |
| 000000016.78 |
| 000000018.92 |
| 000000015.78 |
| 000000015.17 |
| 000000018.28 |
| 000000020.34 |
| 000000015.09 |
| 000000015.06 |
| 0000000017.2 |
| 000000017.98 |
| 000000017.31 |
| 0000000019.2 |
+--------------+
15 rows in set (0.00 sec)

mysql>


TEMP_OUT data

select * from temp_out limit 15
--------------

+--------------+
| cal          |
+--------------+
| 000000014.23 |
| 000000013.62 |
| 000000013.17 |
| 000000012.87 |
| 0000000010.5 |
| 000000014.12 |
| 0000000014.5 |
| 0000000012.2 |
| 000000013.17 |
| 000000013.87 |
| 000000014.31 |
| 000000014.37 |
| 000000013.39 |
| 000000012.75 |
| 000000014.06 |
+--------------+
15 rows in set (0.00 sec)

mysql>


how can make a query that insert the SUM of TEMP_IN+TEMP_OUT and I want it
to be INSERTED to  TEMP_SUM table?

Here's my table definition..

-> ;
--------------
desc temp_sum
--------------

+-------+-------------------------+------+-----+--------------+-------+
| Field | Type                    | Null | Key | Default      | Extra |
+-------+-------------------------+------+-----+--------------+-------+
| cal   | float unsigned zerofill |      |     | 000000000000 |       |
+-------+-------------------------+------+-----+--------------+-------+
1 row in set (0.00 sec)

mysql> desc temp_in;
--------------
desc temp_in
--------------

+-------+-------------------------+------+-----+--------------+-------+
| Field | Type                    | Null | Key | Default      | Extra |
+-------+-------------------------+------+-----+--------------+-------+
| cal   | float unsigned zerofill |      |     | 000000000000 |       |
+-------+-------------------------+------+-----+--------------+-------+
1 row in set (0.00 sec)

mysql>

mysql> desc temp_sum;
--------------
desc temp_sum
--------------

+-------+-------------------------+------+-----+--------------+-------+
| Field | Type                    | Null | Key | Default      | Extra |
+-------+-------------------------+------+-----+--------------+-------+
| cal   | float unsigned zerofill |      |     | 000000000000 |       |
+-------+-------------------------+------+-----+--------------+-------+
1 row in set (0.00 sec)

mysql>


is it possible to make it as a query?...I can make it programmatically
but...is there a short way to make?





R.B.Roa
PhilCom Corporation
Tel. No. 858-xxxx
Mobile No. (63) (919-xxxxxxx)



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to