13th Apr 2021, 8:19 AM
Prafull Epili
Prafull Epili - avatar
11 Answers
+ 1
Why only number column value changed? I don't understand
13th Apr 2021, 9:53 AM
Prafull Epili
Prafull Epili - avatar
+ 1
Prafull Epili Don't copy answer when you want to mention.. To mention someone in answer just use @ and type name.
13th Apr 2021, 10:22 AM
A͢J
A͢J - avatar
0
Prafull Epili What data type you choose for Phone number?
13th Apr 2021, 8:41 AM
A͢J
A͢J - avatar
0
Prafull Epili What data type you choose for Phone number? int
13th Apr 2021, 9:37 AM
Prafull Epili
Prafull Epili - avatar
0
Prafull Epili Use VARCHAR and see.
13th Apr 2021, 9:38 AM
A͢J
A͢J - avatar
0
Prafull Epili Use VARCHAR and see. First i had used varchar then its shown error that why i changed it int.
13th Apr 2021, 9:45 AM
Prafull Epili
Prafull Epili - avatar
0
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.
13th Apr 2021, 9:50 AM
A͢J
A͢J - avatar
0
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
13th Apr 2021, 10:09 AM
A͢J
A͢J - avatar
0
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.
13th Apr 2021, 10:11 AM
A͢J
A͢J - avatar