At 23:11 +0000 10/24/01, [EMAIL PROTECTED] wrote: >Hello, > >I am wondering if there is a way to make automatic computations into >a particular column, for instance: > >Table ONE has column's A, B and C. > >When I post data to A and B, can I have C automatically calculate A >/ B and post that answer onto column C?
No. But you can set C to the result of computation yourself: INSERT INTO tbl_name (A,B,C) VALUES (a_value,b_value,a_value/b_value) > >Again, I want this to happen automatically, I don't want to have to >issue a SELECT statement for this procedure. > >Thanks for your help. > >David > -- Paul DuBois, [EMAIL PROTECTED] --------------------------------------------------------------------- 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
