parfaitmacaron — 2013-04-08T12:38:43-04:00 — #1
Should I capitalize each table name e.g. (Members) and field name (Forename) or leave them as lower cases?
r937 — 2013-04-08T15:16:17-04:00 — #2
declare all your names in lower case
some database systems (you did not say which you were using) disregard identifier case, and you can code the names either way, in fact, you can mix them up from one query to the next
Members, MEMBERS, members, mEmBeRs, ...
however, this is not always true...
parfaitmacaron — 2013-04-08T17:22:47-04:00 — #3
Thank you. I'm using MySQL. So I will declare using lower cases.