0

when i import us.txt file it seems to have excessive tabs. For eg, the very first row of us.txt has 3 tabs after admin_name3. This leads to the latitude field being left empty and the longitude field is filled with the latidude info whilst the accuracy field then gets longitude. I tried importing US.txt again but the same problem happens. When i copy the US.TXT file into my database, i get this : "expected 11 columns but found 12 - extras ignored"

Hopefully the images attached explain this better.

enter image description here

enter image description here

What could be causing this?

0

Sorry that was my bad. I double checked 10 times but was blinded. I missed the postal code column.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .