Determine mobile phone number operator, attribution and other information

CREATE TABLEdb_lsxy_ussd.tb_telnum_info (' id 'varchar( +) not NULL, ' mobile 'varchar(Ten)DEFAULT NULLCOMMENT'Phone number prefix', ' Province 'varchar(Ten)DEFAULT NULLCOMMENT'Provinces', ' City 'varchar(Ten)DEFAULT NULLCOMMENT'City', ' Corp 'varchar(Ten)DEFAULT NULLCOMMENT'operators', ' Area_code 'varchar(Ten)DEFAULT NULLCOMMENT'Area Code', ' Post_code 'varchar(Ten)DEFAULT NULLCOMMENT'Postal Code', ' Create_time 'datetime DEFAULT NULL, ' Last_time 'datetime DEFAULT NULL, ' deleted 'int( One)DEFAULT NULL, ' Delete_time 'datetime DEFAULT NULL, ' Sortno 'bigint( -)DEFAULT NULL, ' version 'int( One)DEFAULT NULL,  PRIMARY KEY(' id '),KEY' idx_mobile ' (' Mobile '),KEY' idx_province ' (' Province '),KEY' Idx_area_code ' (' Area_code ')) ENGINE=InnoDBDEFAULTCHARSET=UTF8 COMMENT='Number Information Table';

Table structure as above. Here is the data. Download it directly

Http://pan.baidu.com/s/1pKKP8hX

Determine mobile phone number operator, attribution and other information