Mysql bigint to int

Question

Anybody knows how to convert a big int to int in a MySQL stored procedure.

1. Solution in this posthttp://stackoverflow.com/questions/11595217/convert-bigint-unsigned-to-int is not working as I tried:

set @x=BigToInt(2147483649); ERROR 1264 (22003): Out of range value for column

2. I tried this and it doesn't work either:

   DELIMITER // DROP FUNCTION IF EXISTS BigToInt;

   CREATE FUNCTION BigToInt (n BIGINT) RETURNS INTEGER begin DECLARE result INTEGER default 0; set result = CAST(n as SIGNED); return result; end// DELIMITER ;

it gives me same error as #1.

Answer 1

Other option:

DELIMITER //
CREATE FUNCTION BigToInt (n BIGINT) RETURNS VARCHAR(50) 
begin 
DECLARE result VARCHAR(50) default 0; 
set result = CAST(n as signed);
return result;
end
// DELIMITER ;

This will accept a long int but limit to 19 value only.

Integer has a maximum value