Cast as INT(11) instead of DECIMAL 11,0 in a view I have a view with a column defined as:

IFNULL(priority.id, 2) priority_id, ...


where priority.id has type INT(11), however the resulting view column has type:

DECIMAL(11,0)


How do I get the resulting column to retain the INT(11) type?
Decimal(n,0) still treated as integer in mysql 5.0.3 and above. 

Decimal (n,0) is a fixed point that did not has fractional part. 
So it is safe. 

The only different int(11) with decimal(11,0) is the maximum range of number. where as the decimal has bigger range than integer 

See MySQL numeric type overview