是否可以在 linux 中将 mysql 表名从小写转换为大写? [英] Is it possible to convert mysql table names from lowercase to uppercase in linux?
问题描述
我从 Windows 导入了一个数据库到 linux,所有的表名都是小写的.
I imported a database from Windows to linux and all the tables names are in lowercase.
有没有办法在linux中将mysql表名从小写转换成大写?
Is there a way to convert the mysql table names form lowercase to uppercase in linux?
非常感谢您提供的任何建议.
Thanks a lot for any suggestion provided.
推荐答案
我假设您以大写形式处理表名,这在 Windows 中有效,但由于区分大小写而不再适用于 Linux.
I am assuming you are addressing the table names in uppercase, which worked in Windows but no longer works on Linux because of case sensitivity.
您可以重命名每个数据库.但是,如果您有权访问 mySQL 配置,您还应该能够 将 --lower-case-table-names
设置为 1
.
You could rename each database. However, if you have access to the mySQL configuration, you should also be able to set --lower-case-table-names
to 1
.
我没有使用该选项的经验,但根据手册,它使 mySQL 对表不区分大小写,就像 Windows 上的默认设置一样.
I have no experience with the option, but according to the manual, it makes mySQL behave case-insensitively towards tables, as it does by default on Windows.
这篇关于是否可以在 linux 中将 mysql 表名从小写转换为大写?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!