Issue with bigint unsigned
Posted: Sun Mar 26, 2006 2:30 am
Can anyone help me with this...
I have a field
ratingtotal bigint unsigned
The issue is that when the field value is 10 and I use the following query
UPDATE table
set ratingtotal = ratingtotal - 20
WHERE...
The above case is hypothetical.... my issue is that when I do this, MySQL instead of assigning 0 to the field, it assigns the highiest value of BIGINT - 20.
I am totally stumped....
Thanks for reading.
I have a field
ratingtotal bigint unsigned
The issue is that when the field value is 10 and I use the following query
UPDATE table
set ratingtotal = ratingtotal - 20
WHERE...
The above case is hypothetical.... my issue is that when I do this, MySQL instead of assigning 0 to the field, it assigns the highiest value of BIGINT - 20.
I am totally stumped....
Thanks for reading.