search

datasets / country-codes

Comprehensive country code information, including ISO 3166 codes, ITU dialing codes, ISO 4217 currency codes, and many others
https://datahub.io/core/country-codes
896 stars 575 forks source link

MYSQL hyphen problem #52

Open Hexodus opened 7 years ago

Hexodus commented 7 years ago

It's really great that you provide this data to us all - thanks a lot - this helps very much with my project ;)

There is a general problem when using this data with MYSQL statments. Hyphens in column names are causing trouble. Usually you can enclose them in backticks - except when using JOIN command - then there's always an error. No matter if using backticks or brackets to enclose the column name. The only way is to alter columns name to use underscores instead of hyphens. Please consider it in your work.

Mikanebu commented 7 years ago

@Hexodus Thanks for your contribution. It is a good recommendation. We have other datapackages with hyphen sign in the column names. We will take this into account for the future data packages