On Fri, Jan 21, 2005 at 07:38:59PM +0100, Javier wrote:
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.
You can't define a
To the best of my knowledge MySQL does not have a way to do this on the
fly such that a field value is contigent upon the values of other fields
in the table.
Does it have to be stored in the database at all? Seems to me that
calculated values often are best handled at query time rather than
[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
Hi,
How do I set up a field called Minutes which has the (default) value, where
round((SessionTime+30)/60) = Minutes
Is it possible to set this up? In other databases (Alpha Five) I would have
used a Calculated Field attribute to achieve this.
Can MySql handle it.. ???
In SQL