MySQL TOTAL

[Arc]

I beleive the way to total a filed in MySQL is to use TOTAL('TheFIeld') as FieldTotal right?

Anyway, I am wondering if I insert a negitive number (-234) into a field and use TOTAL will it cause an error or will it subtract that amount from the total?

I am pretty much stuck inserting either whole numbers or neg numbers(-234) into this field and I need a way to get a total of all values int his field.

Thanks!😃

[onion2k]

Its SUM(field) as total, but yeah, it'll work. Remember that an INT field must be set as signed in order to store negative numbers.

[Arc]

OK, cool thanks mate!😃