Should I capitalize each table name e.g. (Members) and field name (Forename) or leave them as lower cases?
Thank you!
r937
April 8, 2013, 7:16pm
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…
In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case sensitivity of the underlying operating system plays a part in the case sensitivity of database and table names. This means database and table names are not case sensitive in Windows, and case sensitive in most varieties of Unix.
– http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
Thank you. I’m using MySQL. So I will declare using lower cases.
r937:
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…