Hi everyone!
I'm starting with mysql!
I wish to know if it is possible to make a table that has to columns linked by
a mathematic expression. For example:
My table is "my_tbl";
And it has three colums: column_1, column_2 and column_3;
Every column have int or float values;
And for example, I want that the third column always be
equal to column_1 * column_2;
So when I change a value in column_1 or column_2, then column_3 will be change
imediatly by mysql!
Is that possible?
how can I do it?
Thanks...
Daniel
---------------------------------------------------------------------
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