pjrat
-
Posts
2 -
Joined
-
Last visited
Never
pjrat's Achievements
Newbie (1/5)
0
Reputation
-
Hi (biopv) Thanks for your answer, but I really made a silly mistake. One of the fields was NULL and this stopped it from running the query. Once I changed the field to NOT NULL and added a 0.0 default, it worked well. Thanks, Pat.
-
Hi Trying to learn MysQL and have a calculation problem. I want a query to do the following example (all are floats with numbers to add) - SELECT a+b+c+d+e AS result FROM table The above obviously dosen\'t work, where, this line below does - SELECT a+b AS result FROM table (and gives me the total of the two fields). Can I calculate all five fields somehow and create a result field? Thanks in advance - Pat J