datasets/country-codes

MYSQL hyphen problem

Hexodus opened this issue · 1 comments

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.

@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