Are database names case-sensitive?

Question

Although database, table, and trigger names are not case-sensitive on some platforms, you should not refer to one of these using different cases within the same statement.

Are DB names case sensitive?

Database, table, table aliases and trigger names are affected by the systems case-sensitivity, while index, column, column aliases, stored routine and event names are never case sensitive. Log file group name are case sensitive.

Are MySQL databases case sensitive?

Table names are stored in lowercase on disk and name comparisons are not case sensitive. MySQL converts all table names to lowercase on storage and lookup.

Are SQL column names case sensitive?

The SQL Keywords are case-insensitive ( SELECT , FROM , WHERE , etc), but are often written in all caps. However in some setups table and column names are case-sensitive.

Expert · Answer