I have table with two int unsigned field(a,b). I run statement like this:
SELECT a-b AS x
When the result became negative, it returns a big strange number. I know it has something to do with unsigned fields, but my question is how can i get the negative number without changing tables?
And another thing is i alter table, and remove unsigned property, but the result didnt change, i think i should recreate the table and insert the data again to get the right neg numbers?

SELECT CAST(a-b AS SIGNED) AS x