Why shouldn't commas be included in sql field names?
People keep telling me that spaces shouldn't be included in column names.
I was just wondering, why is that? It is an issue I am having with a few
database tables I am creating for school. The field names include Preble
and Darke.
Instead, they need to be "Preble County (OH)" and "Darke County (OH)". If
they were row names, I would just create an ID # column, and natural join
that with a table displaying names that I want them to be ("Darke County
(OH)" instead of "Darke").
However, I have no idea how I can go about changing these names since they
are my field names. Can anyone help me out? Any help would be greatly
appreciated.
No comments:
Post a Comment