camelCase - no, no, and NO
I've worked in the database realm since 1993. I have worked every major database engine and more projects than you can shake a stick at.
Any casing of column names in the long run is really more trouble than it's worth.
You either have to remember that a certain column name must be selected with double quotes or square brackets (depending on the database engine).
Ex.
select "thisColumnName" from table
or
select [thisColumnName] from table
In the long run, in my experience, you should ALWAYS use underscore between words.
select this_column_name from table
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
camelCase - no, no, and NO
I've worked in the database realm since 1993.
I have worked every major database engine and more projects than you can shake a stick at.
Any casing of column names in the long run is really more trouble than it's worth.
You either have to remember that a certain column name must be selected with double quotes or square brackets (depending on the database engine).
Ex.
select "thisColumnName" from tableor
select [thisColumnName] from tableIn the long run, in my experience, you should ALWAYS use underscore between words.
Ex.
select this_column_name from table