[snip] Now I need to put data in a db but the problem is with this calculated data. A friend of mine that use Oracle told me that I could define a field like field1 = field2 + field3, but I can't discover this option in Mysql.
It's possible to make it ? Any other idea about it ? [/snip] Have you tested this, you can... SELECT (field1 + field2) AS field3 FROM tableA ...which means that you can INSERT INTO tableB (field3) SELECT (field1 + field2) FROM tableA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]