Do you have a really good reason to store a computed value? It's only useful if you will perform a search on the column, else you could just do the subtraction when you SELECT columns A and B.
- Ashish On Sat, Aug 21, 2010 at 11:55 AM, <b...@qxhp.com> wrote: > Hello, > > For simplicity's sake, let's say I have three fields, A, B and C, all > of which are integers. I'd like the value of C to be equal to A less B > (A-B). Is there a way I can perform this calculation? I'm guessing it > would happen when I INSERT a row and specify the values for A and B. > Feel free to direct me to the fine manual I should have read. > > Thank you. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=ashish.mukher...@gmail.com > >