country-codes icon indicating copy to clipboard operation
country-codes copied to clipboard

MYSQL hyphen problem

Open Hexodus opened this issue 7 years ago • 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 avatar Mar 21 '17 22:03 Hexodus

@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

Mikanebu avatar Jul 28 '17 19:07 Mikanebu