mysql判断一行是否存在负数

mysql判断一行是否存在负数？可以。调用mysql的存储过程传参给smallint类型变量,总是出现out of range value的错误,刚开始用C数值转换方式的二进制位转换思...

CREATE PROCEDURE testproc (IN v_i integer )

BEGIN

if v_i >0 then

select v_i as '负数'

else

select v_i as '正数'

end if

END$$

delimiter

---