使用mysql在int长度大于11时插入错误的值

Continue from this question ,

I have a table called customer_report id[int(11)],customer_id[int(5)] in Mysql while insertng values into the table the customer_id entered wrongly as 2147483647.

My query as below :

insert into customer_report (id,customer_id) 
values('','99999999999')

Whats wrong with this ?

Anyone help please .

Thank in advance.

please change the customer_id structure to bigint or do int(11)