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

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

        MySql: Tinyint (2) vs tinyint(1) - 有什么区别?

        时间:2023-06-01
        • <bdo id='d2be2'></bdo><ul id='d2be2'></ul>

            • <legend id='d2be2'><style id='d2be2'><dir id='d2be2'><q id='d2be2'></q></dir></style></legend>

              1. <tfoot id='d2be2'></tfoot>
              2. <small id='d2be2'></small><noframes id='d2be2'>

                  <i id='d2be2'><tr id='d2be2'><dt id='d2be2'><q id='d2be2'><span id='d2be2'><b id='d2be2'><form id='d2be2'><ins id='d2be2'></ins><ul id='d2be2'></ul><sub id='d2be2'></sub></form><legend id='d2be2'></legend><bdo id='d2be2'><pre id='d2be2'><center id='d2be2'></center></pre></bdo></b><th id='d2be2'></th></span></q></dt></tr></i><div id='d2be2'><tfoot id='d2be2'></tfoot><dl id='d2be2'><fieldset id='d2be2'></fieldset></dl></div>
                    <tbody id='d2be2'></tbody>
                  本文介绍了MySql: Tinyint (2) vs tinyint(1) - 有什么区别?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我知道 mysql 中的布尔值是 tinyint (1).

                  I knew boolean in mysql as tinyint (1).

                  今天我看到一个表定义了一个整数,比如 tinyint(2),还有其他的比如 int(4), int(6) ...

                  Today I see a table with defined an integer like tinyint(2), and also others like int(4), int(6) ...

                  integer 和 tinyint 类型的字段中的大小是什么意思?

                  What does the size means in field of type integer and tinyint ?

                  推荐答案

                  表示显示宽度

                  无论您使用 tinyint(1) 还是 tinyint(2),都没有任何区别.

                  Whether you use tinyint(1) or tinyint(2), it does not make any difference.

                  我总是使用 tinyint(1) 和 int(11),我使用了几个 mysql 客户端(navicat、sequel pro).

                  I always use tinyint(1) and int(11), I used several mysql clients (navicat, sequel pro).

                  它根本没有任何意义!我跑了一个测试,上面的客户端甚至命令行客户端似乎都忽略了这一点.

                  It does not mean anything AT ALL! I ran a test, all above clients or even the command-line client seems to ignore this.

                  但是,如果您使用 ZEROFILL 选项,显示宽度 是最重要的,例如您的表格有以下 2 列:

                  But, display width is most important if you are using ZEROFILL option, for example your table has following 2 columns:

                  A tinyint(2) zerofill

                  A tinyint(2) zerofill

                  B tinyint(4) zerofill

                  B tinyint(4) zerofill

                  两列的值都是 1,A 列的输出将是 010001 对于 B,如下面的截图所示:)

                  both columns has the value of 1, output for column A would be 01 and 0001 for B, as seen in screenshot below :)

                  这篇关于MySql: Tinyint (2) vs tinyint(1) - 有什么区别?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

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

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

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

                            <tbody id='u9uMl'></tbody>
                        • <legend id='u9uMl'><style id='u9uMl'><dir id='u9uMl'><q id='u9uMl'></q></dir></style></legend>