+ 1

How can I use long int type in mysql

I have to declare a field for mobile number...but the size of interest is not enough for that.so how can I use long int or any other type to accommodate mobile number.

30th Aug 2017, 5:01 AM
Payal
2 Answers
+ 1
INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT. try this
31st Aug 2017, 8:49 AM
Kalpit Vyas
Kalpit Vyas - avatar
0
since the mobile number usually start with 0 or + so I think the string type should be used here. any comments?
1st Sep 2017, 2:10 AM
Than Phan
Than Phan - avatar