• <i id='GBb5c'><tr id='GBb5c'><dt id='GBb5c'><q id='GBb5c'><span id='GBb5c'><b id='GBb5c'><form id='GBb5c'><ins id='GBb5c'></ins><ul id='GBb5c'></ul><sub id='GBb5c'></sub></form><legend id='GBb5c'></legend><bdo id='GBb5c'><pre id='GBb5c'><center id='GBb5c'></center></pre></bdo></b><th id='GBb5c'></th></span></q></dt></tr></i><div id='GBb5c'><tfoot id='GBb5c'></tfoot><dl id='GBb5c'><fieldset id='GBb5c'></fieldset></dl></div>

    1. <legend id='GBb5c'><style id='GBb5c'><dir id='GBb5c'><q id='GBb5c'></q></dir></style></legend>

      <small id='GBb5c'></small><noframes id='GBb5c'>

      <tfoot id='GBb5c'></tfoot>

        <bdo id='GBb5c'></bdo><ul id='GBb5c'></ul>

      1. MySQL 数据库中列名中的连字符

        时间:2023-05-24

          • <i id='q1BCt'><tr id='q1BCt'><dt id='q1BCt'><q id='q1BCt'><span id='q1BCt'><b id='q1BCt'><form id='q1BCt'><ins id='q1BCt'></ins><ul id='q1BCt'></ul><sub id='q1BCt'></sub></form><legend id='q1BCt'></legend><bdo id='q1BCt'><pre id='q1BCt'><center id='q1BCt'></center></pre></bdo></b><th id='q1BCt'></th></span></q></dt></tr></i><div id='q1BCt'><tfoot id='q1BCt'></tfoot><dl id='q1BCt'><fieldset id='q1BCt'></fieldset></dl></div>
              1. <small id='q1BCt'></small><noframes id='q1BCt'>

                  <bdo id='q1BCt'></bdo><ul id='q1BCt'></ul>

                  <legend id='q1BCt'><style id='q1BCt'><dir id='q1BCt'><q id='q1BCt'></q></dir></style></legend>
                  <tfoot id='q1BCt'></tfoot>

                    <tbody id='q1BCt'></tbody>
                • 本文介绍了MySQL 数据库中列名中的连字符的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  限时送ChatGPT账号..

                  可能这个问题以前有人回答过,但我找不到.

                  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`

                  这篇关于MySQL 数据库中列名中的连字符的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:MySQL 分组依据和其他列的总和值 下一篇:使用“like"优化 MySQL 搜索和通配符

                  相关文章

                • <i id='PEkHa'><tr id='PEkHa'><dt id='PEkHa'><q id='PEkHa'><span id='PEkHa'><b id='PEkHa'><form id='PEkHa'><ins id='PEkHa'></ins><ul id='PEkHa'></ul><sub id='PEkHa'></sub></form><legend id='PEkHa'></legend><bdo id='PEkHa'><pre id='PEkHa'><center id='PEkHa'></center></pre></bdo></b><th id='PEkHa'></th></span></q></dt></tr></i><div id='PEkHa'><tfoot id='PEkHa'></tfoot><dl id='PEkHa'><fieldset id='PEkHa'></fieldset></dl></div>

                  1. <legend id='PEkHa'><style id='PEkHa'><dir id='PEkHa'><q id='PEkHa'></q></dir></style></legend>
                  2. <tfoot id='PEkHa'></tfoot>
                      <bdo id='PEkHa'></bdo><ul id='PEkHa'></ul>

                      <small id='PEkHa'></small><noframes id='PEkHa'>