[Pugged] mysql

[Tim Perdue]

Dave J. Hala Jr. wrote:
> I'm running mysql on RH8.0
> 
> I've got a table that has a field called AMT that is decimal(10,2) This
> field currently has a value of -6500.00 If I do an update, no matter
> what value I stick in here mysql makes it negative.
> 
> I did an insert and created and new record in this table, during that
> insert I put the value 100 in the AMT field. Unfortunately it stores
> that value as -100 
> 
> It seems like mysql has decided that EVERY value in this field in this
> table should be negative no matter what. 
> 
> Anyone got any ideas?

have you tried something like:

update foo set amt = (amt*-1)

just to see what it would do?

I've had fields always be Positive, since they were unsigned, but all 
negative is odd.

Tim