|
`elevation` int(11) DEFAULT NULL, |
I just downloaded ES.txt and try to import it in a geoname table. There was many :"Incorrect integer value: '' for column 'elevation' at row 1 "
It seems at first glance that Either the database is corrupted, or the sql schema should accept a string. Or we should change the import to finetune that field and accept '' leads to NULL
GeoNames-MySQL-DataImport/geonames_db_struct.sql
Line 105 in f849817
I just downloaded ES.txt and try to import it in a geoname table. There was many :"Incorrect integer value: '' for column 'elevation' at row 1 "
It seems at first glance that Either the database is corrupted, or the sql schema should accept a string. Or we should change the import to finetune that field and accept '' leads to NULL