mysql - 大小写在 MySQL 中重要吗？

Question

我找不到关于 MySQL 查询的哪一部分区分大小写的引用。

是否概述了大写的重要性？

具体来说，这些是否区分大小写:

• 数据库名称
• 表名
• 专栏名称

它与操作系统相关吗？可配置？还是其他一些因素的组合？

Answer 1

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.

.

The lower_case_table_names system variable also affects how the server handles identifier case sensitivity

您可以阅读有关该主题的更多信息 here .