MySQL INT data type - TechRepublic
Question
June 23, 2010 at 01:22 AM
sumitha mani

MySQL INT data type

by sumitha mani . Updated 16 years ago

Hi,

I have started working in MySQL recently. I tried to import an excel into mysql table. everything is fine but for one column. I have defined a column called ‘telephone_no’ with int(30) as datatype. the data in the table after importing is absurd for a few records.. rest of the records seem fine. Dont know what is wrong. for example, i tried to insert the number ‘2825861214’ but i get this number ‘2147483647’.. Please could anyone tell me what the problem and solution is ?

thank you

This discussion is locked

All Comments