CODEWITHSUNDEEP
mysqlsqlphpmyadminsql-insert
Ramu PL
Ramu PL

Reputation: 9

Wrong data inserting in MySql

Below is my query

insert into sms (mobile) values ("255786786072")

The value which I am getting in the "mobile" field in table is 2147483647. data type of "mobile" field is varchar(15).

Any suggestion.

Upvotes: 0

Views: 470

Answers (1)

John Woo
John Woo

Reputation: 263703

I'm pretty sure that it's not varchar because 2147483647 is the maximum value of signed INT. Change it to varchar to work as desired.

Upvotes: 5

Related Questions