Why its add wrong value? All values are right accept mobile_no

Question

https://www.sololearn.com/post/1034847/?ref=app

https://www.sololearn.com/post/1034848/?ref=app

Answer 1

Here is your answer

https://stackoverflow.com/questions/12726037/not-able-to-inserting-correct-mobile-number-to-phpmyadmin-using-php

https://stackoverflow.com/questions/10255724/incorrect-integer-2147483647-is-inserted-into-mysql

Thank so much for your help..😀😀

Answer 2

Why only number column value changed? I don't understand

Answer 3

Prafull Epili

Don't copy answer when you want to mention.. To mention someone in answer just use @ and type name.

Answer 4

Prafull Epili

What data type you choose for Phone number?

Answer 5

Prafull Epili

What data type you choose for Phone number?

int

Answer 6

Prafull Epili

Use VARCHAR and see.

Answer 7

Prafull Epili

Use VARCHAR and see.

First i had used varchar then its shown error that why i changed it int.

Answer 8

Prafull Epili

It should not give error but anyway there is two more datatype to Store mobile number that is BIGINT and Text. You can try them.

Answer 9

Here is your answer

https://stackoverflow.com/questions/12726037/not-able-to-inserting-correct-mobile-number-to-phpmyadmin-using-php

https://stackoverflow.com/questions/10255724/incorrect-integer-2147483647-is-inserted-into-mysql

Answer 10

The largest value for data type INT is 2147483647. If the number you're inserting is bigger than 2147483647, then it will cause the problem. For solution, change the data type from INT to BIGINT as BIGINT has a maximum value of 9223372036854775807.

https://dev.mysql.com/doc/refman/5.7/en/integer-types.html

Answer 11

Prafull Epili

Your Mobile Number start with mostly 6-7-8-9 digit but Int data type has size 2^31 means (-2147483648 to 2^31-1)

That's why it's inserting 2147483648 because mobile number is overflowing this range.. So to insert number you can use BIGINT which has size 2^63 to 2^63-1 or you can use VARCHAR.