Hi,
Rules relating to the names of "objects" MySQL databases, tables, columns, etc.
- Length of 64 characters.
- Some characters (particularly space) are either banned or discouraged; to avoid any problems, do not use diacritical characters, use letters a-z, digits, and the underscore (_); do not start with a digit and adopt a coherent and common policy breaks all your objects. (In my humble opinion, the simplest is the "all lower case", but you can adopt the type "Own Name", that is to say the first letter capitalized).
- They must not be identical of terms of the SQL language as Create, Use, Select, Join, etc.
--- Uppercase, lowercase ---
The rules on the case (that is to say, the choice between upper and lower case) change with the operating system:
- The keywords of SQL and column names are case-insensitive, that is to say, they can be written in uppercase or lowercase.
- The names of tables and databases are:
- Sensitive if MySQL is installed on Linux
- Insensitive if MySQL is installed on Windows
This difference is due to the fact that MySQL records databases and tables as files; Windows is case insensitive file names, while Linux is sensitive.
As can change provider and thus change the operating system, it is best to always consider the names of MySQL as sensible objects, so that queries run regardless of the operating system.
By using the same rules for variable names and PHP files, one is freed of error.
---------------------------------------------------------------
Documentation Apache -
Documentation PHP -
Documentation MySQL -
Wampserver install files & addons