This project has moved and is read-only. For the latest updates, please go here.

MySQL on Linux is case sensitive needs some documentation to be revised

Topics: 2. Documentation
Oct 15, 2014 at 8:50 AM
Edited Oct 15, 2014 at 8:52 AM
While windows is not case sensitive, Linux environments are case sensitive.

From the MySQL manual:
Identifier Case Sensitivity

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

To reflect above I would like to suggest to update the MySQL related documentation and documenting proper case.

Fro example the document:

6 Delete monthdata
delete from monthdata

should read
delete from MonthData; (<- should include ";" as well)