Files and folders in
Unix platforms in general are case sensitive making
MariaDB table names in these platforms to also be case sensitive.
Windows however does not enforce case sensitivity for its folders and files causing
MariaDB table names in
Windows to not be case-sensitive.
This means that a table named
tablename is just the same as
TableName and using any of these 2 will not make any difference in your query. This is due to the fact that
MariaDB stores and query database tables based on the filesystem's filename and folder.
You can use case-insensitive table name for
Linux or other
Unix systems by following these steps:
MariaDBconfiguration file using your favourite editor.
Add the line if it doesn't already exist.
Share your thoughts, suggest corrections or just say Hi. Login not required.