Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MYSQL hyphen problem #52

Open
Hexodus opened this issue Mar 21, 2017 · 1 comment
Open

MYSQL hyphen problem #52

Hexodus opened this issue Mar 21, 2017 · 1 comment

Comments

@Hexodus
Copy link

Hexodus commented Mar 21, 2017

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
Copy link
Member

@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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants