Wrong value insert while int length above 11 using mysql

Question

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.

You have to increase the length of customer_id.

BenM
– BenM

2013-04-03 10:45:30 +00:00
Commented Apr 3, 2013 at 10:45 — BenM
– BenM, Commented Apr 3, 2013 at 10:45
change column int to bigint

Dieepak
– Dieepak

2013-04-03 10:46:12 +00:00
Commented Apr 3, 2013 at 10:46 — Dieepak
– Dieepak, Commented Apr 3, 2013 at 10:46

Praveen kalal · Accepted Answer · 2013-04-03 10:45:10Z

1

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

answered Apr 3, 2013 at 10:45

Praveen kalal

2,0994 gold badges20 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

tip_top Over a year ago

I changed to bigint its solved but whats the problem why its not truncate the value as varchar when int(5) or int(11)

Praveen kalal Over a year ago

there is some range for integer

Praveen kalal Over a year ago

help.scibit.com/mascon/masconMySQL_Field_Types.html your issue resolved? then accept the answer

Collectives™ on Stack Overflow

Wrong value insert while int length above 11 using mysql

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related