Hi,
--- Rules for MySQL "object" names: bases, tables, columns, etc.
- Maximum length of 64 characters.
- Some characters (especially space) are either forbidden or discouraged; to avoid all problems, don't use diacritical characters, use letters from a to z, numbers and underscore (_); don't start with a number and adopt a consistent and common case policy for all your objects. (In my humble opinion, the simplest is "all lowercase", but you can adopt the "Proper Name" type, i.e. the first letter in upper case).
- They should not be identical to SQL terms, such as Create, Use, Select, Join, etc.
--- Upper case, lower case ---
The case rules (i.e. the choice between upper and lower case) change with the operating system:
- SQL keywords and column names are case insensitive, i.e. they can be written in either upper or lower case.
- Table and database names are :
-- case sensitive if MySQL is installed on Linux
-- case insensitive if MySQL is installed on Windows
This difference is due to the fact that MySQL stores databases and tables as files, and Windows is case insensitive for file names, while Linux is case sensitive.
Since you can change your host and therefore your operating system, it is best to always consider the names of MySQL objects as sensitive, so that queries work regardless of the operating system.
By using the same rules for the names of variables and PHP files, you can avoid potential errors.
---------------------------------------------------------------
Documentation Apache -
Documentation PHP -
Documentation MySQL -
Wampserver install files & addons