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

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

    • <bdo id='Dm6rK'></bdo><ul id='Dm6rK'></ul>
    <legend id='Dm6rK'><style id='Dm6rK'><dir id='Dm6rK'><q id='Dm6rK'></q></dir></style></legend>

    1. <tfoot id='Dm6rK'></tfoot>

      MySQL自动将字符串转换/转换为数字?

      MySQL automatically cast/convert a string to a number?(MySQL自动将字符串转换/转换为数字?)
        <tbody id='ayO0T'></tbody>
      <legend id='ayO0T'><style id='ayO0T'><dir id='ayO0T'><q id='ayO0T'></q></dir></style></legend>
              <tfoot id='ayO0T'></tfoot>
              • <bdo id='ayO0T'></bdo><ul id='ayO0T'></ul>
              • <i id='ayO0T'><tr id='ayO0T'><dt id='ayO0T'><q id='ayO0T'><span id='ayO0T'><b id='ayO0T'><form id='ayO0T'><ins id='ayO0T'></ins><ul id='ayO0T'></ul><sub id='ayO0T'></sub></form><legend id='ayO0T'></legend><bdo id='ayO0T'><pre id='ayO0T'><center id='ayO0T'></center></pre></bdo></b><th id='ayO0T'></th></span></q></dt></tr></i><div id='ayO0T'><tfoot id='ayO0T'></tfoot><dl id='ayO0T'><fieldset id='ayO0T'></fieldset></dl></div>

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

                本文介绍了MySQL自动将字符串转换/转换为数字?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                问题描述

                限时送ChatGPT账号..

                MySQL 是否自动将字符串转换为数值?
                这种转换是如何工作的?

                Does MySQL automatically casting\converting the string to numeric value?
                How does that conversion works?

                • '1234'=1234 ?
                • '1abc' = 1 ?
                • 'text' = 1 ?

                鉴于 units.id 是 bigint 类型,将如何解释此查询?

                Given that units.id is of bigint type, how this query will be interpreted?

                SELECT table.* 
                FROM table 
                WHERE id='text'
                

                推荐答案

                前三个问题的答案是:是、是和否.

                The answers to your first three questions are: yes, yes, and no.

                当字符串'text'被转换为数字时,它变成了值0.

                When the string 'text' is converted to a number, it becomes the value 0.

                描述类型转换的文档在这里.

                The documentation that describes type conversion is here.

                对于您的查询:

                SELECT table.* 
                FROM table 
                WHERE id='text';
                

                此规则摘录自文档:

                在所有其他情况下,参数作为浮点(实数)数进行比较.

                In all other cases, the arguments are compared as floating-point (real) numbers.

                换句话说,这实际上相当于:

                In other words, this is actually equivalent to:

                WHERE id = 0.0
                

                这篇关于MySQL自动将字符串转换/转换为数字?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                相关文档推荐

                Can#39;t Create Entity Data Model - using MySql and EF6(无法创建实体数据模型 - 使用 MySql 和 EF6)
                MySQL select with CONCAT condition(MySQL选择与CONCAT条件)
                Capitalize first letter of each word, in existing table(将现有表格中每个单词的首字母大写)
                How to retrieve SQL result column value using column name in Python?(如何在 Python 中使用列名检索 SQL 结果列值?)
                Update row with data from another row in the same table(使用同一表中另一行的数据更新行)
                Exporting results of a Mysql query to excel?(将 Mysql 查询的结果导出到 excel?)
                • <small id='t3KMh'></small><noframes id='t3KMh'>

                      <tbody id='t3KMh'></tbody>

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

                    1. <tfoot id='t3KMh'></tfoot>

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