MySQL 数据库中列名中的连字符
可能这个问题以前有人回答过，但我找不到.
May be this question has been answered before but I couldn't find it.
我使用的是 2/3 年旧的 MySQL 数据库，它的列名中有连字符.当我尝试在我的 Java 代码中使用这些名称时，这些名称在连字符处被破坏(例如 air_port 变为 air)，因此找不到.我尝试在我的代码中将连字符替换为下划线，希望数据库可以平等地对待它们，但这不起作用.
I am using a 2/3 yr old MySQL database which has hyphens in its column names. When I try to use these names from my Java code, the names are broken at the hyphen (e.g. air_port becomes air) and thus are not found. I tried replacing hyphens to underscores in my code hoping that the DB might treat them equally but that doesn't work.
如何转义连字符或如何访问这些列?这可能是正在使用的字符集的问题吗?
How can I escape the hyphen or how can I access these columns ? Could this be an issue of the character set being used ?
推荐答案
将名称括在 `back-ticks` 内
enclose the names within `back-ticks`
相关文章