MysqlDataTruncation: Data truncation: out of range value for column 'agentID' on line 4

In the storage procedure I am using a temporary table, agentID int (11) and inserting this value in the agentID field 9999999999, works with server version: 5.5.29 MySQL Community Server (GPL). Now I am porting to MySQL 5.6, this does not work, the problem is displayed here (Data truncation: value out of range for "agentID" on line 4). Please explain to me the reason why the MySQL server behaves differently, this is important.

+3


source to share


1 answer


MySql 5.6 support Integer upto: 2147483647



enter image description here

+2


source







All Articles